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_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,825)