Power Platform Community Forum Thread Details

Creating fully filled in Excel file from questionnaire template in CoPilot Studio

We have a use case for Copilot to automatically answer a security questionairre which I could use some help on.

We have a security questionnaire in Excel (template on SharePoint) where we want to scan vendor-supplied documents stored elsewhere SharePoint as part of the knowledgebase, building in public-facing websites supplied by the user and then answer the questions line by line based on the knowledgebase, filling in the answer column. At the end, the Copilot should output a filled in excel document stored with a new name. Ideally this process would be kicked off automatically from a Flow on a SharePoint List Item when a user launches it.

I'm quite stuck on this unfortunately.

I've created the Copilot and it is able to answer the questions from the KB when I type them in manually.
I've created Topics in the CoPilot to set the Vendor and public websites from the prompt. then adding in the public website URL to the KB
I've tried to setup an action which reads in the spreadsheet table of questions etc. line by line and then tried to execute the Copilot from within the flow, building the prompt using the question, to get an answer.

The problem is that I can't get the response from CoPilot within the Flow, only the conversation ID. This has made me wonder if my approach is right here or whether this is even possible. Potential other approaches are:

Create Topics to infer the answers to the question from KB then pass this to a PA Flow Action as parameters, but as this would need to 'hard-code' the questions in the CP (I don't think I can send an array of responses to the Flow) it's not my preference, however it does seem to be more designed so that the CP kicks off the flow action and not the other way around, and that once the action is kicked off, there is no way for the flow to request more information from the CP conversation.
I saw on Google that somebody created a CPS Action to email the output of the CP runs to email line by line then create another flow to pick up all the emails and enter the data in a spreadsheet. This seems really like a flimsy work around which I'd like to avoid
Use HTTP to call a flow passing in a JSON payload of the answers to the questions from Copilot
Use AI Builder within the flow to answer the questions, but I'm not clear on whether I should be doing this or using the CoPilot I already created, it seems like duplication.

Any suggestions from people that have already done this?

Categories:

General

Quick Links

Leaderboard