Answered

How can I find the last Friday of the month for a recurrence flow?

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I need a flow to run on the last Friday of each month. I have tried multiple techniques for determining this but have not found one that is sufficiently simple.

Categories:

Building flows

All responses (5)

Answers (1)

Sort by

Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@Anonymous

Take a look at my example below.

The second compose action is only there so that I had a convenient way to show you the expressions that I used in the condition.

You could implement this with a recurrence trigger that fires daily. For test purposes, you can hard code a date in the first compose action rather than using utcNow().

Please let me know if you have any issues.
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ，

Please take a try with @ScottShearer 's solution, the solution is great.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
javierruidiaz 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello all,

I need help with a similar flow but that it's triggered the second Thursday of each month... I've been trying to do it changing the variables used in this post... but no luck so far... 😞

Could you please help me?
Many thanks
javierruidiaz 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry community... just found it! (obviously the solution was in front of me)...

formatDateTime(addDays(outputs('My_Day'),14),'MM')
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm new to this type of data operation. I need the flow to execute on the 2nd Friday of the month. What would my variables be?