web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How can I find the las...
Power Automate
Unanswered

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

(1) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,268 Most Valuable Professional on at
    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.

    Last Friday.jpg

  • v-alzhan-msft Profile Picture
    on at
    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.

  • javierruidiaz Profile Picture
    54 on at
    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

  • javierruidiaz Profile Picture
    54 on at
    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')

  • Community Power Platform Member Profile Picture
    on at
    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? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard