Need help building a Google-Office 365 Calendar Flow

[Yorcoms]

Hi All,

First off, please excuse the utter lack of technical Flow knowledge - Just starting out

Basically, I want to build a flow that will effectively "Syncronise" entries between an Office 365 Calendar and a Google Calendar.

I.e. When an event created in one, that event is synced to the other.  Same when an event is modified or deleted.

Ideally, this "Sync" would at least include all the basic details (i.e. Description/Title, Start/End Times, Location).  However, it would be perfect if we could get it to also sync other details such as attendees, Notes and alarms.

Finally, I would like to be able to make this FLow available to all our 365 Users to implement for themselves when required - I.e. A pre-prepared "Template" that will only require them to input their specific Google/365 Calendar/Account details.

I have looked at starting this but am alreadty getting lost as whilst there appears to be a connector for this set of functions, my lack of knowledge is preventing me from getting the job done

Is there anybody out there who could help please???

Regards,

Peter RF

Yorcoms

[v-yuazh-msft]

Hi @ Yorcoms,

Do you want to syncronise events between Office 365 Calendar and a Google Calendar?

You could create two flows to achieve your needs, the first one for syncronise events from Office 365 Calendar to a Google Calendar,the second one for syncronise events from  a Google Calendar to Office 365 Calendar.

The steps of the two flows would be basically the same, I would provide the central idea for the first flow:

1. Add a trigger "When an event is addded,updated, deleted" of Office 365 outlook connector.

2. Add three parallel branch,the first one add a condition to check if the "action type" of the trigger is added,the second one add a condition to check if the "action type" of the trigger is updated,the third one add a condition to check if the "action type" of the trigger is deleted.

3.Inside the first parallel branch, get all event of the Google Calendar, and check if the event (in Office 365 outlook) is contained in Google Calendar, if contained, do nothing, if don't contained, create the event in Google Calendar.

4.Inside the first parallel branch,get the same event in Google Calendar, delete the event in Google Calendarand then recreate the event in Google Calendar.(In case of the update for Infinite loop).

5.Inside the first parallel branch,get all event of the Google Calendar,and check if the event (in Office 365 outlook) is contained in Google Calendar, if contained, delete the event in Google Calendar, if don't contained, do nothing.

Please take a try add let me know if it works.

Regards,
Alice Zhang