Unanswered

add/update/delete calendar to both office365 and google

(0) Share

Report

Posted on by mrose1120

Hi, forgive me if this is found somewhere, but I'm trying to sync a few calendars, a couple O365 and one google. I have the add working well between all of them, but edit/delete i'm having trouble with. Is there a template somewhere or proper way to look at this? I see there is the outlook and google "when an event is added, updated or deleted from a calendar" trigger, i'm just having trouble taking it from that point. Hopefully this is simple and I'm just missing something obvious, thank you!

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @mrose1120,

Could you please share a screenshot of your flow's configuration?

Do you create two separated flows on your side?

If you want to sync events between the Outloook calendar and the Google calendar when you delete/edit an event in one of them, I assume that you want to sync Outlook events to Google events, you should include the Outlook event id into the Google event.

I have made a test on my side and please take a try with the following workaround:

Add a "When an event is added, updated or deleted" trigger of Outlook connector, specify Calendar id.

Add a Condition, left input box set to Action Type dynamic content of the trigger, right input box set to added, within middle drop down, choose is equal to.

Within "If/yes" branch of Condition, add a "Create an event" action of Google Calendar connector, include the Outlook Event Id (Id dynamic content) into Description field of "Create an event" action.

Within "If/no" branch of Condition, add a Condition 2, left input box set to Action Type dynamic content of the trigger, right input box set to updated, within middle drop down, choose is equal to.

Within "If/yes" branch of Condition 2, add a "List the events on a calendar" action, specify Calendar id. Add a "Filter array" action, From set to output of "List the events on a calendar" action, within Condition box, left input box set to Event Description Dynamic content of the "List the events on a calendar" action, right input box set to Id dynamic content of the trigger. Within middle drop down, choose contains. Then add a "Apply to each" action, input parameter set to output of "Filter array" action. Within "Apply to each" action, add a "Update an event" action, Event ID field set to Event Event ID dynamic content of "Filter array" action, the Description field include the Id dynamic content (Outlook Event ID) of the trigger.

Within "If/no" branch of Condition 2, add a "List the events on a calendar 2" action, specify Calendar id. Add a "Filter array 2" action, From set to output of "List the events on a calendar 2" action, within Condition box, left input box set to Event Description Dynamic content of the "List the events on a calendar 2" action, right input box set to Id dynamic content of the trigger. Within middle drop down, choose contains. Then add a "Apply to each 2" action, input parameter set to output of "Filter array 2" action. Within "Apply to each 2" action, add a "Update an event 2" action, Event ID field set to Event Event ID dynamic content of "Filter array 2" action.

Image reference:

When I add an event in my Outlook calendar, the fow works successfully as below:

When I update an event in my Outlook calendar, the flow works successfully as below:

Please also check if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/Building-Flows/two-way-sync-with-calendars-check-for-existing-event/td-p/50443

Best regards,

Kris

Was this reply helpful? Yes No
mrose1120 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks, trying this but only adding works. I get the checkmarks on updating but it seems like its not returning any data.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mrose1120,

Within the "List the events on a calendar" action of the flow I provided above, specify Calendar Id, The Min Time field set to following formula:

2018-01-01T00:00:00.000Z

The Max Time field set to following formula:

addDays(utcNow(),1,'yyyy-MM-ddT00:00:00.000Z')

Image reference:

Then try the flow that I provided again to check if the issue is solved.

More details about using expression in flow actions, please check the following article:

Using expression in flow actions

Best regards,

Kris

Was this reply helpful? Yes No
mrose1120 8 on at

Like (0)

Report
Copy link

Link copied!

Awesome, that worked... now the next thing... it just copied over some recurring meetings from the o365 calendar to gmail 4 times... is that normal? Also, lets say I want to sync 3 different calendars, is there a way to make sure they don't just go in a never ending loop?

For example if I set this up from Cal A->Cal B and Cal C, then B to A and C and C to A and B to make sure its all updated, how can I be sure I don't just get an indefinite number of events added for each meeting?

Thanks in advance, glad I discovered Flow this week, support is great too!

Was this reply helpful? Yes No
mrose1120 8 on at

Like (0)

Report
Copy link

Link copied!

hi, just checking on this.

thanks!

Was this reply helpful? Yes No
mrose1120 8 on at

Like (0)

Report
Copy link

Link copied!

hi everyone, REALLY hoping to get some help with the last piece! Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Try nesting a condition under the yes branches that verifies the event is not already in the other calendar.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

so I got this working finally. Instead of using the Gmail update event, I deleted the event first then just recreated the event. This takes a bit longer but it prevents the dup events. Also I increased the number of days in the add days function to more like 200 so that it will search further into the future.

Was this reply helpful? Yes No
Thomas56 4 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Sorry to potentially reopen this case, but you say:
"If you want to sync events between the Outloook calendar and the Google calendar when you delete/edit an event in one of them, I assume that you want to sync Outlook events to Google events, you should include the Outlook event id into the Google event."

In my case, I'm using mainly google calendar. So I'd like my events created, updated or deleted in Google calendar to be modifed accordingly into office 365. But I don't find any detailed steps on how to configure the flow.
Could you please help me?

Was this reply helpful? Yes No
Thomas56 4 on at

Like (0)

Report
Copy link

Link copied!

I actually found my answer and managed to make it work 🙂

Was this reply helpful? Yes No