Skip to main content

Notifications

Copilot Studio - Bot Administration
Unanswered

PVA Generative Answers and no content from Sharepoint files or pages

(2) ShareShare
ReportReport
Posted on by 6

Hi All!

 

It should be easy but it is not. I have a simple bot with Generative Answers. It works when I have a source set on a public page like www.microsoft.com. However, I wanted the bot to use the information from a file or a page from Sharepoint. It returns literally noting. I managed to implement a Manual Authentication, register an app in Azure and granded the permision fo MS Graph for both file.read.all and sites.read.all. It still littelary return empty string. I check if the bot is autenticated by return the userID and it is. Of course the files and pages are shared with this user. No more ideas. I tried to use Graph Explorer and testes some random queries as the userID and it could find some files with keywords however it works only as GET requests, not POST - not sure if this is a difference here.

 

Then, I gave up. Any ideas what to do more?

  • GinoMatthys Profile Picture
    GinoMatthys 14 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    I've a "working" bot and I don't get either a result on the same question. I suppose this kind of questions are not supported. My Bot gives not the same results when you ask same questions on different times. I've now a ticket raised because my bot crashes regular with a system error. 

    GinoMatthys_0-1709640683466.png

    GinoMatthys_1-1709641008615.png

     

  • chrisnec Profile Picture
    chrisnec 2 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    FWIW, I'm having the same issue. I've followed all the steps here:

    https://learn.microsoft.com/en-us/microsoft-copilot-studio/nlu-generative-answers-sharepoint-onedrive

     

    And I still can't get CoPilot to recognise anything in a very basic SharePoint site.

    There are literally 3 documents in there and CoPilot doesn't recognise even basic requests like:

    "Is there a document with X in it?"

  • GinoMatthys Profile Picture
    GinoMatthys 14 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    Hi,

    Have you found solution for this. I've exactly the same problem.

    kr

    Gino

  • darylvogan Profile Picture
    darylvogan 274 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    I'm able to get graph results. The bot keeps going to the fallback topic. If I redirect to the conversational boosting topic, i get an empty answer from the generative answer action.

     

    Management really want to see a demo of this working, so we can commit to further research . Please help if you're able. I appreciate it.

  • darylvogan Profile Picture
    darylvogan 274 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    Interested as well. Can't get this working. Please help.

  • DamianSu Profile Picture
    DamianSu 10 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    Hello, for me the same problem. Did everything in Azure for Manual Authentication in PVA twice. Still I'm not able to have a fun with searching through docs stored in sharepoint. 

     

    I tried to query MS Graph and here are results:

    {
        "error": {
            "code": "Forbidden",
            "message": "Access to OneDriveFile in Graph API requires the following permissions: Files.Read.All or Sites.Read.All or Files.ReadWrite.All or Sites.ReadWrite.All. However, the application only has the following permissions granted: User.Read",
            "target": "",
            "httpCode": 403
        },
        "Instrumentation": {
            "TraceId": "c8d5d71a-faa0-e7fe-c39c-4b5356afeb93"
        }
    }
     
    Even if I have all permissions mentioned in documentation:
    Damian2_0-1700746081934.png

     

     

     @HenryJammes can you suggest something?

  • Thenerdy Profile Picture
    Thenerdy 58 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    Hey @HenryJammes - I am trying to do the same - and running your query I get a result -

     

       "givenName": "Megan",
        "jobTitle": "Auditor",
     
    Not sure if I should post all the other information but I am getting the same issue. Pointing the bot to our internal sharepoint server that has wiki information and information about the company returns nothing. Yet pointing it to the website works well.
     
    Any other pointers? I have set up the security with the right perms and no errors are shown, it just responds with generic phrases. How can I get it to read the information on our sharepoint directory/site files?
     
    Messages:
     
    I’m sorry, I’m not sure how to help with that. Can you try rephrasing?
     
    Or 

     

    Escalating to a live agent is not currently configured for this bot, however this is where the bot could provide information about how to get in touch with someone another way.

    Is there anything else I can help you with?

  • HenryJammes Profile Picture
    HenryJammes on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    Hi @TomProject,

     

    I understand you setup the SharePoint integration with the manual auth (AAD v2 with appropriate and admin-consented permissions). I.e. these settings: https://learn.microsoft.com/en-us/power-virtual-agents/nlu-boost-node#authentication

    But yet, SharePoint isn't returning results.

     

    Can you test within PVA, with the test pane, when 'Teams Only' authentication is configured?

    Do you still get no result?

     

    Also, I'd love to know if you get relevant results over the Graph API.

    Using the Graph Explorer, log in, do a POST on https://graph.microsoft.com/v1.0/search/query 

     

    {
        "requests": [
            {
                "entityTypes": [
                    "driveItem",
                    "listItem"
                ],
                "query": {
                    "queryString": "SEARCH TERMS filetype:docx OR filetype:aspx OR filetype:pptx OR filetype:pdf path:\"DOMAIN.sharepoint.com/sites/SITENAME"
                },
                "from": 0,
                "size": 3,
                "QueryAlterationOptions": {
                    "EnableModification": true,
                    "EnableSuggestion": true
                }
            }
        ]
    }

     

  • TomProject Profile Picture
    TomProject 6 on at
    Re: PVA Generative Answers and no content from Sharepoint files or pages

    I can see also report as below "no search results" - no idea why BOT doesn't have access to SHP, even wjen the site and bot owner is the same user. Any idea? 

    test.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics