Hello Anvesha Raikwar ,
Copilot’s ability to retrieve SharePoint list data depends on proper search indexing, permissions, connector setup, and list structure. Newly created or updated lists—especially large or complex ones—may not be indexed yet, causing retrieval failures. Permission issues or misconfigured connectors can also block access. Simpler test lists often work because they index faster and use basic columns.
To ensure reliable use at scale, verify indexing status, confirm correct permissions, properly configure connectors, monitor search diagnostics, and consider breaking up very large lists or using Dataverse for complex data.
Reference Document-
1.https://dori-uw-1.kuma-moon.com/en-us/microsoft-copilot-studio/knowledge-add-sharepoint
2.https://dori-uw-1.kuma-moon.com/en-us/microsoftsearch/semantic-index-for-copilot