Integration problem between SharePoint and bot - Issue with files

(0) Share

Report

Posted on 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 at

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 at

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 at

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 at

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 at

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 at

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)