Generative Answers Sharepoint

[automationguy56]

HI Team

I used Generative Answers node with specific SharePoint url  as data source. But the response is empty. I have configured User authentication and App registration as per the documentation. Any idea why the response is empty.

[automationguy56]

Does any one have an idea or implemented above scenario ?

[MattJimison]

Under Settings -> AI Capabilities I'd recommend setting Bot content moderation to Low initially, as I've seen scenarios where no results were returned until this was changed. Have you tried this with a bot that is setup for Teams Only authentication, so that you don't have to configure SSO? I'd recommend also looking at that to see if you can get results that way, since you wouldn't need to work with an Azure app registration in that case and could eliminate that configuration as a potential reason for the issue.

---

Find this post helpful? Please mark it as the solution and/or provide kudos so that it will help others in the future.

Cheers,
Matt

[automationguy56]

Thanks @MattJimison  for your response.

1. Teams Only Authentication - When I perform this I am getting below error

2. When I Use AAD authentication, I am able to get some responses now from the files present in the SP documents folder like PowerPoint. But it is not able to  get the data in the ASPX page 

Does this Generative Answers command is capable of look in to SharePoint page and give the answers?

Regards,

M

[HenryJammes]

---

@automationguy56 wrote:

Thanks @MattJimison  for your response.

1. Teams Only Authentication - When I perform this I am getting below error

2. When I Use AAD authentication, I am able to get some responses now from the files present in the SP documents folder like PowerPoint. But it is not able to  get the data in the ASPX page 

Does this Generative Answers command is capable of look in to SharePoint page and give the answers?

Regards,

M

---

Hi @automationguy56,

Here is the documentation for the Generative Answers SharePoint/OneDrive data source:

https://learn.microsoft.com/en-us/power-virtual-agents/nlu-boost-node#connect-to-a-sharepoint-site-o...

The error you shared is a known, non-blocking (doesn't prevent from saving or publishing the bot).

It appears when you configure the bot security to 'Teams Only'.

You need to setup AAD v2 with admin consent provided for the documented Graph API permissions in order to publish your bot and use it with Generative Answers over SharePoint / OneDrive.

Content from SharePoint aspx pages should be returned (it's documented and I have it working).

Generative Answers over SharePoint / OneDrive summarizes content retrieved from the Graph API.

Have you tried to see what results are returned when you use the Graph Explorer?

Using the Graph Explorer,

1. Log in,
2. Do a POST
3. Use https://graph.microsoft.com/v1.0/search/query
4. Use & edit the below query to match your search and SharePoint site.
5. Run 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
            }
        }
    ]
}

[automationguy56]

@HenryJammes ,

I have tried the Graph Explorer as mentioned above. It is not giving the results as expected i.e, even though have passed the aspx SharePoint link it is not getting the data from it. Instead it is giving results from some other SharePoint page.

below is my query body:

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

[HenryJammes]

Thanks @automationguy56 

Are you sure about this part? I wouldn't expect the site name to end with aspx.

I also assume that use a different domain:

domain.sharepoint.com/sites/CompanyHolidays.aspx

[automationguy56]

@HenryJammes 

I have used my company SharePoint domain in place of domain.

Yes. My SharePoint website is showing aspx in the url and also I have tried with the sites don't have aspx in the url but still the no response is coming

[HenryJammes]

If the Graph API doesn't return results for your search query, I don't think generative answers can.

I've used my own SharePoint site on my test tenant, pplatform.sharepoint.com/sites/KnowledgeBase, and the Graph API call worked for me.

[Wisam]

@HenryJammes, I have the same problem with PVA not returning results from aspx pages. The results come back as expected in Graph Explorer though. I even replicated the Graph Explorer's permissions in the AAD app, with no luck.

Also, tried Security -> Authentication -> Only for Teams: still no luck.

Here's the result from Graph Explorer, which shows that it can find matching content in the aspx page when searching for "request vacation":

And attached is the bot's dialog.json, which shows that it can't find matching content.

Any troubleshooting tips?