Trying to update a list of things based on the value of a different thing. Specific:
Table 1: Calendar
Table 2: Users
For each user that has an entry in the calendar, check if todays date is within the data range set out of office field to yes.
So User “Tom” has an entry in the calendar that is saying out of office from 1/10/22 to 1/15/22 and today is 1/11/22 which means Tom is out of the office… set his out of office field to “yes”. When the workflow runs on 1/16/22 Tom will no longer be out of the office and his out of office field will be set to “no”.
Would appreciate suggestions about how to go about this best.
Thanks in advance!