web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Convert =TEXT( NOW(), ...

Power Automate

Answered

Convert =TEXT( NOW(), "mm/dd/yyyy hh:mm AM/PM" ) Function From Excel

(0) Share

Report

Report

Posted on by Community Power Pla...

Im attempting to change the date retrieved from excel into this format: yyyy-MM-dd HH-mm. My excel file has the date in this format:

Any idea?

Categories:

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

You could try the ParseDateTime function.

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

Like (0)

Report

_

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

Like (0)

Report

Hello,

Would you mind giving me an example of what that would look like in my case?

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report
formatDateTime('01/31/2022 03:35 PM', 'yyyy-MM-dd HH-mm')
output: 2022-01-31 15-35

Are you sure you don't want a correct ISO 8601 formatted string?

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

Like (0)

Report

Hey thanks!

Im attempting a new way to do this which is:
convertFromUtc(utcNow(),outputs('Get_a_row')?['body/timeZone'],'yyyy-MM-dd HH-mm')

However now I cant get power automate to read the mountain standard time in excel!

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report
Something like this?

convertTimeZone('01/31/2022 03:35PM','Mountain Standard Time','Central Standard Time')

Was this reply helpful? Yes No

Join the conversation