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

Need help building a Google-Office 365 Calendar Flow

Hi All,

 

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

 

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 Smiley Frustrated

 

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

 

Regards,

Peter RF

Yorcoms

1 REPLY 1
v-yuazh-msft
Community Support
Community Support

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,874)