Copilot Wont Search Sharepoint List

(2) Share

Report

Posted on by DS-18092222-0

Hi everyone,

I'm trying to use Copilot Studio with a SharePoint List as my data source, but I keep encountering an issue. Here's what I've done so far:

I've selected and enabled the SharePoint List as my data source in Copilot Studio, and I can confirm it is connected.
I have turned on Generative AI.
However, whenever I try to use the Copilot functionality, it states that it doesn't have access to the SharePoint List.

Has anyone encountered this issue or know of any additional steps I may have missed to grant access to the SharePoint List? Any insights or troubleshooting tips would be appreciated!

Thanks in advance.

Categories:

General topics

All responses (5)

Answers (0)

Sort by

Mahesh Chintha 173 on at

Like
a
(0)

Report
Copy link

Link copied!

Copilot Studio cannot generate responses from SharePoint List. Try leveraging Dataverse table for this use case.
Suggested answer

fchopo 8,003 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please, in order to use SharePoint list, I would recommend enabling the manual authentication in your copilot, using Azure Active Directory, and requiring users to sign in. You can find more information here: https://learn.microsoft.com/en-us/microsoft-copilot-studio/configuration-end-user-authentication?wt.mc_id=DX-MVP-5004680

You can watch an excellent video by Dewain Robinson on how to do that step-by-step: https://www.youtube.com/watch?v=rw4IwR68Wc0

Hope that helps!

Ferran
ShaneMeisnerTH 195 on at

Like
a
(0)

Report
Copy link

Link copied!

At the Power Platform Conference this year I spoke to a few experts on this with different answers.

1. They continue to try and add a native connection to Lists. Issue is the amount of Metadata stored in lists and the current search index it would take.

2. Use Dataflows to capture the date from Lists and store it in Dataverse Tables.
We've tried this but are currently still Experiencing incomplete results to questions.

3. Extending the Copilot Agent with M365 Copilot which does have a connection to SharePoint lists.

Still waiting to get on the Beta test list here at our company for M365 Copilot so I can test this last one out.
Suggested answer

Vinoth Selvam 1,597 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello DS-18092222-0 ,

For using SharePoint as Knowledge source, i would suggest to go for Manual Authentication that is recommended in the documentation.

I have tried using SharePoint sites as knowledge source, but the actual source is files inside the SharePoint. It works as expected. Hope the same goes for SharePoint list also.

Kindly follow every step mentioned in the below reference links.

https://learn.microsoft.com/en-us/microsoft-copilot-studio/configuration-end-user-authentication#authenticate-manually

https://learn.microsoft.com/en-us/microsoft-copilot-studio/configuration-authentication-azure-ad

Thanks.
Suggested answer

Vinoth Selvam 1,597 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi DS-18092222-0,

One more best way which i can suggest is to develop a Custom Action.

Build an Action by using the SharePoint connectors. I can read the information from the SharePoint List.

Many times i have felt that structured data like Excel in knowledge source is not working as expected. So i follow the same approach of creating Custom Actions.

Thanks.