cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

existing item modified update item flow failure

I have a SP list A and SP list B

 

I have two flows when item is created in SP list A it is created in SP list B this works fine for me

 

I have another flow where by if an existing item in list B is modified i want the list in item A to be updated

 

for some reason when i run test run the flow for the second step it fails I get the following error

 

{
"status": 404,
"message": "Could not find list item.\r\nclientRequestId: 896367f2-84ec-4086-88f1-48414f902610\r\nserviceRequestId: 896367f2-84ec-4086-88f1-48414f902610"
}

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: existing item modified update item flow failure

Hi @MoEdu 

 

Thanks for the discussion. 

 

Get Items list should be the same as the Update List item. So from the Get Items you can get the Id and pass the Id to update list item. Hope it make sense.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

28 REPLIES 28
Highlighted
Super User
Super User

Re: existing item modified update item flow failure

HI @MoEdu 

 

Let me check if this is what you're doing.

 

When you save to SP B, do you store the ID from SP A? The IDs created are different, so you should save it so that you can perform an "Update Item" with the ID from SP A.

If you do a "Get Item" and provide an ID that doesn't exist you get an error message similar to that. 

 

Does it make sense?

 

Please let me know how this works out for you so that I can try to help you further.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

 

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hi @manuelstgomes 

 

So when item is created in SP list A it is also then created in SP list B - this works fine with no issue

 

my second step I want is if item B is updated by the user I want item A to also be updated

 

so my second flow is as follows

 

first step is when an existing item is modified

second step is update item

 

It appears to be failing on the second step 😞

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Can anyone please help me on this flow, I am in urgent need to get this fixed

 

If someone could provide an example that will be really useful 

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

HI @MoEdu 

 

Can you show me how you're doing the update? 

 

I can understand your issue, but I need to see what you're doing to be able to help you further.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hi @manuelstgomes 

 

Thank you, I am new to all this so your help and guidance is appreciated! 🙂

 

How can I upload screenshots?

 

So the full requirement of what I need is as follows:

 

When an item is created or modified in SharePoint list A, B, C, D


- Create item the above items in list E


- Send an email to the person who created the item in list A, B, C, D to the person who is in list E

 

Second part of the requirement is..


When an item is modified in list E

 

Update list A, B, C, D

 

And send an email to the person who created the item

 

 

So to summarise, I have 4 lists each time something is created in these 4 lists, these should be appear in another new list. Each time there is a change/update to the new list these should then be updated in the 4 lists.

 

I hope this makes sense, look forward to hearing from you

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

HI @MoEdu 

 

No worries, happy to help.

 

I think a screenshot would be helpful. Just login and tap in the camera button:

Screenshot_2019-12-02_at_10_01_20.jpg

 

Then you'll be able to upload an image.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hi @manuelstgomes 

 

I've uploaded pics hope this helps, if you could provide me an example I could work from and test that would be great

Step 1.PNGStep 2.PNG

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hey @manuelstgomes 

 

Did you manage to find a solution?

 

look forward to hearing from you 🙂

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

Hi @MoEdu 

 

In the last screenshot, you're using the ID to update the lved002 but this ID is probably coming from lved000 correct?

 

I think this is your issue. The IDs in both SP are not the same, so you're probably updating another value instead of the real one. You should keep the lved002 ID stored somewhere in lved000 so that you can map correctly the items from one list to another.

 

Does this make sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hi @manuelstgomes 

 

The id field the only option in dynamic content is ID

 

I have no other option to select anything else, do I need to add in another step or something?

 

Could you map out the flow for me so i can better understand?

 

Thanks

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

Hi @MoEdu & @manuelstgomes 

 

The issue here is you are trying to update 0002xxx list with the wrong identifier (ID). Retrieve the list id before the update. Map that id and keep the rest of the mapping in your update. Then you should be able to update.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Super User
Super User

Re: existing item modified update item flow failure

HI @MoEdu 

 

Just let me try to understand. Do both lists always have the same values? What you're trying to do is keep list 2 updated when list 0 has some changes correct? 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

hi @manuelstgomes  yep that is correct

 

 

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

HI @abm

 

Exactly! That's what I tried to convey in my last message, but you explained it better.

 

@MoEdu does this make sense for you?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

hi @abm 

 

so do I need to add in another step in between? what would be the name of the step? sorry I am new to all this and still learning!

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

Hi @MoEdu 

 

Try to follow @abm suggestion.

 

It's just a question of fetching the list 002 and use that ID in the update. All the other values can come from list 00 so that you're sure you're updating all the information.

 

This can be tricky when selecting the stuff from the list, so I recommend naming the actions something like "Fetch items from list A", "Fetching items from list B" so that, in the list, you can see what ID are you fetching.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

@manuelstgomes @abm 

 

Can someone please provide me a real life example?

 

I have added in get items in between, but it is still failing 😞

 

Also to add, the 2 screenshots I provided are two separate flows they are not combined all in one, not sure if that makes a difference?

 

When I test run the flow it is failing at the last step update item

 

 

Highlighted
Super User
Super User

Re: existing item modified update item flow failure

Hey @MoEdu 

 

We're almost there, don't worry.

 

Here's an example..

Screenshot_2019-12-05_at_11_23_50.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: existing item modified update item flow failure

Hi @manuelstgomes 

 

Thank you for your patience, and all you help this far!

 

your second and third step is the name of the step get items? if so I have added in get items but the 'ID' does not appear only site address and list name appears

 

Capture.PNG

 

any ideas?

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,234)