cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SS76
Regular Visitor

Creating and updating sharepoint list

Hi 

I have been struggling with this all week. 

 

I have created four lists

List 1 - Master list - Information captured and updated 

List 2 to 4 - 3 different teams work on and need access to only certain information

I managed to create flows to create lists from master list. I am having an issue updating from master list to all other lists without creating duplications 

 

Help please and Thank you

 

the consitiona appliedthe consitiona appliederrorerrorerrorerrorerror detailserror details

5 REPLIES 5
PrasadAthalye
Super User
Super User

Can you please upload entire flow diagram? It is not clear from these pictures how you designed it.

 

Based on the error, it seems you are using incorrect ID to update item. Did you use getitem on the same list and used ID from that action?

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Gopala_Krishna
Super User
Super User

@SS76 

Can you please check if the id is same for both master list and other lists. Error in the flow suggests that there doesn't exist any item with the ID being retrieved from the master list.

 

For example, let us consider your master list has 4 items, and the lists 2-4 have 2 items in each of them. Now when you create a new item in the master list the ID value for that item would be 5, if you try to update items in the list 2/3/4 they don't have any item with ID 5 and this would give error indicating could not find the list item.

 

Please check if the ID in master list matches with the child list items.

 

---------------------------------------------------------------------------------------------------------------------------------

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

SS76
Regular Visitor

Hi 

 

Thank you so much for your help. Please see below. 

 

SS76_2-1621164266071.png

 

SS76_3-1621164357945.png

 

 

In the update Item, Are you using ID from the Create Item action? If not, can you change it and test?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

When i do that - it updates but also creates a new item on the second list causing a duplication

 

Thank you for your assistance

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,099)