You have a SharePoint document library packed with IT policies, each tagged with custom metadata columns: Document Status, IT Audience, Next Review Date, and a Document ID. You build a Copilot Studio agent and connect it to that library as a knowledge source. A user asks:
“Which IT policies are Active, targeted at Contractors, and due for review before the end of 2026?”
The agent returns a partial list. At the bottom of its response, it adds its own caveat:
“The search results do not include review date metadata for all documents, so this may not be a complete list.”
The agent already knows it’s failing. This is not a prompt engineering problem, and it is not a configuration mistake. It is a fundamental constraint in how Copilot Studio ingests SharePoint content, and it affects every organisation that relies on custom document library columns to classify and manage their content.

