Unanswered

Chat Bot with VLookup Function in Excel

(0) Share

Report

Posted on by philipp17

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DiegoPeres 327 on at

Like (3)

Report

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?😉
Please consider accepting it as the solution to help other members find you faster.

Like my answer?

Like it! 👍

Thanks!
Diego Peres,
Connect with me: Linkedin

Was this reply helpful? Yes No
AllysonMuller 3 on at

Like (0)

Report

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

Was this reply helpful? Yes No