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.
Hi @HenryJammes , as you suggested i tried with Graph explorer it gives the expected aspx page in result (as rank 1), but still i am not getting aspx pages in pva bot result. I am using AAD authentication with below permissions.
What i am missing. Can you please share you API permissions you have and any special settings at sharepoint level/pva level i need to set?
Interesting find: I found that if I follow the following steps, the bot can reference info in aspx pages:
It even adds a reference to the aspx page instead of the PDF document:
So it looks like the bot is pulling the information from the PDF, and because the PDF includes the aspx page's URL in the footer (default behavior when you print an aspx page to PDF), it's smart enough to reference the aspx page's URL in the answers.
@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?
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.
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
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
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
}
}
]
}
@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:
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,
{
"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
}
}
]
}
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
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
stampcoin
6
Artur Stepniak
5
Super User 2025 Season 1
Michael E. Gernaey
4
Super User 2025 Season 1