Copilot Studio SharePoint List Knowledge Workaround


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.


Article 5w

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time