Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

To Schedule Flow to run at a specific interval

(0) ShareShare
ReportReport
Posted on by 23

Hello, I'm new to power automate. May i know is there a way, we could schedule the flow to run on a specific intervals such as i only want it to run on every month week 3 Tuesday at 10am, not every Tuesday. If yes, would you mind showing a printscreen of the flow how could we create it?

  • srduval Profile Picture
    srduval 1,663 on at
    Re: To Schedule Flow to run at a specific interval

    Capture.JPGYou can't schedule a recurrence in flow like that currently. You can go to ideas.powerautomate.com and submit an idea and if it gets enough votes it will be considered. 

     

    For what you want to do, it will have to be triggered every Tuesday, but you setup the flow to check if it's the third Tuesday or not. If it is not a condition action would contain a terminate action to stop the flow from doing anything further. 

     

    What you need to do to make this work is create a compose action and create an expression to with this formula:

    dayOfWeek(utcNow()) 

     

    Then follow the link I posted previously to calculate the week of the month. Once you have those two pieces of information, you create a condition action. The condition you are testing for is the output of the dayofweek, and the week number. So dayofweek eq 2 and weekofmonth eq 3 (day of week could be a 1,2,3 depending on how your system is setup if Monday starts the week or Sunday does, most the time it should be Sunday, but I can't remember if Sunday is 0 or 1)

  • chloe22 Profile Picture
    chloe22 23 on at
    Re: To Schedule Flow to run at a specific interval

    Hi @srduval , thank you so much for your information. However, I only need the workflow to be run on Week 3 of each month on Tuesday at 10am only, not every Tuesday. Is there anyway we could set this up using power automate? If yes, would you mind showing a printscreen of the flow how to create it? Many thanks in advance.

  • srduval Profile Picture
    srduval 1,663 on at
    Re: To Schedule Flow to run at a specific interval

    You will just have to have it run every Tuesday at 10am and have a condition test the current date and terminate if it doesn't match. 

    dayOfWeek(utcNow()) will get you the integer of the current day, which Tuesday will most likely be 2 or 3.

     

    This should let you check for week of month.
    Solved: Calculate the week number of current date within a... - Power Platform Community (microsoft.com)

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard