Syncing outlook calendar to the Calendar List to then display it in sharepoint

[matildab2001]

I want to sync my shared outlook calendar I have with my colleagues into a calendar list so that i can then display this as an embedded web part on my site in sharepoint. I am however not sure to go about this , is there any advice I can follow? Does it work even if the calendar is not an individual calendar?

[Nived_Nambiar]

Hi @matildab2001 

I think there are two options

1. using connect to outlook to sync changes in outlook calendar to the event calendar in SharePoint.

2. Using power automate flow

Here- u have to use this kind of flow

Here I am assuming subject of event can be used as identifier

So here we are using a trigger which triggers the flow when event is added, updated or deleted

Now based on action type dynamic content- we will utilize switch action 

If the action type is added> we need to add event in sharepoint calendar

Here set the event calendar name as custom value in list name field so that all other fields will appear

Refer this one to get idea

https://powerusers.microsoft.com/t5/Building-Flows/flow-with-sharepoint-calendar-or-list/td-p/801241

Now add the subject , start and end date like below.

For Start date - use this expression to convert to UTC 

concat(triggerOutputs()?['body/start'],'Z')

for end date > use this expression 

concat(triggerOutputs()?['body/end'],'Z')

Now if the event is updated,it will go to updated case and there it will first try to find the list item id of the event - for that it uses get items and try to find the item id using odata filter query like below

Also do the update item after that (with field values simmilar to create item used under added switch)

Only thing is the expression to compute the id field - 

first(outputs('Get_items')?['body/value'])?['id']

Now when event is deleted, you have to use get items to get the item details for the event subject and then use its id to delete that item - see below

Hope it helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌