Insane Copilot Studio SharePoint List Knowledge Workaround!!

SharePoint lists can't be added as knowledge to a Copilot Studio Agent but you can use a little known hack with Agent actions instead. And the results are amazing

The Agent can use a flow action to determine the SharePoint list columns and data types. Then it passes this information to an AI prompt, which writes a SharePoint REST API filter query. The filter query fetches the SharePoint list items we need, and Copilot uses generative AI to respond with the final answer.

Video Chapters 🎬
[00:00:00] Use A SharePoint List As Knowledge Demo
[00:02:32] Create A New Agent u0026 Flow Action From Scratch
[00:05:38] Setup A SharePoint List With Text, Numbers u0026 Dates
[00:06:27] SharePoint HTTP Action To Get List Columns u0026 Data Types
[00:14:56] AI Prompt to Generate SharePoint REST API Filter Query
[00:20:23] Add Prompt Action To Flow And Fetch SharePoint List Items
[00:23:59] Respond To The Agent In Copilot Studio
[00:26:25] Configure Agent Action u0026 Inputs In Copilot Studio
[00:29:22] Test Your Copilot Studio Agent

Follow along with these written instructions ✍
https://www.matthewdevaney.com/copilot-studio-sharepoint-list-knowledge-workaround/

Code Snippets 👨‍💻

_SharePoint HTTP URI to Get List Columns And Data Types:_
_api/web/lists/getbytitle('@{triggerBody()?['text_1']}')/fields?$select=Title,InternalName,TypeAsStringu0026$filter=CanBeDeleted eq true


_AI Prompt To Generate SharePoint REST API URI:_

Objective:
Generate a valid URI for use in the Power Automate action \