web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : RoVFH/KXL8s2dCKGjHwdnZ
Copilot Studio - Calling Actions from Copilot S...
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 2 Aug 2022 05:38:27 by 22

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

 

Categories:
  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 26 Oct 2023 at 22:43:20
    Re: Use PVA to search Excel file in Onedrive (lookup data)

    Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later. 

     

    But the short answer is No, there is no other way to do a lookup for something in a database from the Bot without Power Automate.

  • Zap174 Profile Picture
    165 on 26 Oct 2023 at 20:03:08
    Re: Use PVA to search Excel file in Onedrive (lookup data)

    @Pstork1 

    Is there a way to do this without Power Automate? We don't want to create a flow for each time we want to do some sort of validation or lookup. Is there another way to do this? We would be validating against a db in SQL server if that helps.

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 03 Aug 2022 at 03:16:04
    Re: Use PVA to search Excel file in Onedrive (lookup data)

    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

  • Angelaei Profile Picture
    22 on 03 Aug 2022 at 02:46:29
    Re: Use PVA to search Excel file in Onedrive (lookup data)

    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. 

  • Pstork1 Profile Picture
    67,165 Most Valuable Professional on 02 Aug 2022 at 11:55:11
    Re: Use PVA to search Excel file in Onedrive (lookup data)

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75 Super User 2025 Season 2

Featured topics