Unanswered

Email Notification When Form Not Complete

(0) Share

Report

Posted on by convertusRyan

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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Garethterb1 131 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Garethterb1

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

Was this reply helpful? Yes No