cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Can I use SharePoint Online as a data source?

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,

1 REPLY 1
Super User
Super User

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


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.300 students | PROMOTIONS) : English | Português

Helpful resources

Announcements
New Super Users

Meet the Power Virtual Agents Community Super Users!

Congratulations to our Season 1 2021 Super User Crew!

PVA Commnity Blog

NEW Power Virtual Agents Community Blog

View articles posted by fellow community members on the Power Virtual Agents Community Blog!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Users online (67,102)