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.
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 ...