Copilot Studio Knowledge Source Limitation When Iterating Over Multiple SharePoint Documents

This is a known limitation in Microsoft Copilot Studio, it’s optimized for retrieval, not full iteration across large SharePoint sets. So, instead of forcing it, use a hybrid pattern with Microsoft Power Automate to batch-process documents and store extracted metadata in a structured store such as Dataverse, then have the agent query that indexed data for complete results.