Unanswered

Timezones and daylight savings

(0) Share

Report

Posted on by jrosen Microsoft Employee

Im working with power automate setting a calendar event using O365 outlook connector v4. Up to this week - its working fine. If I pick a date post DST, its off by an hour. Outlook shows its 8pm UTC, but its coming on my calendar as noon not 1pm. I see a few people with similar issues, but no resolution.

"start": "2021-11-18T20:00:00.0000000",

"end": "2021-11-18T20:15:00.0000000",

"startWithTimeZone": "2021-11-18T20:00:00+00:00",

"endWithTimeZone": "2021-11-18T20:15:00+00:00",

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
You can use the timezoneOffset() function to adjust a time for a specific time zone. If you pass it the local date as an argument it will also adjust for Daylight Savings Time automatically. But it can only do that if you pass it the date as an argument. Here's the documentation that explains:

DateAdd, DateDiff, and TimeZoneOffset functions in Power Apps - Power Apps | Microsoft Docs

If you use this with AddMinutes() when converting from UTC to local time it will take into account the status of Daylight savings on the date you pass it as an argument. Something like this

AddMinutes(StartTimeField,TimeZoneOffSet(StartTimeField))

Was this reply helpful? Yes No
jrosen Microsoft Employee on at

Like (0)

Report

The solution was that the site collection was set to pacific time. I was trying to store the time in the list as UTC. Then in my createevent in powerautomate - I chose UTC. What I noticed is that powerautomate pulling in the list info was getting it in UTC - so my assumption, and what turned out to be correct, was to store the date as pacific time in the list and let it do whatever converstion it does to UTC from powerautomate. doing it this way does correctly return the time including when we switched over to daylight savings.

Was this reply helpful? Yes No