Skip to main content

Notifications

Topic Creation & Management
Unanswered

Can I use SharePoint Online as a data source?

Posted on by 135

Hi, I am very new to PVA and have only so far created a very simple QnA type bot with static responses.

 

I have a rich data source in a SharePoint Online list which I was thinking might be nice to hook into PVA.  The use case would be:

 

Customer wants to know what tools are available to help them do X,Y,Z so they ask the bot

Bot uses the SP Online data to return a response

 

Would this be possible to reuse this data source to provide the response?

 

Thanks,

  • renatoromao Profile Picture
    renatoromao 6,762 on at
    Re: Can I use SharePoint Online as a data source?

    Hi @suclarkeuk ,

     

    Yes, sure.

    You can follow the logic below and if you have any questions, please, let me know.

     

    Steps:

    - Create a topic in your bot that you are using normally

    - Make a question like "What do you want" and store inside a variable

    - Create an action calling to Power Automate passing this variable

    - Create a workflow inside Power Automate  that receives this parameter

    - Create an action inside your workflow, that get items from SharePoint and you can use OData filter to search data inside your SharePoint list/library using Columns

    - Format your results using Markdown as a table: https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support

    - Return to your PVA bot as a variable

    - Show as a message inside your bot

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 137,998

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,059

Leaderboard

Featured topics