News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows getting date format MM...

Power Automate - Using Flows

Answered

getting date format MMM yyyy

(0) Share

Report

Report

Posted on by damiosiks

165

Hi, please, i need help in getting an expression that would output Last month and current year. example: February 2022.

Thank you

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

ScottShearer 25,208 Most Valuable Professional on at

Like (1)

Report

Re: getting date format MMM yyyy

@damiosiks

The expression that I provided will give you the month and year for the current date. If it were February, it would result in February 2022.

Do you want the result always to be 1 month back? If so, then use this expression:

addDays(startOfMonth(utcNow()),-1,'MMMM yyyy')
damiosiks 165 on at

Like (0)

Report

Re: getting date format MMM yyyy

How about February 2022? this solution provides for March which is current month
Verified answer

ScottShearer 25,208 Most Valuable Professional on at

Like (2)

Report

Re: getting date format MMM yyyy

@damiosiks

Here ya go.....

formatDateTime(utcNow(),'MMMM yyyy')

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,658 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans