How to perform a VLookup in Power Automate

[tliwanag]

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. 

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!

[Nived_Nambiar]

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! 🙌

[tliwanag]

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]

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]

@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]

Hi @tliwanag 

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

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]

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. 

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. 

[Nived_Nambiar]

Hi @tliwanag 

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

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]

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]

Hi @tliwanag 

[tliwanag]

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