cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angelaei
Frequent Visitor

Use PVA to search Excel file in Onedrive (lookup data)

Is there a way in Power Automate to make my Teams chatbot get an input from PVA and use it to search an excel file (similar to a vlookup function)?

 

the goal is the user will provide the reference Order Number through the Chatbot. This Order Number will be used by the chatbot to search an Excel file (stored in Onedrive) and get its corresponding status.

Example: The Chatbot will ask for the Order No. and if the user provides "A123", Chatbot will return the status "Processed"

Angelaei_0-1659418495959.png

 

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

Yes, that is relatively easy to do.

1) Create an appropriate Topic to start the chatbot

2) Ask for the Order Number

3) Pass the Order Number to a flow that will search the Excel file and return the status

4) Display the returned status in the bot.



-------------------------------------------------------------------------
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

Angelaei
Frequent Visitor

Thanks for the reply. What flow can I use? I tried exploring Get a row but I can't make it work. I have a Topic and the message asking for the Order Number already. 

1) After the flow is triggered do a List Rows in Table

2) Use a Filter Array to filter the rows based on the order number

3) There should be an array of one or zero rows returned. One means it found the row and zero means it didn't

4) If it found it return the status of the row that was found



-------------------------------------------------------------------------
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
 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.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Solution Authors
Users online (4,685)