cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lalithanov20
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.
2 REPLIES 2
lalithanov20
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

 

lalithanov20_1-1659606566842.png

 

 

lalithanov20_2-1659606632434.png

 

 

 

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.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a free PVA chatbot creation workshop

Register for a free PVA chatbot creation workshop

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Top Solution Authors
Users online (4,332)