Sync Outlook Calendar Events to Google Calendar using Power Automate | Create, Update or Delete
In this video, you’ll learn how to sync Outlook Calendar events to Google Calendar using Power Automate. The sync works for creating, updating, and deleting events on the Outlook Calendar.
Here’s how to design the Power Automate flow:
1. Create a new automated cloud flow in Power Automate.
2. Select the trigger for when an event is added, updated, or deleted on the Outlook Calendar.
3. Add a condition to check the action type (add, update, or delete) of the calendar event.
4. If the event is added, on the true side of the condition:
o Add an action to create an event in Google Calendar.
o Store the event IDs from both calendars in an Excel file. To do this, create a new Excel file in OneDrive, add two columns for the event IDs, and convert the columns into a table.
o Add an action to insert a row into the Excel table to store the event IDs.
5. On the false side of the condition, add another condition to check if the action type is updated.
6. If the event is updated, on the true side of this second condition:
o Retrieve the Google Calendar event ID using the Outlook event ID from the trigger.
o Update the event in Google Calendar.
7. On the false side of the second condition, add another condition to check if the action type is deleted.
8. If the event is deleted:
o Retrieve the event IDs.
o Delete the event in Google Calendar.
o Delete the corresponding row in the Excel file.
Once the flow is set up, save it and test it by adding, updating, and deleting events.
The sync works almost instantly. You can disable the flow when not in use.
This is a one-way sync from Outlook to Google Calendar. Be sure to subscribe to watch the other video that demonstrates the reverse process.
Chapters:
0:00 Intro
0:21 Create a new Automate cloud flow on Power Automate
0:35 Select the trigger when an event is added, updated, or deleted on Google Calendar
1:16 Add a condition to check if it is a new event
1:57 Add an action to create the Google event
3:31 Create a new Excel file to store the Event IDs
4:30 Add a new row using the action
6:03 Add condition to check if the event is updated
8:45 Add condition if the event is deleted
9:45 Delete the event
11:22 Test the flow
13:15 Check the flow run history
13:37 Turn off the flow when not in use
Subscribe to the channel:
https://www.youtube.com/technologiate...
Follow and engage on social media:
Facebook: / technologiate
Instagram: / technologiate
#calendarsync #outlook #googlecalendar #powerautomate #cloudflow #microsoft
