Skip to main content

Notifications

Announcements

No record found.

Power Platform Community / Forums / General / Chat Bot with VLookup ...
General
Answered

Chat Bot with VLookup Function in Excel

Posted on by 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

Categories:
  • AllysonMuller Profile Picture
    AllysonMuller 3 on at
    Re: Chat Bot with VLookup Function in Excel

    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.

     

    AllysonMuller_0-1696466079509.png

     

     

    Thank you again,

    Allyson

  • Verified answer
    DiegoPeres Profile Picture
    DiegoPeres 327 on at
    Re: Chat Bot with VLookup Function in Excel

    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

    DiegoPeres_0-1663025320759.png

    Flow In Power Automate

    DiegoPeres_1-1663025421734.png

    Topic in PVA

    DiegoPeres_2-1663025558579.png

    Result:

    DiegoPeres_3-1663025701801.png


    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



     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,648