Integrating Copilot 365 with Power Automate and SharePoint

Hello everyone,

I'm facing an issue with integrating Copilot 365 in a Power Automate flow that I've set up. Here's my use case:

I've created a Power Automate flow that performs OCR analysis on documents. The results of this analysis are then exported to a SharePoint list. My ultimate goal is to use Copilot 365 to analyze these exports directly within the SharePoint list and provide me with answers to specific questions regarding this data.

Unfortunately, I haven't been able to get Copilot 365 to read the text or rows from my SharePoint list. So far, the only way I've found to get responses from Copilot is by using the "public" web version of Copilot 365, where I can open a text file and ask questions about it.

Has anyone else encountered this problem? Is there a solution to allow Copilot 365 to analyze data directly from a SharePoint list without needing to go through a text file? Or is there a more efficient way to leverage my information using Power Automate and SharePoint?

Thank you in advance for your help!