Today I created a workflow that needs to delete items, of more specifically all documents matching certain criteria in my SharePoint Online based document library.
So I simply dragged in the Office 365 delete items action into my workflow.
Easy! Or maybe not?
In my case my I wanted to delete all documents where a status field was set to Archive.
While I was developing the workflow there was no document with the status of Archive and I found that the workflow gave me an error
Unable to find list item to delete.
Hmm, there are no error handling option on this action and my workflow is falling over.
So I added a query list action to check how many items there are to be deleted.
So by checking if there is anything to delete the error is now avoided and my workflow runs successfully.
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com