You’re not doing anything wrong here. What you’re running into is just how Copilot Studio works today, not a problem with your SharePoint list or how you set things up.
Right now, the Browse items picker in Copilot Studio is really built for document libraries (files and folders), not for SharePoint Lists. That’s why your list never shows up there, no matter how many times you open it, refresh, or paste the URL. You can see the current behavior in Microsoft’s docs here:
To work around this, I’ve used the following approaches:
1) App registration in Entra ID (Azure AD)
- Create an app registration and give it permissions to read SharePoint (for example, Sites.Read.All and any list-related permissions your pattern requires).
- Use this when you’re calling SharePoint via custom APIs or HTTP actions and need secure, app-based access rather than just user delegation.
2) Power Automate as a bridge (my go‑to pattern)
Let Power Automate sit between your Microsoft List and your Copilot agent so the bot never talks to the list directly.
Steps in Power Automate:
- Trigger the flow – Use a Copilot/HTTP trigger so the agent can call it on demand.
- Fetch data – Add Get items (SharePoint) to read from your Microsoft List.
- Send data back to Copilot – Shape the results as JSON or a simplified text response and return it to the bot in the flow’s response.
3) Store data in Dataverse (if you want more control)
If you don’t want Copilot to hit the original list directly, or you want richer schema/security options, you can sync the list into Dataverse and let the agent work against Dataverse tables instead.
4) Use SharePoint REST API for advanced scenarios
When you need more complex filtering or queries, you can call the SharePoint REST API (for example via “Send an HTTP request to SharePoint” in a flow) and then return those results to Copilot.
✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.
❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).
🏷️ For follow-ups @Sajeda_Sultana
