web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow schedule - happen...

Power Automate

Unanswered

Flow schedule - happens on the third Friday of the month

(0) Share

Report

Report

Posted on by annoying

58

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?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (3)

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

Was this reply helpful? Yes No
annoying 58 on at

Like (0)

Report

@tom_riha Thank You! It works.

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

Was this reply helpful? Yes No
HarikaVL 66 on at

Like (0)

Report

Hello @tom_riha,
I have the same requirement as above and i followed the instructions you have given, but i am getting this error. Could you please tell me where i am doing wrong.
Here is my flow:

Was this reply helpful? Yes No

Join the conversation