Just want flow to run between hours of 8am and 5pm local time

(0) Share

Report

Posted on by fs

This will be a sceduled flow that runs every 15 minutes

How would i accomplish this?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

MaanR 46 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can create a Scheduled Cloud Flow where you can set your 15 minute time interval. And in the settings you can use trigger condition that would only allow the flow to run between your required time. This is the challenging part. You can find the Trigger Condition in this post by Expiscornovus.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Hi @fs,

Have you solved your problem?

Do you want to trigger the flow only from 8am and 5pm local time?

Write this expression within the condition of the trigger:

@and( GreaterOrequals( convertTimeZone(utcnow(), 'UTC', 'Central Standard Time', 'HH:mm'),//Here is your local time formatdatetime('8:00','HH:mm') ), lessOrEquals( convertTimeZone(utcnow(), 'UTC', 'Central Standard Time', 'HH:mm'), formatdatetime('17:00','HH:mm') ) )

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If you want to do that for more then just one flow (e.g. a whole environment) you can also use something like this.

Don't forget to create a second flow to turn on your flows again and include a condition so you don't turn off the "Turn it on again" flow 🙂

Was this reply helpful? Yes No
fs 19 on at

Like (0)

Report
Copy link

Link copied!

Ideally it would support daylight savings, but UTC is almost good enough thanks.

Was this reply helpful? Yes No
mike7352 2 on at

Like (0)

Report
Copy link

Link copied!

How can this be applied when the trigger of a flow is an email? Condition in which further actions will only be taken if the email is received (DateTimeReceive) within certain hours?

Was this reply helpful? Yes No
Kfleek 4 on at

Like (1)

Report
Copy link

Link copied!

You will need to get the current time, convert the current time to your time zone, then make a conditional control with a formatted time expression (you WILL need to use a 24 hour time format).

The Expression for the conditional control is below:

formatdatetime(body('Convert_time_zone'),'HH:mm') > "is less than" > '07:00'

&
formatdatetime(body('Convert_time_zone'),'HH:mm') > "is greater than" > '18:00'

Best regards,

Was this reply helpful? Yes No