r/copilotstudio•
thenyx

Have Copilot Agent use JSON file for responses to user?

So, I've build an Agent with a few different Power Automate (PA) flows feeding different topics;

  1. Orchestrator, to declare some variables etc. and setup file creation, as well as respond to the Agent (and user) to prevent timeouts, then trigger 2nd flow
  2. Worker, to pull data and process, create folder in Sharepoint per MMDDYY, parse and dump data into Excel file as well as a JSON of the info for the Agent to read, then trigger 3rd flow
  3. Q&A, to pull JSON file, trim it, then respond to Agent and make the info available to have the user be able to ask questions about the info (e.g., "what are the top 3 issues?")

Issue is, I've confirmed that the Q&A flow does successfully push the info to the Agent (I added a Message node to just output what `analysisData` gets from the JSON). All 3 PA flows run successfully. The Agent does not throw any errors. But the Agent just will not answer questions at all, when prompted.

I'm thinking it could be a JSON file size issue (this is why I have a `trimData` compose in the Q&A flow)- the avg side of the JSON from the worker flow in Sharepoint is ~150-200kb.

Any other ideas for how to fix this?

Posted Mar 5, 2026, 7:47 PM UTC

16
Loading comments…