Create a Schedule Flow

[Pinoq]

I am new in Microsoft flow and I want to ask some basic questions. I would like to create a workflow for a notification e-mail if some job assign to specific staff is overdue. As the overdue time is after 20 minutes of creation. I would like to set a flow that will trigger after 20 minutes a new item is added on a share point list. 

This is my setting:

When an item is created(trigger)>schedule delay(for 20 minutes)

What I want to do on the flow is, if the status of the list does not change to Resolved, I will send an email to the assigned staff(after 20 minutes of creation, and check every 10 minutes if still not yet resolved send a second email.

This is my setting:

When an item is created(trigger)>schedule delay(for 20 minutes)>get item>add condition(if status is equal to Resolved), (if no)send an email.

But the flow seems not work, did I miss anything? Also, how can I set a loop to send an email every 10 minutes if status keeps pending and not change to Resolved?

[efialttes · Accepted solution]

Hi!

Some thoughts...

1.- Can you share a screenshot of your current flow design?

2.- You mention your flow does not work... can you be more specific? Does your flow do not even execute? Does it fail? Does it work in an unexpected way? Does the condition never/always leads to the false branch? The more details you can provide, the better

3.- My suggestion for a loop to send an email every 10 minutes if status keeps pending and not change to Resolved: a Do Until

https://techwizard.cloud/2018/05/20/microsoft-flow-mystery-of-do-until-loop/

Hope this helps... if it did, follow the instructions and save the galaxy!

[efialttes]

OMG... you forgot to follow the instructions to save the galaxy! 🙄

Anyway, glad to see my post pointed you to a promising direction!

Finally, thanx for marking this topic as solved! THis way other community members facing your same issue can have the chance to find a solution faster

[Pinoq]

I have solved the issue and I am trying the do until run and testing now. But I encounter another issue. In the same case. I want to set more one conditions. Because the notification email should only send to staff that in the A department. So i want to add more one condition. The trigger should be an item is created + deaprtment=A.

https://siddharthvaghasia.com/2019/08/06/trigger-ms-flow-on-condition-based-on-columns-value-with-sh...

I use the method on the above link, 

on the setting of an item is created, add the expression: @equals(triggerBody()?['Department']?['value'],'A'), that A is a "choice" on my list. But an error message shows "The property "properties" Cannot read property 'properties' of undefined.Do you know what properly causes the error? Also, thanks for your reply for the "Do until method, it helps a lot!!

[Pinoq]

I have another problem with the same workflow. After the first reminder of 20 minutes.

First reminder setting:

When an item is created(trigger)>schedule delay(for 20 minutes)>get item>add condition(if status is equal to Resolved), (if no)send an email. And tested ok. 

Then I need a notification email every 10 minutes if the case not yet resolve after the first 20 minutes.

My setting is:

add condition(if status is equal to Resolved), (if no)send an email. > get item>Do until>Delay 10 minutes>get item>send an email.

My do until setting is Status is equal to Resolved. And all my get item setting is from the ID. 

I can receive all the email but the flow failed to stop even the Status change to Resolved. May I know what is going wrong?