cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MoEdu
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"
}

28 REPLIES 28

hi @manuelstgomes @abm 

 

Not sure if I am explaining correctly or over complicating my requirement, this is what I need

 

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

Then this should also be created in list E

User in list E should be emailed


if list E is updated with any changes to the fields then list A,B,C or D should be updated

User in list A,B,C or D should be emailed

so any changes should be mirrored vice versa

All the lists are identical

I hope this makes sense

abm
Super User III
Super User III

Hi @MoEdu 

 

If you available now I can do a screen share and help.

 

@manuelstgomes  you are most welcome to join as well.

 

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 blogPower Automate Video Tutorials

Hi @abm 

 

That's very kind of you, however my machine is locked down and doesn't allow me to install any screen sharing software 😞

 

I could call you 😉 , I am based in the UK

 

Or alternatively could you provide screenshots of the flow that I can follow?

hi @abm 

 

Please talking to you!

 

I've ran the flow but it failed 😞

 

appreciate your thoughts...Capture1.PNGCapture2.PNG

abm
Super User III
Super User III

Hi @MoEdu 

 

You filter query must be your sharepoint list columname(AOReference) eq 'map the dynamic field property'. I can't see the equal condition here. We have discussed this earlier.

 

image.png



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 blogPower Automate Video Tutorials

hi @abm 

 

apologies my mistake, I did add the filter query in and ran the flow it was not successful as it failed at the get items stage which is why I removed it and left in the dynamic field property. When I ran the flow again it passed at this stage but failed at the last stage of the flow

 

Weirdly I have added the filter query back in and the flow now runs successfully! however any changes I make in list A are not

reflected in the second list

 

filter query.PNGflow sucess.PNG

 

any ideas?

Hi @MoEdu 

 

Use "Get Item" instead of "Get Items". To get a specific item you need an ID. To get items you just need a query.

 

Makes 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

abm
Super User III
Super User III

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 blogPower Automate Video Tutorials

View solution in original post

I would like to provide my thanks to @abm he has been very patient and knowledgeable in providing assistance and support to a novice like me who is new to ms flows!

 

A valuable asset to this forum! keep up the good work!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (56,118)