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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get month last ...
Power Automate
Unanswered

How to get month last end date in Power Automate desktop flow ?

(0) ShareShare
ReportReport
Posted on by 203

Hi Everyone,

 

How to get month last end date in Power Automate desktop flow please help with a snap shot for the help.

 

Thanks

Best Regards 

 

  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi @Ahmedmuz 

     

    Try as below

     

    Srini84_0-1697532010889.png

     

     

    Copy the steps and paste PAD

     

    DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime
    DateTime.Add DateTime: CurrentDateTime TimeToAdd: $'''-%CurrentDateTime.Day%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> EndOfLastMonth
    SET DateRange TO EndOfLastMonth
    

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Thanks,

    Srini

  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Last Day of the Current Month:

    Kaif_Siddique_0-1697534609011.png

     

    Copy&Paste to PAD:

    DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime
    DateTime.Add DateTime: CurrentDateTime TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> LastDayOfMonth
    DateTime.Add DateTime: LastDayOfMonth TimeToAdd: $'''-%CurrentDateTime.Day%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> LastDayOfMonth

     

    Regards

    Kaif

  • Ahmedmuz Profile Picture
    203 on at

    Hi Kaif,

    Thanks a lot:) Can you please help me on the other one which i posted on below link,,

    Need a help in Copy and Paste issue in Power autom... - Power Platform Community (microsoft.com)

  • Ahmedmuz Profile Picture
    203 on at

    Hi Shrini,

    Thanks a lot:) Can you please help me on the other one which i posted on below link,,

    Need a help in Copy and Paste issue in Power autom... - Power Platform Community (microsoft.com)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 355

#2
11manish Profile Picture

11manish 336 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard