cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Community Support
Community Support

Re: Need help building a Google-Office 365 Calendar Flow

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
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,044)