Copilot connecting to Sharepoint data does not work

Like (0) Share

Report

Posted on 26 Feb 2024 13:19:01 by MB29

Hello community,

i am having issues connecting the Copilot Studio Bot with our Sharepoint Data.

I tried every guideline together with our Admin but we don´t get it running.

Generative answers with Search and summarize - Microsoft Copilot Studio | Microsoft Learn

Configure user authentication with Microsoft Entra ID - Microsoft Copilot Studio | Microsoft Learn

Configure user authentication - Microsoft Copilot Studio | Microsoft Learn

Configure single sign-on for the Microsoft Copilot Studio app in Teams - Microsoft Copilot Studio | Microsoft Learn

To be mentioned is that when i use the Teams and PowerApps only Security Setting i get the answers from the SharePoint Site but as soon as we switch to manual authentication i don´t get a result and also no error message.

Is there a way to debug or check where the Problem exactly is?

When switching the setting to manual the bot asks for authentication and opens a popup with a number i have to prompt into the bot and then i should be authenticated!?

So then i ask my question which gets a response in the only Teams security settings but does not get a response when in manual setting, but also no error message?!

Here are 2 Screenshots from the Copilot Studio Authentication setting and the Permission setting in Azure.

We also tried to leave the Token exchange URL plank, but does not work either :(.

Any ideas or Tipps are very well appreciated 🙂

thx in adv.

Manfred

Categories:

General

All responses (8)

Answers (1)

adilei on 21 Mar 2024 at 12:00:26

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

Here is a troubleshooting guide for Gen Answers over SharePoint: Generative answers don't return a response - Microsoft Copilot Studio | Microsoft Learn
halbot 6 on 21 Mar 2024 at 11:22:14

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

Thanks this saved my day, I was following this page which did not mention this
https://learn.microsoft.com/en-us/microsoft-copilot-studio/configuration-authentication-azure-ad
Which doc did you find this in?
GilVTL 19 on 20 Mar 2024 at 17:52:06

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

I figured out my issue. In Azure, the Grant Admin Consent delegation was not applied to ALL the API/Permissions. Without that, the permission wasn't working completely.
MB29 67 on 05 Mar 2024 at 07:37:01

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

at the bottom of the authentication in Copilot Studio Authentication
here you have to add: profile openid Sites.Read.All Files.Read.All
adilei on 04 Mar 2024 at 20:20:57

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

Under authentication
GilVTL 19 on 04 Mar 2024 at 20:09:12

Like (0)

Report

Re: Copilot connecting to Sharepoint data does not work

I am facing a similar issue, but I'm unclear on what you mean. Where is the "scopes" setting in Copilot?
MB29 67 on 27 Feb 2024 at 08:54:03

Like (1)

Report

Re: Copilot connecting to Sharepoint data does not work

That´s it. Thx much!
Was kinda confused with the Copilot Guideline where only profile and openid was mentioned as scope, but i have seen now that the guideline has been updated with a prominent infobox 🙂

thx again

br
Verified answer

adilei on 26 Feb 2024 at 21:58:49

Like (1)

Report

Re: Copilot connecting to Sharepoint data does not work

You are missing Files.Read.All and Sites.Read.All from the "scopes" setting in your copilot.