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!
