I'm attempting to sync events (creations, updates, and deletes if possible) in two directions from Outlook 365 to Google Calendar and vice versa. I've looked at a couple of community flows as well as some information on the internet, but a lot of it seems outdated or incorrect and thought I'd post what I have so far here to make sure the setup is correct and up to date and hopefully document it for anyone else that might want to do the same.
Currently, I've got the following flows:
- Copy new events in Office 365 to Google Calendar and send a notification: https://us.flow.microsoft.com/en-us/galleries/public/templates/f9a2b550ebca11e6847527b0ccfd422d/copy-new-events-in-office-365-to-google-calendar-and-send-a-notification/
- Update Google Calendar events previously created from Office 365: https://us.flow.microsoft.com/en-us/galleries/public/templates/0e21ee50b17a11e68af78d1a54677f1f/update-google-calendar-events-previously-created-from-office-365/
I was about to activate the "Copy Google Calendar to Outlook.com Calendar" flow: https://us.flow.microsoft.com/en-us/galleries/public/templates/1aec5e38c58444d7b5bb8e97bee9742d/copy-google-calendar-to-outlookcom-calendar/
However, I realized a couple of things. This last flow isn't fully fleshed out. It has a condition to ignore "things copied in the other direction" but doesn't actually provide the criteria. Flow 1 above provides the criteria for it's condition (Body does not contain "on your Google Calendar"). So it looks like someone has at least started to think about making these work together, but I'm wondering how much alteration is needed.
Additionally, there appears to be a more highly recommended flow related to Google Calendar to manage the updates from Outlook to Google here - Update Google Calendar events when an event is modified in Outlook.com: https://us.flow.microsoft.com/en-us/galleries/public/templates/655afffb6ec441268738eae0544421bf/update-google-calendar-events-when-an-event-is-modified-in-outlookcom/
I'm just wondering if anyone has set this up before, which flows they used, and what (if any) alterations were made.
Things to keep in mind:
- Syncing in both directions requires a filter on each side to prevent an infinite loop of events being created.
- These filters need to work together. i.e. Flow A needs to add some text that Flow B can recognize and filter on and not send the event back.
- Updates from Outlook seem to be trickier and separated into two flows (one for creates, another for updates)