Creating Flow to Sync Outlook.com Calendar with Google Calendar

[kjw]

I am trying to create a flow that will perfectly reflect my Outlook calendar (in real time) to my Google Calendar. I primarily use Outlook over Google, but need the synchronization for personal & professional reasons. 

I cannot use the template for the Outlook 365 version of Outlook because I don't have Outlook 365, so I need to use the triggers that are specifically for Outlook.com.

My biggest issue/headache is figuring out how to Update and Delete events in both calendars. For example, I can easily create a flow that creates an event in Google Calendar after I create the event in Outlook Calendar. However, after this event has been added to both calendars I cannot figure out how to associate the event IDs together so that when I update the event in Outlook the same event is updated in Google. This is the same issue I have with deleting events in Outlook, I can delete them in Outlook but the event remains in the Google Calendar.

I believe I need to try linking the event IDs together somehow, but I'm not quite sure how to do that. I am new to flow, but want to learn more about it and how to create my own automations, and I think learning how to create this "simple" calendar syncing flow is a good starting place for me.

Thank you in advance for any help!

[edgonzales]

@kjw 

Hey there.  You are exactly right, you will need an intermediate 'table' to track corresponding event ID's.  I did the blog post below a while ago, and it's going primarily the other direction (Google to Outlook), but the principles should still apply.  Take a look, maybe it will help:  Calendar Sync with Switch in Power Automate / Flow

Either way, keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[kjw]

This is definitely what I need/want to do in my flow! I only dont understand how to pull the event IDs from the newly created events into a OneDrive Excel.

Would you mind going a little more in detail on how to do this exactly? 

I'm tinkering and searching for online guides on this but can't seem to figure this bit out. Once I can create a reference pool of linked Outlook and Google event IDs I think the rest will fall in place.

[edgonzales]

@kjw 

You bet.  So, if your trigger is 'when an event is created/updated/etc...' in Outlook, that will have the Outlook event ID with it as a dynamic value...that's one side of the table.  Then, when you create the corresponding Google event, that will create a Google event ID....which is the other side of the table.

If you create a table (Excel, SharePoint List, CDS, whatever) with two columns...one for OutlookID and one for GoogleID, then you can have a step that adds a row to that sheet when an item is created.

If an Outlook item is later updated, you can filter that table on that particular OutlookID to find the corresponding GoogleID.

Does that help?

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.