I have a flow where when an item is created in a SharePoint list, the oldest item in that list is queried (via the Get items action). The flow then recreates that item in another SharePoint list and deletes the item from the SharePoint list that it is queried from. Below is a picture of the flow:
This flow very commonly fails on the delete item action with the error message ""Item not found." If I resubmit the flow after it has failed, the flow succeeds. Does anyone know why this might be happening and/or how to fix it so that this flow does not fail and have to be resubmitted?
Hi @CLS720 ,
It seems that the trigger is only used to trigger Flow, and has nothing to do with the execution of the following action.
Then the problem may be that you have an error when configuring the item ID.
I noticed that there are three IDs to choose when configuring Delete item action. This is where you need to focus.
If you want to delete the item in the corresponding List in Get items action, Please use the Dynamic content corresponding to Get items action.
Hope it helps.
I can confirm that the delete action is using the correct item ID (items('Apply_to_each')?['ID']).
Any other suggestions as to why this workflow frequently fails? I also tried putting in a delay, but that did not resolve the issue.
I submitted a premier support ticket and it looks like the cause of the failures is because the flows are running simultaneously. See comment from product group below:
"Looking at the customer's flow and the errors we are seeing in the logs some of these failures are caused by simultaneous running flows. If the Get Items action retrieves the list of items while a previous flow run has not completed deleting items it is processing then it makes sense that a second delete on the same item would error with a 404. It's also possible that creating the same item in the second list will result in errors or duplicate items."
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!