Integration problem between SharePoint and bot - Issue with files

Like (0) Share

Report

Posted on 11 Dec 2023 18:19:58 by Gianfrancesco

Hi,

I'd like to create a bot that uses generative answers using public sites and a SharePoint, including both pages and files. Everything works fine except for SharePoint files.

Here an example.
This is a SP page:

SP page.png

and this is the SP file:
SP folder.png

SP file content.png

When I ask to my bot about Mario's pen, it is aware of it, but when I ask about his car, it doesn't give me an answer:

Bot answers.png

I tried the solutions in Microsoft Documentation with the Manual Authorization and Files.Read.All Sites.Read.All in the scope, but it didn't work.
I also checked other community post, but the solution was not helpful to me.

In addition I can give you informations concerns files authorization, but it seems to be correct.

SP file content Authorization.png

Can you help me, please? Thank you.

All responses (6)

Answers (1)

Verified answer

Gianfrancesco 13 on 19 Dec 2023 at 09:40:07

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

I've solved the issue.
The mistake was about the file format. In this link I found an information about supported file format:

I replaced the txt file with a docx and my Copilot bot was able to find it:

Thank you for your support.
adilei on 12 Dec 2023 at 14:33:39

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

Sorry, didn't see the "forbidden" error. You probably need to work with whomever it is who has admin permissions on the Graph Explorer app in your tenant (under "Enterprise Applications").
Gianfrancesco 13 on 12 Dec 2023 at 14:23:15

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

Yes, but if there is an authorization issue, the string doesn't matter, right? Maybe it doesn't give a result, but I think I have to solve the authorization issue. Have you got any idea how to solve my problem?
Thank you
adilei on 12 Dec 2023 at 11:53:03

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

Graph explorer should help you test whether Graph API is returning results. You should change SEARCH TERMS with the actual terms you are searching for 🙂
Gianfrancesco 13 on 12 Dec 2023 at 10:18:34

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

Hi,

I followed these steps for the settings:

Here the Post with Graph Explorer:
I don't know if it's correct.

Let me know. Thank you so much.
adilei on 11 Dec 2023 at 18:57:54

Like (0)

Report

Re: Integration problem between SharePoint and bot - Issue with files

1. Can you share the configuration of your app registration and copilot authentication settings?

2. Run your queries via Graph Explorer and see if any results are returned: Re: PVA Generative Answers and no content from Sha... - Power Platform Community (microsoft.com)