Skip to main content



No record found.

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

Chat Bot with VLookup Function in Excel

Posted on by 3



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. 



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





    Thank you again,


  • 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


    Flow In Power Automate


    Topic in PVA




    Did I answer your question?😉
    Please consider accepting it as the solution to help other members find you faster.

    Like my answer?

    Like it! 👍

    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…


renatoromao Profile Picture

renatoromao 6,459

Pstork1 Profile Picture

Pstork1 1,954

Expiscornovus Profile Picture

Expiscornovus 1,648