Syncing calendar events from outlook to Gmail calendar using Flow.

Recently I started working on Microsoft flow for one of the client where we are migrating the workflows from SPD (SharePoint designer) to Microsoft flow. I liked flow for the way we can automate some of the small daily tasks.  

Flow provides us connectors through which we can connect many applications to the flow like Gmail. Flow gives us lot of templates which we can start with or create a new flow starting from blank.  

Scenario:-  

I want to sync my outlook calendar (company) to my google calendar which is available on my android phone. Syncing my company's calendar which helps me in tracking of my events on my mobile.  

Prerequisites:-  

Having a Microsoft online account for logging into the Microsoft flow. 

Trigger:-  

A new calendar event on the Microsoft outlook calendar. 

Steps for creation of the flow.  

Steps for creation of the flow.  

1. Navigate to the Flow connections page and create connections for the google calendar and the outlook mail. Select connections from the settings(Top right corner) drop down.  

 

 

2. Connections page will show all the connections which are configured for the logged in user.  

 

3. Click on the new connection link at the top right corner.  From the new connection page search for Google and click on google calendar. Provide the credentials for the google calendar.  

 

4. Similar add new connection for Microsoft outllok also.  

 

5. Now we need to create the flow using these connections. Navigate to the My flows page. On my flows page select Creat from template link.  

 

6. On the template page search for Google calendar. You will get all the templates related to Google calendar. Select outlook.com calendar to Google calendar template.  

 

7. It will navigate to the template details page, details page will show the connections that are required. Click on continue.  

 

8. It will take you to the create flow page. First action step will be triggered when ever a new event is created in the outlook calendar. On the first step select the calendar from outlook for which you want to Sync the events.  

 

9. Second step in the flow is checking for any event is already created using the same body. Its for avoiding duplicate events.  

 

10. If the condition is satisfied a new event will be created in the google calendar. If no then nothing gets done. In the create an event action for google select the calendar from the drop down. Html to Text conversion action is used for conversion of the body of the calendar event from HTML to text.  
11.    
12.  

    11. After completing all the configurations click on create flow at the top. It create a flow and will be shown under my flows tab. Users can edit the flow after the create.  

     
    12. When ever a new event is created in the outlook calendar an event will be created in the google calendar.  No of times a flow is run and whether the runs are successful are not can be viewed from the run hisotry of the flow.  

     

    13. I have added an additional error handling step to the flow, if the flow fails to run or get timed out due to any of the reasons a mail will be sent to the administrator to look into the error. The action will be configured if any of the steps fail or timed out.  

     

    Check the setting of the action Send an email 
13.    
14.