Convert UTC to EST time zone

(0) Share

Report

Posted on by Salem

187

Hi,

It's pretty much the title, I want to convert UTC time into EST time. I don't want to convert to local time, it needed to be EST time and of course this can be daylight saving or not depending on the time of the year so I don't want to subtract a fixed number of hours.

A little more background on that; we operate in different time zones and for consistency wie document all time stamps in Eastern. As I don't know what time zone the user device is in because it can be different, but I know the time offset so I can convert that into UTC. Now I want to convert that into Eastern before writing this back to the database and that's why I want to convert UTC into Eastern including daylight saving depending on the time of the year.

I know that there is a power automate formula to do that and I use it in some flows, but I want to do that within power apps, I don't want to use power automate for this. Thank you.

Edit: spelling

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Salem ,

I'm afraid Canvas app doesn't have a built-in function to convert time zones, so you might consider creating a Custom Connector to call an external API to achieve this. For example, this API can get EST's time zone offset:

http://worldtimeapi.org/api/timezone/EST

If you think this solution is cumbersome, then calling Flow is a better choice.

Best Regards,

Bof

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

Like (1)

Report
Copy link

Link copied!

Hi @Salem ,

Or you can also take the time -5 first, and then use some formulas to calculate whether this time falls in daylight saving time or winter time, and then decide whether to ± 1h.

Best Regards,

Bof

Was this reply helpful? Yes No