cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Outlook calendar has UTC timezone for all day events

I am trying to create events in Google Calendar from Outlook/O365 events. It mostly works, but all-day events in Outlook come across with UTC as the time zone, so in Google calendar, they're offset. Here's some snippets:

 

see "UTC" as the time zone for this all day event

 

Above, you see StartTimeZone is UTC for this all day event, even though I'm in PDT. Below, how things look in Google Calendar. Since UTC is 7 hours ahead, the event shows up at 5pm on the previous day:

 

event messed up in Google Calendar

 

This is definitely not a problem with the Google calendar connector; it's using the data that's coming across to it. It's somewhere in the Outlook connector that it's incorrectly specifying the UTC for the all day events. Events at specific times come across correctly. 

 

Any chance this can get fixed? Thanks!

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Outlook calendar has UTC timezone for all day events

Hi @ahoward,

 

Thanks for the feedback.

Currently Microsoft Flow would convert the time into UTC timezone, and there are ideas submitted on this already:

timezone and rich time support about outlook canendar integration

Timezone Support for Sharepoint Date Column

 

Please vote the idea up if it meets your requirements, or you may consider submit your own.

Further, for a workaround, we may take use of Addhours function to add the time offset within compose Action.

 

Formula within the Compose Action for the Start time should be:

"@AddHours(triggerBody()?['Start'], -7)"

For End Time, formula should be:

"@AddHours(triggerBody()?['End'], -7)"

Function reference: WorkFlow Definition Language.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Outlook calendar has UTC timezone for all day events

 Hi,

 

I have the same problem. But formula does work for me.

Flow.png

 

 

Highlighted
Frequent Visitor

Re: Outlook calendar has UTC timezone for all day events

AddHours(triggerBody()?['Start'], -7)

AddHours(triggerBody()?['End'], -7)

correct in this way

r.

Highlighted
Frequent Visitor

Re: Outlook calendar has UTC timezone for all day events

I've found the solution:

insert in the start time:

if(equals(triggerBody()?['IsAllDay'],bool(1)), AddHours(triggerBody()?['Start'],-2),AddHours(triggerBody()?['Start'],0))

 

in the end time:
if(equals(triggerBody()?['IsAllDay'],bool(1)), AddHours(triggerBody()?['End'],-2),AddHours(triggerBody()?['End'],0))

 

reference

https://msdn.microsoft.com/office/office365/APi/calendar-rest-operations#create-events

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Users online (5,260)