Issue with "Execute Copilot" Action in Power Automate

(4) Share

Report

Posted on by SN-09041430-0

Hello Community,

I am facing an issue with the "Execute Copilot" action in Power Automate. Despite sending prompts to Copilot, I am not receiving any response. The response object from Copilot is empty. Here is a detailed explanation of my setup and the steps I have taken:

Setup:

Trigger: When an item is created in a SharePoint list.
Actions:
- Get attachments: Retrieve file attachments from the SharePoint list item.
- Get items: Retrieve text content from the SharePoint list item.
- Execute Copilot: Send a prompt along with the file and text to Copilot for analysis.
- Parse JSON: Parse the JSON response from Copilot.
- Send an email (V2): Send the parsed response via email / Send the "Copilot Answer" Object" via email.

Prompt Message:

{
    "prompt": "Provide the answer in JSON format with the fields: 1. Contract requirement, 2. Is it present? (Yes / No / Needs to be checked), 3. Justification (Why 'Yes, No' or 'Needs to be checked'? Include: How sure are you that your answer is correct in percentage?), 4. Source (Where exactly in the contract are the relevant details found?)",
    "fileName": "@{outputs('Get attachments')?['body/name']}",
    "fileContent": "@{base64(outputs('Get attachments')?['body/content'])}",
    "textContent": "@{outputs('Get items')?['body/value']}"
}

JSON Schema for Parsing:

{
    "type": "object",
    "properties": {
        "Contract requirement": {
            "type": "string"
        },
        "Is it present?": {
            "type": "string",
            "enum": ["Yes", "No", "Needs to be checked"]
        },
        "Justification": {
            "type": "string"
        },
        "Source": {
            "type": "string"
        }
    },
    "required": ["Contract requirement", "Is it present?", "Justification", "Source"]
}

Issue:

The response object from the "Execute Copilot" action is empty.
No data is returned despite sending the prompt and necessary data.

Steps Taken:

Verified the prompt message for clarity and precision.
Checked the configuration of the "Execute Copilot" action.
Ensured proper connection and permissions.
Tested the flow with different inputs.
Reviewed troubleshooting guides for Copilot.

Request for Help:

I would appreciate any guidance or suggestions on how to resolve this issue. Is there something I might be missing in the configuration or setup? Has anyone else faced a similar issue and found a solution?

Thank you in advance for your help!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (1)

Report

Hi@SN-09041430-0

If you look at the connector now, it doesn’t return anything but a conversation I’d

in the connector you don’t get the actual response and there are no actions to go get it from this trigger.

So what you are seeing is exactly how it’s working for now.

https://learn.microsoft.com/en-us/connectors/microsoftcopilotstudio/

while completely silly to have it this way, that is the answer (it’s behaving per the documentation)

if you don’t mind marking as the answer which I realize is a lame answer but is

cheers

Was this reply helpful? Yes No
SN-09041430-0 6 on at

Like (0)

Report

Hi @Michael E. Gernaey,

Thank you for your previous response. I have a follow-up question regarding the "Execute Copilot" action in Power Automate.

I need to send a file and text from a SharePoint list to Copilot via Power Automate. Copilot should check if the text is present in the file, either in the same or a different form (rephrased). Copilot should then return the result.

Do you have any ideas on how to achieve this?

Thank you in advance for your help!

Was this reply helpful? Yes No
ricardodesouza 2 on at

Like (0)

Report

As far as I tested until now, the response is presented only in the scenario where an agent is calling another one. But stills is a very limited scenario, it would be much more useful if the response is available for Power Automate too.

Regards

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SN-09041430-0

This to me is more of an AI Action than an Agent Action issue.

Again the action isn't going to return you anything right now, so it stinks. So unless you have it write it somewhere, that you can check for... its not very useful from within a flow atm IMHO. Its almost a fire and forget right now.

Still the same answer as before.

Was this reply helpful? Yes No
CU09070711-0 2 on at

Like (0)

Report

From what I can tell, I agree with the previous answers.

However, I suggest you don't get stuck on using the "Execute Copilot" action.

I recommend trying to the intended results with the "Run a Prompt" action. For me, it wasn't very clear how to get the "Run a prompt action" to do what I wanted. However, here is a good explanation: Create a prompt | Microsoft Learn

Basically, when you select Run a Prompt and then Create Custom Prompt you need to do two things. When creating the custom prompt write the prompt and define variables. When you use your custom prompt through the Run a prompt action you will be able to assign the variables you have defined in your custom prompt from data in your power automate flow.

There may be use cases that this doesn't work. However, you can do a lot here (and get text back).

Was this reply helpful? Yes No