Passing Agent Responses to Flows

(0) Share

Report

Posted on by razor7tech

Hello group!

I am new to this forum. I am not a developer, and that has caused me to rely too heavily on the Copilot bot to help me solve an issue I'm having. I seem to be in a *loop Copilot cannot break.

I created an Agent that searches my company intranet for obsolete or outdated content and returns some details I ask for; URL, owner, reasoning, etc. It works great!
I merely want to add the functionality that the results also be handed off to a Flow that will export the results into an Excel spreadsheet and email it to me as an attachment.

Copilot helped me create the flow, and it works - independently. It seems like it should be such a small task to get my agent to trigger my flow and pass along the payload, but I have spent far too much time troubleshooting with Copilot and my test results either provide a *JSON error in the Parse JSON node of my flow, or my flow doesn't trigger at all. This is the loop I am in.

Here is the Parse JSON node error I get from my flow prior to the last time the flow didn't trigger at all. I don't know if anyone can help me, but I am trying to look outside of the Coplilot bot for help. Thank you in advance to anyone that is willing to help!

Parse JSON node error: Action 'Parse_JSON' failed: Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

I'm sure there is a lot more detail missing that needs to be provided for actionable help to be given, but I'm just waiting to see what details you need.

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (4)

Answers (0)

Prasad-MSFT Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Why This Happens

The agent is not passing the results to the flow, or

The flow is not receiving the data in the expected format, or

The trigger or input variable in the flow is not set up to receive the data from the agent.

How to Fix
1. Ensure the Agent Passes Data to the Flow
In Copilot Studio, when you call the flow, make sure you are passing the results (the data you want in Excel) as an input parameter to the flow.
Example: If your agent stores results in a variable called SearchResults, pass SearchResults to the flow.
2. Set Up the Flow Trigger Correctly
Use the “When a Power Virtual Agents calls a flow” trigger in Power Automate.
Add an input parameter (e.g., “results”) of type text or array, depending on your data.
3. Parse the Input in Power Automate
In your flow, the first step after the trigger should be to use the input parameter.
If you’re using Parse JSON, make sure you are parsing the correct dynamic content (the input from the agent).
To get the correct schema for Parse JSON:
Run the flow once with sample data.
Copy the output from the run history.
Use it to generate the schema in the Parse JSON action.
4. Handle Nulls
Add a condition before Parse JSON to check if the input is not null.
If it is null, send an error message or skip the step.

Was this reply helpful? Yes No
Suggested answer

deepakmehta13a 142 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The error you're seeing usually occurs when the Parse JSON action receives a null input. In Copilot-to-Flow integrations, this typically means the agent is not passing values correctly into the flow trigger.

Make sure you're using the "When an action is called from Copilot" trigger and have defined input parameters (like URL, owner, etc.). Then map those variables properly from your agent.

If you're already passing structured inputs, you actually don’t need the Parse JSON action at all—you can directly use the dynamic values in your flow.

Also, ensure both the agent and flow are published after making changes, as the flow may not trigger otherwise.

If you still face issues, sharing your trigger configuration and how you're passing inputs from the agent would help troubleshoot further.

Hope this helps,

If this helps resolve your issue, please consider marking the response as Verified so it can help others facing a similar scenario.

If you found this helpful, you can also click “Yes” on “Was this reply helpful?” or give it a Like.

Was this reply helpful? Yes No
Suggested answer

Admin.Nick2 22 on at

Like (1)

Report
Copy link

Link copied!

In your flow, make sure you are returning the right value. I'd recommend to test directly in the flow. The agent hides the info you need to debug.

Was this reply helpful? Yes No
razor7tech 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for your valuable input! I am going to utilize all of your advice and see if that helps. After I repair my agent that the Copilot bot had me break yesterday, if I still get JSON configuration errors, I am going to share my trigger configuration that's being passed from my agent with you to see if a deeper dive will help.

Some forums never get responses. I really appreciate yours!

Was this reply helpful? Yes No