Unanswered

Help with Outlook-Google Calendar Sync

Like (0) Share

Report

Posted on 7 Oct 2018 14:42:20 by ncharlt

Hi - first post so hope this is in the right place. I have a need to sync events from my outlook.com calendar to a Google calendar - one way only. The flow: "Sync events from Outlook.com Calendar to Google Calendar" seems ideal for this and so I've tried it. Unfortunately, I've run into a couple of problems and have no experience of the Flow system so would much value and suggestions or advice:

1. Showstopper: No new events scheduled further than 6 months from now seem to be copied across to the google calendar. I could live with this if I could be certain that, as time passed, these later events would be considered "newly added" in outlook.com and consequently trigger the copying to the Google calendar. Is this actually what happens? I would very much prefer to find a way to remove the apparent 6-month limitation completely or at least replace with a more useful period like a couple of years. A quick look at the 'edit this flow' pages tells me that I have absolutely no idea how do do this. Can anyone help?

2. All whole-day events from outlook.com, which fall in the period when daylight saving time is in effect, are shifted by an hour on arrival in the Google calendar. This causes them to stretch over two days in the Google calendar and causes some problems. Are there any ways to correct this or to work around the issue?

Thanks in anticiption of any help.

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (0)

ncharlt 4 on 13 Oct 2018 at 10:33:05

Like (1)

Report

Re: Help with Outlook-Google Calendar Sync

Many thanks for the reply - very helpful. During my investigations, I have noticed that if I set an event for 180 days ahead, it won't pick it up but, 5 days later, it does pick it up and transfer it so at least that's good. Thanks for the info re all-day events. I wouldn't be good at 'adding functions' so I'll wait for the fix.

I did manage to find the 180 day setting you referred to. Here's exactly what I did:

Edit Flow / Click on 'when an event is changed / select advanced options

This shows three parameters, with their values exactly as you said. I changed 180 to 800 and pressed save. Went back into edit to ensure that it had saved - it had. I then set some appointments up for 798, 799 800, 801 and 802 days from now, expecting the first few to come across when the sync was triggered. Unfortunately these new events never triggered the sync. Even when I put an event a few days from now, in order to trigger a sync, the 798 days-ahead event never got synced.

I repeated the entire process with the 180 changed to 360 - thinking that maybe 800 was too optimistic. The results were exactly the same with events at 358 days etc not triggering a sync and, when async is triggered by an event in the near future, these later events still do not get synced.

It's almost as if the 180 day ahead limit is hardwired somewhere else in the code, overriding my change of that setting. Or maybe I changed it in thw wrong place.

If you you have any further ideas or advice on this I would be most appreciative.

Was this reply helpful? Yes No
v-yamao-msft on 11 Oct 2018 at 08:36:41

Like (0)

Report

Re: Help with Outlook-Google Calendar Sync

Hi @ncharlt,

Do you mean that you create an event which is scheduled further than 6 months from now won’t be copied from Outlook calendar to Google calendar?

In the Outlook.com trigger, please try to change the Incoming Days tracked and Past Days Tracked to a larger value to see if it will work. The default value for these two fields are 180 and 90.

About your second question, all day events created from Outlook.com or Office 365 Outlook may be offset due to the time zone in Google Calendar, and PGs are now working on resolving this issue. Please check this doc at here:

https://docs.microsoft.com/en-us/business-applications-release-notes/april18/microsoft-flow/calendar-sync-templates

A temporary workaround for this issue might be use the function addhours/adddays to return a proper timestamp. More details about the function:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#addHours

Best regards,

Mabel Mao

Was this reply helpful? Yes No