web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : QgihTB1eRIdpLtKZArYSrn
Power Automate - Building Flows
Unanswered

how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

Like (0) ShareShare
ReportReport
Posted on 21 Dec 2022 10:03:59 by 101

Hi all,

 

Anyone can help me, i try to do automation to create and update existing events in sharepoint calendar when user create or edit a item in another list.

 

but the calendar event list created not appear in the list name... or is it using another different actions?

 

the purpose of this calendar is add a items when a traveler is on that destination during that period.

 

so when user click the specific date over the calendar event, they can track who is traveler on that day and the destination.

 

 

Best regards,

Alan

I have the same question (0)
  • AlanChen Profile Picture
    101 on 06 Jan 2023 at 08:45:47
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @Amit_Sharma 

     

    I successfull testing on a new list and new flow. but there few scenario cause the flow to fail.

     

    1. I create a item with date and destination.. all worked fine, even i edited the date to different or destination still update to latest version.

     

    2. When i create a new item with blank date, the item will still created in calendar but without date info. But error happen when i edit the item and put date into it... then below error appear.

    AlanChen_0-1672994320135.png

     

    so, there is a question here... if there was already have a SyncedID created for the item without date... why it won't grab the id and update to it?

     

    I tested thoose with date created on first version and edited different date or destination after that, all work fine... only thoose created without date at first will have issue when editing after.

     

  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on 06 Jan 2023 at 05:26:24
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @AlanChen 

    -Please try to re-create the flow and try to use new sample lists of SharePoint.

    -please directly put this expression in your update item action in id field which solve the automatically create apply to each action.

    outputs('Get_items')?['body/value']?[0]?['ID']

    Amit_Sharma_0-1672982348666.png

     

    - For all other field in update item action try to get value from when an item is created and modified Action.

    Amit_Sharma_1-1672982595553.png

     

    Still, it's not work then let me know I will send you recorded video of my flow.

     

     

     

     

  • AlanChen Profile Picture
    101 on 06 Jan 2023 at 02:40:51
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @Amit_Sharma 

     

    I did as your flow, but it wont run... there some of my situation occur during the flow creation...

     

    1. i cannot get the traveler tracking (calendar list) which auto appear, then i have to manual add the name which im not sure working or not. which mean all your PTO = GOD Traveler Tracking inside the flow i have to manual type in.

    AlanChen_0-1672972069158.png

     

    2. the No section after condition will become apply to each? 

    AlanChen_1-1672972472639.png

     

    I did as per your flow.. but the flow still not starting... is there flow got issue? do i need to create new?

     

  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on 05 Jan 2023 at 11:00:49
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @AlanChen 

    Please Do Some Modification In your Flow and Calander List (PTO).

     

    1. Add one More Column in PTO (Calander List) Name SyncedID Data Type Single line of text.

    Amit_Sharma_0-1672915639735.png

    Amit_Sharma_1-1672915698498.png

    PTO Another (Another List Where You Create and modify item)

    Amit_Sharma_2-1672915803017.png

     

    2. Modify Flow

    Amit_Sharma_3-1672915903292.png

    Note: Don't Forget to use Single Quotes outside the 'ID' 

    Amit_Sharma_5-1672916146118.png

     

    outputs('Get_items')?['body/value']?[0]?['ID']

     

    All The Dynamic value get From When an item is created or modified Action.

    Amit_Sharma_6-1672916296481.png

    Amit_Sharma_7-1672916380447.png

    Complete Flow

    Amit_Sharma_8-1672916438945.png

     

     

     

     

     

     

  • AlanChen Profile Picture
    101 on 05 Jan 2023 at 09:13:31
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @Amit_Sharma ,

     

    I created a new item, but flow is not running now... not sure what the issue

     

    1. staff will key in destination and country, with departing and returning date in sharepoint list A.

    AlanChen_0-1672909239258.png

     

    2. the flow will capture below item that need to be created in another traveler tracking list (list B) which is a calendar list. and it will also capture if there any changes and update exiting tracking in calendar

    AlanChen_1-1672909368405.png

     

    3. calendar view should have the name created from depart until return date.

    AlanChen_2-1672909698753.png

     

     

     

  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on 04 Jan 2023 at 06:34:02
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    @AlanChen 

    Both list name is difference that's why I have getting same error.

    Amit_Sharma_1-1672814029469.png

     

     

  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on 04 Jan 2023 at 06:26:54
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @AlanChen 

    In Update Item Action Which list you are trying to update it should be same Which List Name Used In when item is created and modified trigger action.

  • AlanChen Profile Picture
    101 on 04 Jan 2023 at 06:02:59
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @Amit_Sharma 

     

    below is the screenshot. i do not understand what this mean "Please try to pass Identifier in Id field which return by when item is created and modified trigger action"

     

    AlanChen_1-1672812133552.png

     

     

  • Amit_Sharma Profile Picture
    1,569 Super User 2024 Season 1 on 04 Jan 2023 at 05:07:59
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @AlanChen 

    What Value you are passed in Id Field of Update item Action.

    Please try to pass Identifier in Id field which return by when item is created and modified trigger action

  • AlanChen Profile Picture
    101 on 04 Jan 2023 at 04:47:44
    Re: how to create and update a sharepoint calendar list when item is created or edited in another sharepoint list

    Hi @Amit_Sharma 

     

    Below is the step

     

    AlanChen_0-1672807644830.png

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 840 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 711 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 373 Super User 2025 Season 2

Last 30 days Overall leaderboard