Announcements
Hi Community,
I've one doubt about how to create a flow that will extract data from the excel (for e.g., data in excel will be like there are 4 no. of rows and multiple columns) and use it in power virtual agent, so when the user search for the keywords that has the name in the excel the flow should give the output based on the input by the user.
Kindly help with this.
Hi @Anonymous ,
As a test, I created and Adaptive Card and request the user Name, Email and Phone Number.
So, after the user Submit the details it will trigger a flow that will bring the information from a Sharepoint excel spreadsheet.
See screenshot of the flow below:
Topic on PVA:
I hope it helps.
Cheers,
Fernando
Thanks @fernandosilva,
I'm using PVA in teams so there is no availability of adaptive cards, and my question is to extract the data from excel table like one rows is for question and second row is for the answer, so when the user asks for certain question if it has the relevant question, it should answer the question.
You could just create topics and the triggers in PVA then.
You won't need a spreadsheet for that and will give you less headache.
Hi @fernandosilva,
That sound good but there are more number of rows and columns, I want to fetch the data from the excel,
suppose there are 5 columns and 20 rows, In first row it contains questions and remaining contains answer of that question, how can we solve it. So if the use asks the questions it should triggered to the specific question and give the answer.
Thanks in advance
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 612
chiaraalina 161 Super User 2026 Season 1
deepakmehta13a 116
