I have a list of timesheets and that I need to compare those against an employee list in order to see who has not submitted timesheets for that week and then send email based on the results. I thought of using collection operations and query list. I have my 2 query's set up and pulling the employee numbers then a "For Each" with a "collection variable" that uses the "Exist" method however not sure what comes after the collection variable or if there is a better way to solve the requirement? Any help would be greatly appreciated
Solved! Go to Solution.
You are on the right track. Below is a screenshot of how you should approach your scenario:
Hope that helps