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 / convert date to MM, YY...
Power Automate
Unanswered

convert date to MM, YYYY format using flow

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

hi 

I have a column in excel in the format : " 2022 01"

now i want to change this format as Jan, 2022 in my flow; 

 can we do anything in this dynamic content please advice 

pokhani_0-1658846411095.png

 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ï¼Œ

    Please try:

     

    formatDateTime('2022 01','MMM,yyyy')

    On your side , you should replace '2022 01' with the dynamic content

     

    vbofengmsft_0-1658988815543.png

    vbofengmsft_1-1658988878893.png

     

    Best Regards,

    Bof

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    but my code is required at the later stage 

     

    pokhani_0-1659011550468.png

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Please try

    formatDateTime(items('ForEach_ProjectID')['Period'],'MMM,yyyy')

     

    Best Regards,
    Bof

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    hi 

    thank you but am getting this error

    pokhani_0-1659098237574.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard