web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate convert date to MM, YY...

Power Automate

Unanswered

convert date to MM, YYYY format using flow

(0) Share

Report

Report

Posted on by Community Power Pla... 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

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ，

Please try:

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

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

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

but my code is required at the later stage

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try

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

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi
thank you but am getting this error

Was this reply helpful? Yes No

Join the conversation