Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Pq/QLs2ksC2wfQUprxCs0F
Copilot Studio - General
Unanswered

Query data and customise the content from SharePoint with Generative answers

Like (0) ShareShare
ReportReport
Posted on 12 Jun 2023 10:52:23 by 29

Hi, 

 

So far, I can dig for the keyword with Generative answers to get URLs from my SharePoint.

But I would like to get more information according to this keyword and query and customise the content from my SharePoint site. So I can provide the customized content with file links to end users


For example: keyword is security policy

There is one file and mentioned what is security policy, I would like to query that content (based on files on my SharePoint site) but customise the content to make it friendly, also provide file lists with Generative answers

Does anyone give me some idea? Many thanks

Categories:
  • HenryJammes Profile Picture
    on 19 Jun 2023 at 07:13:45
    Re: Query data and customise the content from SharePoint with Generative answers

    Hello @JC324,

     

    There are multiple ways to look at this.

     

    Generative Answers over SharePoint/OneDrive should already return a list of matching documents/pages for a given user query / keywords: 

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

     

    You can also choose to query SharePoint in a custom way using Power Automate and use Generative Answers to summarize your findings, by adopting the custom data source format:

    https://learn.microsoft.com/en-us/power-virtual-agents/nlu-boost-node#custom-data-source

     

    In these examples, I also showed how to do a custom Graph API call to do document search and how to use a Azure OpenAI model to summarize the results in a desired format:

     

    For a better search experience than Graph API, you could leverage Azure Cognitive Search.

    There's also an exciting upcoming  capability called Azure OpenAI on your data that should help:

     

    Henry 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

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

Overall leaderboard
Loading started