Announcements
Hello everyone,
I have a dataverse table with Questions field (Rich Text), and a hyperlink field. I want user to enter question into chatbot, and trigger search on the dataverse table in order to provide user with links to similiar questions. And now the challenge, let's say user enters "How do i start with Power Automate". I want to search list of questions with this phrase and find things with highest similarity, is it possible to achieve in PVA or it's a matter of making some sort of complex PA flow?
I'm just getting started with PVA and I was wondering if someone already encountered something like this
PVA has no specific access to tables in Dataverse. That would always be done by calling a Power Automate flow from the bot and returning the results. The trickiest part will be figuring out how to do the fuzzy search of the dataverse table. I'm not sure how you will accomplish that in Power Automate.
@KSusser we published an article that's very similar to your use case. We leverage "Dataverse Search" in the example as it supports fuzzy matching: Return a list of results - Power Virtual Agents | Microsoft Learn
Let me know if that helps
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 671
Vish WR 266
Haque 265