Add New or Update Event on Outlook Calendar from Google Calendar

[Callinetic]

Hi @WaltLlanos ,

I think the original question is solved. It’s great to see that it helped you to improve your scenario. However, because you burned your operations, I looked at your scenario again, and it can be improved so you consume less operations.

You have two options. You can update the original google event, or you can work with a datastore to retrieve details about the newly created Microsoft event.

1. Update Google event
   With this method, you actually update the original Google event once you’ve created the Microsoft event. You can update the description by adding the Microsoft Event ID at the end.
   
   Then, when your watcher is triggered, you can parse the event ID from the description using Regex. \(M365 event ID: (.*)\)
   When the event ID is not available, you know immediately that you need to create a new event in Microsoft. Otherwise, you can use the parsed event ID to update the Microsoft event. (Or delete it)
   This will result in the following scenario.
   
   

Note 1: Make sure you enable the option Continue the execution of the route even if the module finds no matches in your regex module.
Note 2: Change your filter to check if the regex result exists.

2. Using datastore
   You can easily keep track of the relation between two events using a 2 column datastore.
   
   
   
   Once the watcher is triggered, you can search in your datastore to see if a record already exists with the Google Event ID. If not, you know you need to create a new event. Otherwise, you need to update the Microsoft event with the ID that is returned from your datastore. This will result in the following scenario.
   
   
   
   Note 1: Make sure you enable the option Continue the execution of the route even if the module finds no matches in your datastore module.
   Note 2: Change your filter to check if the Microsoft Event ID was returned.
   

Extra tip
When developing your scenario, you can easily select from which point you want to start your synchronization. During the development phase, it’s therefore more interesting to select a recent date so you don’t sync all your events since the start of your calendar. This will prevent you from burning operations as well.
Once you want to go live, you can set it to the date you would like it to start from.
You can do this by right clicking your watcher and selecting the Choose where to start option.

So, these are the two options I currently see to cut some operations. Nevertheless, if someone in the community can cut even more (without using custom apps ) that would be very interesting to know as well.

Glenn - Callinetic