Answered

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

(0) Share

Report

Posted on by FlowFalcon

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:

Business Process Flows

All responses (2)

Answers (1)

FlowFalcon 95 on at

Like (0)

Report

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

Thanks EKarim it works fine!!
Verified answer

EKarim 10,270 on at

Like (2)

Report

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

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/