Home > Net >  Converting the time zone in an automated cloud flow Power Automate
Converting the time zone in an automated cloud flow Power Automate

Time:06-08

Hello and thank you for taking the time to read my post! I just finalized an automated flow that will help me keep track of emails' flow (received) in a shared inbox. In essence, I am tracking the number of emails I get a day. I set up the flow and was able to get it to work and I am getting a row added with the info I need (i.e., From, To, Subject line, Received Time, etc..). However, I noticed that the time stamp is not in the correct time zone. I read several posts and it seems like Power Automate has a UTC time zone set by default. I tried using an expression to convert to the correct time zone (EST), the flow did not return any errors but the time remained in the original format: "UTC". This is the expression that I added" convertTimeZone(utcNow(),'UTC','Eastern Standard Time','MM/dd/yyy HH:mm') I would really appreciate any suggestions or guidance on how to best get this issue resolved.

Flow actions

New attempt with date conversion Date Output

CodePudding user response:

If you're converting from UTC, you can do it as easily as this ...

formatDateTime(convertFromUtc(utcNow(), 'Eastern Standard Time'), 'dd MMM yyyy HH:mm')

At the time of running this, the UTC date/time was the 5th of June, 2022 at 23:50, this was my result ...

DateTime

  • Related