Efficient Solution for Deleting Over 30,000 Items in a SharePoint List

(0) Share

Report

Posted on by FlowFalcon

143

Hi everyone,

I need to quickly delete more than 30,000 items from a SharePoint list. Using a flow to list the items and then delete them takes too long. What other, more effective solutions are there? I’ve been searching and only found a premium connector that groups them by 250 items and then deletes them (I can’t recall the name of the connector right now).

Thank you for your help! 😊

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,693 Super User 2025 Season 2 on at

Like (2)

Report

I used the following tutorials to batch delete all the items in a SharePoint list and it doesn't require any premium connectors:

Power Automate Flow to batch delete SharePoint List Items

How to quickly delete items from a SharePoint list with Power Automate using the Batch API

Just be aware that the settings action (which is actually compose action renamed to settings), uses Tracked Properties, and this is used in the body of the batch delete request and in headers of the Send HTTP request to SharePoint action:

You may need to set the batch size to a smaller number if you get a timeout condition. I'm using batch size of 500 which seems to work well for this particular flow. Check the outputs of the Results for any errors or timeouts.

Ellis

https://elliskarim.com/

Was this reply helpful? Yes No
FlowFalcon 143 on at

Like (0)

Report

Thanks EKarim it works fine!!

Was this reply helpful? Yes No