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

(0) Share

Report

Posted on by AlanChen

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

All responses (23)

Answers (0)

AlanChen 101 on at

Like (0)

Report

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.

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 1,569 Super User 2024 Season 1 on at

Like (0)

Report
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']

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

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

Like (0)

Report

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.

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

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 1,569 Super User 2024 Season 1 on at

Like (0)

Report
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.
PTO Another (Another List Where You Create and modify item)

2. Modify Flow
Note: Don't Forget to use Single Quotes outside the 'ID'

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

All The Dynamic value get From When an item is created or modified Action.
Complete Flow
AlanChen 101 on at

Like (0)

Report

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.

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

3. calendar view should have the name created from depart until return date.
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

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,569 Super User 2024 Season 1 on at

Like (0)

Report

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 101 on at

Like (0)

Report

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"
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report

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 101 on at

Like (0)

Report

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