Working in a factory type setting with heavy machinery (front-end loaders). Every day before 8am, the loader operators are required to perform a safety checklist form on their machines which populates a list. I need a flow that sends an email at 10am every day to the manager of the operators that did NOT submit their checklist. There are eight operators.
I agree with the solution offered by @convertusRyan
The SharePoint Get items (check list list) filter query should look like this:
Created ge 'utcNow('yyyy-MM-dd')'
The expression should be entered in the expression window.
The single quotes are important
You will need to run a flow that lists all the items created on that day and then compare the creating by column to a list of list of operators with a condition that check to see if the operator is in the return result.
It wil be something like this.
Schedule Trigger
get items operators
get items check list (use filter to return today only)
for each operator if that are in the string(outputs) of get items check list the do nothing other wise send an email.