Announcements
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?
You could try the ParseDateTime function.
_
Hello,
Would you mind giving me an example of what that would look like in my case?
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?
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!
convertTimeZone('01/31/2022 03:35PM','Mountain Standard Time','Central Standard Time')
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 430
11manish 341 Super User 2026 Season 2
M Bilal Khan 282
