cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gragert
Regular Visitor

Email Notification when Form is not completed by 5:30PM.

I have a Flow connected to a Form in a factory environment.  When a machine is cleaned each day, the operator completed a Microsoft Form that has a few questions and fields for notes.  When the Form is submitted it populates a Microsoft List and sends a notification to a group of key employees so they know the task was completed and includes the notes for that day.   I need a way to send a different notification if the Form is not completed by 5:30pm each day so that the supervisors can assign someone else to that task for the day.   I have created 50-60 flows with different levels of complexity. This one is beating me up.  There seems to be a few ways to address the logic, but I can't seem to figure it out.   Help please!

 

I can use the Form or even the List, but I cannot seem to think of the right steps in the Flow to get this to work. 

1 ACCEPTED SOLUTION

Accepted Solutions
vhughes
Frequent Visitor

Ah, almost there. Here’s what I mean by “expression”:

B30AE6CA-845D-4556-BFFA-B33DA0FB2A6E.png

 

 Then, for the condition:

4D8EB0F1-8D2E-4264-998F-8D979B37DE11.png

which you make by: 

B11E94C5-2E55-44EC-81C1-73602BD73B45.png

 

I would have included screenshots last night but I was on mobile sorry


View solution in original post

6 REPLIES 6
vhughes
Frequent Visitor

If I understand correctly, the challenge is with your trigger. You cannot use MS Forms as the trigger because the only option there is ‘when a new submission’ happens. So, I think the scheduled trigger is your best option. Add it from the “recurrence” connector. Set it to daily, specify the time zone, skip start date, enter the hour ‘17’ and minute ‘0’.

 

Now, use a “get items” action from Sharepoint to see if anything was submitted in the last 12(?) hours. Set to the site and list, expand advanced, in Filter query:

Created gt ‘x’

X will be an expression of: addHours(utcNow(),(-12),’yyyy-MM-dd’)

 

Next action: Condition

left side, expression: length(body(‘Get_items’)?[‘value’])

Equals 0

 

yes path of condition means, “no forms submitted” so you can add the notification actions that you used in the other flow.

Thanks.   Looks like you get what I am trying to accomplish.  I will give this a try and follow up with results.   

 

Thanks again. 

No success yet.  I think it is close. 

I am getting this error: 

The string was not recognized as a valid DateTime. There is an unknown word starting at index 0. Creating query failed.

 

Here is the full flow (*I changed the time of recurrence for testing): 

Gragert_1-1610549647549.png

 

 

vhughes
Frequent Visitor

Ah, almost there. Here’s what I mean by “expression”:

B30AE6CA-845D-4556-BFFA-B33DA0FB2A6E.png

 

 Then, for the condition:

4D8EB0F1-8D2E-4264-998F-8D979B37DE11.png

which you make by: 

B11E94C5-2E55-44EC-81C1-73602BD73B45.png

 

I would have included screenshots last night but I was on mobile sorry


Fantastic!!!   That did the trick.  I am still learning and have a long way to go.  I really appreciate the help.   

vhughes
Frequent Visitor

Yay! Glad to hear it 🙂 you’re doing great! I always say the most important part is having the ability to imagine what you want, cause you can always learn the “how” later.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,877)