Power Platform Community Forum Thread Details

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,

Categories:

Topic creation & management

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

Community site session details

Can I use SharePoint Online as a data source?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Copilot Studio

Featured topics

Product updates