Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Email Notification When Form Not Complete

(0) ShareShare
ReportReport
Posted on by 41

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.

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Email Notification When Form Not Complete

    @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

    image.png

     

  • Garethterb1 Profile Picture
    Garethterb1 106 on at
    Re: Email Notification When Form Not Complete

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard