Power Platform Community Forum Thread Details

Sync two group calendars

I've just joined a project and they have two MS Teams groups, 2 sharepoints, 2 emails and calendars, etc

One is for the project team and the other for the rest of the organisation.

Now the issue is that they sent the training invites from the project calendar, not the open accessible to the rest of the organisation.

I'm struggling to build a flow that will take a copy of the existing calendar entries from one calendar into the other. And then update, add, delete every time a new one is created/deleted etc.

Ideally I'd also like to filter so that the flow only copies events that have a keyword in the title or perhaps categorised by a certain colour.

I don't need the copied invites to have the attendees (nor should they receive another invite), just the details of the event so we can show this in the company wide sharepoint page by adding a group calendar web part.

Categories:

Business Process Flows

This is a bit tricky since it is not simply an "add". So in the simple case:

trigger, when an event is added on private calendar
- create event in public calendar with details from the trigger output

The tricky part is, when an update or delete need to happen, then you need a way to identify the event in the public calendar to update or delete. There is a "id" dynamic content available after the create event in public calendar, so if you are able to "put" this id somewhere in the original event in the private calendar, then you are in a workable situation, but the question is going to be where are you putting this id.

Easy but not very good: put the id directly in the private calendar event's body, so you can parse it out using substring() and indexOf() expression. If someone has access to edit the public calendar and got rid of this info, you are out of luck.

More work/harder, but more precise: create a sharepoint list of the "linkage". the sharepoint list can have only 2 columns, id of event in private calendar, and id of event in public calendar. Then you can do this flow:

trigger, when an event is added, updated, or deleted
- swtich on Action Type
  - case added
    - create event in public calendar with details from trigger output
    - create item in the sharepoint list: private calendar event id from the trigger output and public calendar event id from the create event action above
  - case updated
    - get item from sharepoint list where private calendar event id = trigger output event id
    - update event in public calendar using the private calendar event id taken from above step
  - case deleted
    - delete item from sharepoint list where public calendar event id = trigger output even tid

Quick Links

Community site session details

Sync two group calendars

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard >

Featured topics

Product updates

Community site session details

Sync two group calendars

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard >

Featured topics

Product updates