cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aplatten93
New Member

Power Automate Flows - Sync two outlook calendars

Hi All,

 

I am aiming to sync two Microsoft Office Calendars. One calendar is for my work account, the other calendar is for a client we are currently working for. My aim is to have net availability in both calendars, but I am running into two major problems:

 

1. The first problem is regarding series events, if any event in the series that is not the original event is updated, then a new event is created. This creates duplicates and is a big problem as you will hardly ever be updating the original event in a series. Also, if you delete any event in the series that is not the original event nothing is actioned.

 

Please see below for my current flow:

 

 

aplatten93_6-1636982917287.png

 

 

 

 

The trigger is 'When an Event is added, updated or deleted (V3)'. I then set variables that are primarily used for Non Series Events.

 

I then set a condition that checks if the event belongs to a series or not:

 

 

aplatten93_7-1636982961211.png

 

There is no problem with single events so if it doesn't belong to a series the flow runs as you would expect.

 

If it does belong to a series this is the logic I currently have. If the 'Action Type' is 'added' we create an event:

 

aplatten93_9-1636983083415.png

 

This works as you would expect when an event is created. I add 'recurring -' to the subject line and I had the 'Series master id' to the body of the email as I aim to use this at a later stage to identify the series events.

 

If the flow is updated this is the current logic:

 

aplatten93_10-1636983157937.png

 

 

The expression used is 'first(triggerOutputs()?['body/seriesMasterId'])'

 

Then when that view of events runs I aim to update the events using the 'Update Event' action:

 

 

aplatten93_0-1636983382919.png

 

 

 

 

However, when a series event is updated in my source calendar the same series event is not then updated in my target calendar.

 

Has anyone got any suggestions on how to fix this problem?

 

2. The second problem is around creating an infinite loop. I want to have net available in my primary calendar on both accounts without creating an infinite loop. I explored the option of using sync calendars, but this is not ideal because in at least one of the primary calendars colleagues will not be able to view my net availability.

 

Does anyone have any suggestions on how to stop this infinite loop. I explored the option of adding a 'Trigger Condition' to the trigger settings around time elapsed since trigger updated date and previous update date, but there is no field for previous update date, so this is not possible.

 

Anyone have any suggestions on how to fix both of this issues?

 

Thanks,

1 REPLY 1
TselaniDrew
New Member

I've been working on something similar and have found that a similar infinite loop is created because of the "Updated" Action which has also caused throttling. I posted this idea:  More Granular Outlook 365 Event/Meeting Triggers 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,571)