Power Platform Community Forum Thread Details

Hi,

I'm building a contracts assistant using Microsoft Fabric Data Agent (MCP) + Copilot Studio, and I'm stuck on getting a custom flow (created inside Copilot Studio) to run as a tool from the agent.

I have a Data Agent in Fabric connected to a Lakehouse table, this data agent is exposed to Copilot Studio as an Agent tool. In Copilot Studio I created another agent that:

Uses a Fabric Data Agent to generate NL2SQL queries from natural-language questions.
Returns a preview table with sample rows.
Displays the exact SQL query that can be used to retrieve the full result set.
After showing the preview, the agent asks the user if they want to download the full data to OneDrive.
If the user answers "yes", a custom tool is triggered that:
1. Receives the agent’s last message (System.LastMessage.Text),
2. Parses and extracts the SQL query from that message,
3. Executes the query against Fabric, and
4. Saves the full result set as a CSV file in the user’s OneDrive.

If I test the flow directly in Copilot Studio (manually pasting a sample message that contains the SQL query), it runs successfully and creates the CSV in OneDrive. I can see these runs under Activity for the flow. However, when I use my Copilot Studio agent and ask the agent to download the data to my OneDrive, I get only a generic error in the chat:

Error code: SystemError. Conversation ID: <guid>. Time (UTC): <timestamp>

And importantly: no new run appears in the flow's Activity. So it looks like the flow/tool is never actualy triggered.

What I've already checked:

The flow is listed as a tool and is enabled (condition set to "Agent may use this tool at any time")
The flow plan is "Copilot Studio" and status is "Activated".
My agent is running in Copilot Studio using the same tenant/account that owns the flow and OneDrive
I can manually run the exact same SQL on the Fabric endpoint and it returns rows (so it's not an empty result causing issues).

Why would the agent show SystemError but the flow never appear in Activity? Is there anything else I must configure? Is there any way to get more detailed logs about why the tool call failed before reaching the flow?

If it helps, I can share screenshots of the flow design and configuration. Any guidance or examples of a similar setup would be very helpful.

Thanks!

Categories:

Calling actions from Copilot Studio

Hi @Matheus Zaghi,

A SystemError with no runs showing in Activity means the flow is never being triggered. The failure is happening before the tool call reaches Power Automate.

In most cases, this is caused by one of these:
1. Tool parameter mismatch
If the flow trigger expects parameters that don’t match the tool definition in Copilot Studio, the planner will reject the call.
Try temporarily removing parameters or sending a simple hard-coded value to confirm.

2. Environment or connection issue
Make sure:

The flow is in the same environment as the agent
All flow connections are valid (no warnings)
The flow is fully activated as a Copilot tool

3. Test with a very simple tool
Create a test tool flow (just a Compose + Send email).
If that runs, the issue is inside your original flow (Fabric/OneDrive/inputs).
If it doesn’t run, the issue is in the tool setup.

This should help narrow down where the failure is happening. Let me know if you want to share a screenshot of the tool configuration.