Action 'Get_item_information' failed to SharePoint List Error 404

[MichaelS1]

I have a suspicion that there might be deleted entries in a SharePoint list that are still being referenced. Therefore, I believe the Power Automate flow needs some logic to handle this issue. During a recent run of the flow, it referenced "ID-21" which doesn't seem to exist anymore. I have verified using a PowerShell script that only entries with ID 18 and 19 exist. I hope this information is sufficient for someone to help me troubleshoot and find a solution to make the flow work properly.

Any suggestions on how to improve my question are appreciated.

Id = @{triggerBody()?['entity']?['ID']}

[FLMike]

Hi

What would constitute working for you, as in if this fails what do you want to do. So many times I assume you want to exit and the person says no I want to continue. So I want to verify 🙂

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[MichaelS1]

Thanks for replying back.

Adapt the Workflow to Handle Deletion or Movement of Item:
- If the item exists, proceed to the next operations.
- If not, either end the workflow

Will this resolve the 404 error?  Does this answer your question?

So frustrating. It seems weird that Power Automate wouldn't account for deletions as that should be a pretty common scenario.

[MichaelS1]

If "Adapting the workflow to handle deletion or movement of items" is not necessary and the workflow can continue as is without any issues, would that alternative be more efficient?

[FLMike]

Hello,

They are essentially the same thing. If you have a loop or you have a conditional branch or anything that you need to continue doing even if some part fails, then you have a couple of options

Option 1

Right after the Action that might fail, you would put in parallel branches and for one of them you would Click the  ... and set the Configure to Run After to (Is Successful) so that if the previous step succeeds you keep doing.

And the other you would selected Failed/Timedout/Skipped, so that this branch would run if the previous step fails.

Option 2

Or you can place error handling around the action that might fail, and then you would decide if you just want to continue on, or retry or just keep processing or if you need to terminate that flow or that iteration of a loop for instance.

Imagine your scenario is updating SharePoint with some log data, and then later on you update SharePoint with some real business data. You might allow the log to fail and keep going. In which case you can do either option, depending on if you will retry or not and what data you want to log due to the failure etc.

In your case you can pick after the Git Item if you want a parallel branch, where one keeps processing and one writes to a log file or emails to let you know there was a problem. Of use the error handling one, and when you capture the error, you can decide based on the error what to do.

If you dont care, do option 1 and then just use the Terminate action, and log a Failure message and be done

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[MichaelS1]

Oddly, we've used this template in other places and works fine.  I guess no one deleted an item before thus this problem started.  I find this all very interesting / odd.  Can you explain option 1 in more detail please I can try set that up.

This is a flow called Start Internal Approval

[MichaelS1]

I was able to get successful "Run"; however, I'm not sure this is real fix.

From my first post I mentioned ID 18 and 19 were valid.

As a test, I changed ID hardcoded to ID 19 (as seen below) vs @{triggerBody()?['entity']?['ID']}.  This resulted in success; however, I assume any new entries added this "Start Internal Approval" won't work correctly now.

[FLMike · Accepted solution]

Hi,

Now sure why you are saying something isn't a fix. Why would new ones in the list not work?

Anyway #1 would look like this

As I said though you don't know why it failed. You just need to Click the  ... and set the right side to Success, and the left side (Terminate) to Fail/TimeOut/skipped. I simply terminated it. You can add logging or whatever you want to do there instead. But the flow would stop right then for any time the Get Item fails.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[MichaelS1]

Thank you for your response! I apologize if I misunderstood your previous suggestion. I will definitely try implementing #1 as you suggested and set the right side to Success and the left side to Fail/TimeOut/Skipped. I also agree that adding logging or additional actions for error handling would be beneficial.

I appreciate your help and will mark your answer as resolved once I have implemented and tested the solution. Your guidance has been really helpful!

[MichaelS1]

Maybe I don't understand how to build this out correctly. I'm getting the same error what am I doing wrong?

[MichaelS1]

I got it working back to original setup.  Was corrupted item in the Site Collection itself causing the issue.

Thanks for all your help.

[FLMike]

No worries but just so you have the process in the future.

If you look at your pictured, you added a Condition check for the 404. Look at mine. There is nothing like that. There are just 2 arrows. (parallel paths). One side is automatically set to failed by selection that from the ... Configure Run after.

It is in that side, that you would capture the error using a function called result('Name_Of_Action_Here'). Which would get your Get Items.

But I plan on writing this up. There are some out there, but I have an example app and power automate that will be in GIT, which I will share. Easier than typing it up 🙂

[MichaelS1]

---

@FLMike wrote:

But I plan on writing this up. There are some out there, but I have an example app and power automate that will be in GIT, which I will share. Easier than typing it up 🙂

---

Please let me know if you share this somewhere else.  I'm always interested in learning more about Power automate. 

Thanks for the tips I will try this in test environment.