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

Notifications

Announcements

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

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
    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
    on at

    but my code is required at the later stage 

     

    pokhani_0-1659011550468.png

     

  • v-bofeng-msft Profile Picture
    on at

    Hi @Anonymous ,

     

    Please try

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

     

    Best Regards,
    Bof

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

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard