Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5B1/JlTnvxXAVar+hpVjG4
Power Automate - General Discussion
Unanswered

How to perform a VLookup in Power Automate

Like (0) ShareShare
ReportReport
Posted on 12 Apr 2024 21:20:38 by 34

Hello, 

I'm seeking some guidance to create a VLOOKUP function within Power Automate.  I have a monthly worker report that generates workers who have missing timesheets. My goal is to automate the email reminders to have suppliers update timesheets accordingly. I'll need to create a vlookup against the worker report to pull in the supplier emails from my distro list. 

 

tliwanag_0-1712956730416.png

tliwanag_1-1712956748989.png

 

Currently, I have configured the flow to filter rows based on the missing timesheet status and to count these instances. Additionally, I've also extracted unique supplier names. I'm not sure what my next step would be to be able to pull the correct supplier email addresses to the corresponding supplier.  Please let me know if you need further details - thank you!

 

tliwanag_2-1712956760518.png

 

  • tliwanag Profile Picture
    34 on 17 Apr 2024 at 18:44:13
    Re: How to perform a VLookup in Power Automate

    Hi @Nived_Nambiar Would you mind posting your answer again? For some reason, no text or images are showing up on my end. Thanks!

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 17 Apr 2024 at 18:15:23
    Re: How to perform a VLookup in Power Automate

    Hi @tliwanag 

  • tliwanag Profile Picture
    34 on 17 Apr 2024 at 14:35:33
    Re: How to perform a VLookup in Power Automate

    Yes, I'm looping through the supplier unique details which is working great, but how can I pull in the supplier email addresses from table 2? I essentially need to do a vlookup to get the supplier email addresses for the corresponding supplier and then send out the email.

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 17 Apr 2024 at 02:27:48
    Re: How to perform a VLookup in Power Automate

    Hi @tliwanag 

     

    I think you have to loop through the supplier unique details and filter the data accordingly ? am i correct ?

    Nived_Nambiar_0-1713320880693.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • tliwanag Profile Picture
    34 on 16 Apr 2024 at 19:21:57
    Re: How to perform a VLookup in Power Automate

    Hi @Nived_Nambiar Sorry for the confusion. Yes, I need to combine that table with this one below so that I can pull in Supplier emails. 

    tliwanag_0-1713294178974.png

     

    Here is what I've done so far. But I'm not sure if the apply to each section is correct and what outputs I need to enter. 

     

    tliwanag_1-1713295276645.png

     

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 16 Apr 2024 at 18:16:59
    Re: How to perform a VLookup in Power Automate

    Hi @tliwanag 

     

    sorry i was bit confused, may i know this is other table u need to combine

    Nived_Nambiar_0-1713291413188.png

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • tliwanag Profile Picture
    34 on 16 Apr 2024 at 13:15:57
    Re: How to perform a VLookup in Power Automate

    @Nived_Nambiar I will have 2 tables, 1 with the data and the other with the supplier email addresses. Should I be adding the 2nd table in the flow prior to the loop?

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 16 Apr 2024 at 02:40:24
    Re: How to perform a VLookup in Power Automate

    Hi @tliwanag 

     

    how many tables are involved in this flow ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • tliwanag Profile Picture
    34 on 15 Apr 2024 at 16:33:22
    Re: How to perform a VLookup in Power Automate

    Hi @Nived_Nambiar Thank you for the reply. Inside the loop, I have the filter array set up to filter the missing timesheet data. However, my confusion is how to pull in the supplier emails table into that loop so it can vlookup the the supplier email with the corresponding supplier name. Would I have to use the 'Get a row' action to pull in those emails?

     

     

     

     

     

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 13 Apr 2024 at 12:39:48
    Re: How to perform a VLookup in Power Automate

    Hi @tliwanag 

     

    to get details of supplier details from the timsheet table,

     

    loop through results of union operation which you have did on supplier column.

    Now inside loop, use filter array to filter the timesheet data with current supplier being iterated.

    Now use send email action to send email to the supplier with the data.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

#2
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 4 Super User 2025 Season 1

Overall leaderboard