Copilot Studio cannot use a SharePoint list as knowledge, but there is a workaround using Agent actions. The Agent can call a flow to get information about the SharePoint list columns and data types, then feed it into an AI Prompt along with the user's question to craft a SharePoint Rest API filter query. The list items are returned and the Copilot Studio Agent uses generative AI to craft a message and send the answer to the user. The article provides a step-by-step guide on how to create a Copilot Studio Agent, set up a Power Automate flow, and retrieve SharePoint list items using the workaround.
Login now to access my digest by 365.Training