3
Hello,
I am trying to create a chat bot with PVA which uses a excel spreadsheet and its vlookup function. My goal is that the user tells the chat bot an old account number which is used for the vlookup function to find the new account number which is returned to the user.
Do you have any ideas how I can do this? Any help is appreciated as it is my first time working with PVA.
Thanks,
Philipp
Hi Diego!
Thank you very much for your help!
I used your guide to build this flow, but may you kindly help in what we should do in case of a non existent ID is typed by user. I would like to create a rule, in case user input is not find in the excel, bot answer the data wasn't find.
Thank you again,
Allyson
Hi @philipp17
In this case, you have to use Power Automate to perform this query.
I did it here in my DEV environment, here are the details of how you need to build the solution.
Table in Excel
Flow In Power Automate
Topic in PVA
Result:
Did I answer your question?😉 Like my answer? Like it! 👍
|
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
renatoromao
6,459
#2
Pstork1
1,954
#3
Expiscornovus
1,637
Share
Report
All responses (
Answers (