Power Platform Community Forum Thread Details

I'm facing a challenge with a Copilot Studio flow and would appreciate any insights.

My Goal:
I have a cloud flow that triggers when a new .docx file is created in a SharePoint library. The goal is to:

Extract the plain text content from the .docx file.
Send this text to a specific, custom-built Copilot Studio agent with a prompt to generate a business plan.
Take the final text response from the Copilot agent.
Save that response as a new file in another SharePoint library.

What I've Accomplished:
The text extraction from the .docx file is working perfectly. I've built a robust process using OneDrive to unzip the file and an xpath() expression on the document.xml file to get the plain text. This part is 100% successful.

The Problem:
The issue is with the Execute Copilot action from the "Microsoft Copilot Studio" connector. I am required to use this specific agent, so I must use this action.

When I run the flow, I've checked the run history and confirmed that this action is asynchronous.

The raw output of the action shows a statusCode: 202 (Accepted).
The body of the output only contains a conversationID. It does not contain the generated text from the agent.

What I've Tried:

Inspecting Outputs: I've checked every available dynamic content "pill" from the Execute Copilot action (Body, Copilot response, etc.). At runtime, they all resolve to an object containing just the conversationID, not the final text response.
Adding a Delay: I tried adding a Delay of up to 2 minutes after the Execute Copilot action, hoping the output variables would eventually be populated with the final text. This did not work; the output was still just the conversationID.
Calling the action again: I tried calling Execute Copilot a second time, feeding the conversationID from the first call into the Conversation ID input parameter. The second call also only returned a new ID without the response from the first call's prompt.
Looking for another action: I've confirmed that the "Microsoft Copilot Studio" connector in my environment only has one action: Execute Copilot. There is no corresponding "Get Copilot response" or "Check status" action to retrieve the result using the conversationID.

My Question:

How can I retrieve the final text response from a Copilot Studio agent within the same Power Automate flow when the Execute Copilot action behaves asynchronously and the connector does not provide a corresponding action to get the result?

It feels like a "fire-and-forget" action with no native way to retrieve the response, which makes it very difficult to use for this kind of end-to-end automation. Is there a known pattern for this specific connector that I am missing?

Any help or insight would be greatly appreciated. Thank you!

Categories:

Calling actions from Copilot Studio

Hi @CR-01091441-0

Please please please show your flows. I mean no disrespect but how is it you are looking at it, but write words for us so we do not see it.

You have to use the ConversationID to retrieve from the actual Conversation.

You are correct Execute is Fire and Forget, it is not intended to do what you are asking.

Here is my question, why are you not just saving it into SharePoint from the Agent, why do you want it back in the Flow? My recommendation would be to create the Tool in the Agent that saves it to SharePoint.

Power Automate is not designed to intentionally be blocking (ok in some instances it is, but not as a whole).

You could create a Do Until loop and make it have a timeout of days or a week or whatever you want, then use the ConversationID to lookup the conversation but not to get details directly from the Agent, its :-( I am afraid not possible that way.

But you could pass a value from the Flow, to the Agent, use that value IN the agent to write the file/data and use that ID as an identifier. In the flow, Do Until for a bit, looking for a new value to appear in that other sharepoint that has the value in it and you know its done.

That or a dozen other ideas I have, I just need to understand why you want to use the agent at all, just use AI Builder in the flow and get what you need out and save it to sharepoint, skip Copilot.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey