Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 19

This will be a sceduled flow that runs every 15 minutes

 

How would i accomplish this?

  • Kfleek Profile Picture
    4 on at
    Re: Just want flow to run between hours of 8am and 5pm local time

    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'

     

    Kfleek_0-1689281812906.png

     

     

    Best regards,

     

  • mike7352 Profile Picture
    2 on at
    Re: Just want flow to run between hours of 8am and 5pm local time

    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?

  • fs Profile Picture
    19 on at
    Re: Just want flow to run between hours of 8am and 5pm local time

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

  • okeks Profile Picture
    802 Super User 2024 Season 1 on at
    Re: Just want flow to run between hours of 8am and 5pm local time

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

     

    okeks_0-1649746520779.png

     

    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 🙂

  • v-qiaqi@microsoft.com Profile Picture
    on at
    Re: Just want flow to run between hours of 8am and 5pm local time

    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')
    
     )
    
    )
  • Verified answer
    MaanR Profile Picture
    46 on at
    Re: Just want flow to run between hours of 8am and 5pm local time

    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.

     

    MaanR_2-1649276614575.png 

    MaanR_3-1649276713954.png

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >