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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,392)