Showing results for 
Search instead for 
Did you mean: 
New Member

PVA Bot to read the data from excel as response to the question

Hi Experts, I am trying to create a PVA bot to answer queries with the response stored in the excel. Here is what i have done till now Step 1 : Post a message to Ask a question: message is read into a variable "question" Step 2 : Call a action, create a flow, which is following sub steps 1. Input 2. List row represent table Not sure how to print this data. How do we conditionally filter the excel data to only display the response to the questions posted.
New Member

output of excel

issue               resolution

What is AI       Artificial intelligence

what is ML     Machine Learning


here are snapshot of the flow that I have created









Instead of using an OData query to filter the rows, I would just get all the rows. Then you can use a Filter Array action to filter out rows that do not contain a specific word or words. I would suggest finding a way to send just the keyword being requested to the flow and filter on that.  

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,014)