I am trying to create a copilot inside copilot studio, which do the following:-
1) Call a Power Automate Flow to return the documents from a SharePoint online document library.
2) I will select the File name and File URL only
3) Send the documents to Copilot.
4) then i need to build a list inside a Copilot Question, to select a Document, as i want to send the document to another power automate flow.
Here what i have :-
1) Inside Copilot i am calling the flow:-
2) Here is the flow. Where i got the files, Select the Name & Url, initialize the variable with the output of the Select, and return the variable to Copilot, after converting the variable into json() :-
here is sample of the response from the flow:-
{
"r":
"
[
{\"Name\":\"New Microsoft Word Document (4)\",\"Url\":\"https://**.sharepoint.com/sites/Copilot/New/New%20Microsoft%20Word%20Document%20(4).docx?d=w36a23c408c844a4ebf4d444f8777a975\"},
{\"Name\":\"VScompleted\",\"Url\":\"https://**.sharepoint.com/sites/Copilot/New/VScompleted.png\"},
{\"Name\":\"Salary\",\"Url\":\"https://***.sharepoint.com/sites/Copilot/New/Salary.docx?d=wcf24819ffdcf4616873cd50c24f1b1d0\"}
]
"
}
but how i can convert this JSON to a table inside Copilot and show this table as a question to the user, to select a specific document?
Thanks
