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

[fs]

This will be a sceduled flow that runs every 15 minutes

How would i accomplish this?

[MaanR · Accepted solution]

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.

 

[v-qiaqi-msft]

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')

   )

)

[okeks]

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 🙂

[fs]

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

[mike7352]

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?

[Kfleek]

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,