Skip to main content

Notifications

Community site session details

Community site session details

Session Id : GnUaqoS7rM57ijzIygIx7+
Power Automate - General Discussion
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 5 Jul 2024 12:35:43 by 14

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?

Categories:
  • Nived_Nambiar Profile Picture
    17,575 Super User 2025 Season 1 on 06 Jul 2024 at 19:14:58
    Re: Syncing outlook calendar to the Calendar List to then display it in sharepoint

    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.

    Nived_Nambiar_0-1720292493364.png

     

    2. Using power automate flow

    Here- u have to use this kind of flow

     

    Nived_Nambiar_1-1720292561418.png

     

    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

    Nived_Nambiar_2-1720292620519.png

     

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

    Nived_Nambiar_3-1720292664114.png

     

    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
    Nived_Nambiar_4-1720293108752.png

     

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

    Nived_Nambiar_5-1720293170139.png

     

    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
    Nived_Nambiar_6-1720293290015.png

     

     

    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! 🙌

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started