Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - General
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:
  • veera_web Profile Picture
    8 on at
    Re: Generative Answers Sharepoint

    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.

     

    veera_web_0-1692778592743.png

    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?

  • Wisam Profile Picture
    13 on at
    Re: Generative Answers Sharepoint

    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.

  • Wisam Profile Picture
    13 on at
    Re: Generative Answers Sharepoint

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

     

     

  • HenryJammes Profile Picture
    on at
    Re: Generative Answers Sharepoint

    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.

  • automationguy56 Profile Picture
    10 on at
    Re: Generative Answers Sharepoint

    @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
    Re: Generative Answers Sharepoint

    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
    Re: Generative Answers Sharepoint

    @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
    Re: Generative Answers Sharepoint

    @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
    Re: Generative Answers Sharepoint

    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

  • MattJimison Profile Picture
    577 Most Valuable Professional on at
    Re: Generative Answers Sharepoint

    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

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Copilot Studio - General

#1
stampcoin Profile Picture

stampcoin 6

#2
Artur Stepniak Profile Picture

Artur Stepniak 5 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

Overall leaderboard