Unanswered

PVA Generative Answers and no content from Sharepoint files or pages

(2) Share

Report

Posted on by TomProject

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?

Categories:

Bot administration

I have the same question (0)

All responses (9)

Answers (0)

TomProject 6 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
            }
        }
    ]
}

Was this reply helpful? Yes No
Thenerdy 58 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
DamianSu 10 on at

Like (0)

Report
Copy link

Link copied!

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:

@HenryJammes can you suggest something?

Was this reply helpful? Yes No
darylvogan 274 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
darylvogan 274 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
GinoMatthys 14 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Have you found solution for this. I've exactly the same problem.
kr
Gino

Was this reply helpful? Yes No
chrisnec 2 on at

Like (0)

Report
Copy link

Link copied!

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?"

Was this reply helpful? Yes No
GinoMatthys 14 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No