Power Platform Community Forum Thread Details

I have a custom connector (which is a MCP) and it is added to Copilot Studio agent , but the output from MCP (tool named execute_tool inside MCP) is very large which any model cant process . So but i want to display whole data to the user in response . Can we display it in batches ?? Is this kind of something possible in copilot studio ?? Please anyone provide guidance on this . Like if the data is having 5000 rows , how to display it to the user .

Categories:

Building Copilot Studio chatbots in Microsoft Teams

Hello CU27061617-0,

Copilot Studio cannot reliably process or display a very large MCP/tool response such as 5,000 rows in one call. The best approach is to implement pagination in the MCP/API itself and return only a small batch, for example 25–100 rows, along with a nextPageToken or page number. In Copilot Studio, create a topic/action flow where the user can type “next” to fetch the next batch. For very large datasets, the better UX is to show a preview in chat and provide a downloadable CSV/Excel link from SharePoint/OneDrive/Blob storage. Avoid sending the full dataset to the model; handle filtering, batching, and export outside Copilot Studio.
Reference Document-
1. Custom connector frequently asked questions for Copilot Studio, Azure Logic Apps, Power Automate, and Power Apps. | Microsoft Learn
2. Copilot-Studio/Knowledge_Source_Limitations_Solutions/copilot-studio-knowledge-limitations-guide.md at main · Rickcau/Copilot-Studio