cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
annoying
Helper I
Helper I

Flow schedule - happens on the third Friday of the month

Hello, I am trying to create a recurring flow to happen on the third Friday of every month.

 

For example, in April 2021 the third Friday of the month is 16 April; in May 2021, the third Friday of the month is 21 May.


I know I can make the flow happen on every Friday, but how can I know if the week is the third week? 

Is there a way to do this?

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @annoying ,

you can check within the trigger condition if the 'dd' part of the date is between 15 and 21 (the possible dates for a Friday in the third week), and run the flow only if it's true.

@greaterOrEquals(int(utcNow('dd')), 15)
@lessOrEquals(int(utcNow('dd')), 21)

 image.png



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

2 REPLIES 2
tom_riha
Super User
Super User

Hello @annoying ,

you can check within the trigger condition if the 'dd' part of the date is between 15 and 21 (the possible dates for a Friday in the third week), and run the flow only if it's true.

@greaterOrEquals(int(utcNow('dd')), 15)
@lessOrEquals(int(utcNow('dd')), 21)

 image.png



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

@tom_riha Thank You! It works. 

Would you know how I can get the date of the last Thursday of the month?

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,668)