Skip to main content

Notifications

Publish & Channel Management
Answered

Integration problem between SharePoint and bot - Issue with files

Posted on by 13

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.

  • Verified answer
    Gianfrancesco Profile Picture
    Gianfrancesco 13 on at
    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:

    Gianfrancesco_0-1702978521942.png

     

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

    Gianfrancesco_1-1702978756197.png

     

    Thank you for your support.

  • adilei Profile Picture
    adilei on at
    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 Profile Picture
    Gianfrancesco 13 on at
    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 Profile Picture
    adilei on at
    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 Profile Picture
    Gianfrancesco 13 on at
    Re: Integration problem between SharePoint and bot - Issue with files

    Hi,

     

    I followed these steps for the settings:

    App Authentication.png

    App Permissions.png

    App Scopes.png

    Bot Authentication.png

     

    Here the Post with Graph Explorer:

    GraphPost.png

    I don't know if it's correct.

     

    Let me know. Thank you so much.

  • adilei Profile Picture
    adilei on at
    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)

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,997

#3
Expiscornovus Profile Picture

Expiscornovus 1,708

Leaderboard

Featured topics