Determine PST vs PDT

(0) Share

Report

Posted on by SJ-15052312-0

418

Hello,

I have an app that is used over sea's and in many time zones. I want certain features or behaviors altered depending on what time it is in the pacific time zone. How can I account for PDT vs PST? I see the function TimeZoneOffset() but the offset would vary from -7 to -8 depending on the time of the year.

In java I would use something like:

ZonedDateTime dateTime = ZonedDateTime.now(ZoneId.of("America/Los_Angeles"));

Which would account for this. How can I do this in PowerApps

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

Bad news is that PowerApps has no baked-in function for delivering you a user's Timezone, just the offset. The reasoning is probably that 99% of the time you only care about correcting for the conversion; not about the actual string representation of the timezone itself.

The Good news, however, is that this isn't impossible; just really, really annoying. Power Automate does let you pick specific time zone values and perform calculations on them, for example, getting the difference between Now() in Pacific time and Now() in UST. So, what you're going to need to do here is create a PowerAutomate Flow that gives you some useful data (i.e. the offset for Pacfic time right now) that you can compare to the user's timezoneoffset to decide where they are.

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cchannon ,
You could get smart with Location.Longitude and have a table looking for values between to adjust the TimeZoneOffset by this amount.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

Good point Warren, and if users are pretty well clustered in just a handful of urban centers that would probably be enough, but it would require requesting device location permissions which can be tricky to get users on board with.

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

@samuelJ As an alternative, you might consider looking up your user's record in whatever data source you are using. It might have the timezone there. Or, if you are feeling code-happy you could use a PCF to get it from AD.

Was this reply helpful? Yes No
cbristol 75 on at

Like (0)

Report
Copy link

Link copied!

could you explain this any further?

I have a similar issue and have watched so many videos.

We have multiple locations around the country and the calendar lookup is in PST. I cannot change SP to anything but PST. All I need to do is force the dates shown in PowerApps as PST.

To get clever showing the individual's time zone would make scheduling easier, but at this point I just need the date to be the same! I don't know why there is no formula for this...

Was this reply helpful? Yes No
DwayneT 10 on at

Like (0)

Report
Copy link

Link copied!

Pacific Daylight Time (PDT) is a North American time zone in use from the second Sunday in March to the first Sunday in November during Daylight Saving Time (DST). Pacific Standard Time (PST) is used during the remainder of the year.

This may help,
Dwayne

Was this reply helpful? Yes No