Answered

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

(1) Share

Report

Posted on by Community Power Pla...

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.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

ScottShearer 25,240 Most Valuable Professional on at

Like (2)

Report

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

@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.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
javierruidiaz 54 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
javierruidiaz 54 on at

Like (0)

Report

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

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

formatDateTime(addDays(outputs('My_Day'),14),'MM')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No