web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Generative Answers Sha...
Copilot Studio
Unanswered

Generative Answers Sharepoint

(0) ShareShare
ReportReport
Posted on by 10

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_0-1687275175267.png

 

 

Categories:
I have the same question (0)
  • automationguy56 Profile Picture
    10 on at

    Does any one have an idea or implemented above scenario ?

  • MattJimison Profile Picture
    577 Most Valuable Professional on at

    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.

     

    MattJimison_0-1687497373662.png

     


    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 Profile Picture
    10 on at

    Thanks @MattJimison  for your response.

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

    automationguy56_0-1687507227736.png

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

    @automationguy56 wrote:

    Thanks @MattJimison  for your response.

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

    automationguy56_0-1687507227736.png

    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-or-onedrive-for-business

     

    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 Profile Picture
    10 on at

    @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 Profile Picture
    on at

    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 Profile Picture
    10 on at

    @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 Profile Picture
    on at

    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 Profile Picture
    13 on at

    @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.
    Wisam_0-1692035156277.png


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

    Wisam_1-1692036501814.png


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


    Any troubleshooting tips?

     

     

  • Wisam Profile Picture
    13 on at

    Interesting find: I found that if I follow the following steps, the bot can reference info in aspx pages:

    1. Save the aspx page as PDF.
    2. Upload the PDF to a document library in the same site as the aspx page.

    It even adds a reference to the aspx page instead of the PDF document:

    Wisam_0-1692639896053.png


    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 255 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 205 Super User 2025 Season 2

#3
S-Venkadesh Profile Picture

S-Venkadesh 101 Moderator

Last 30 days Overall leaderboard