Efficiently empty a large SharePoint Online list

08 Feb 2017
February 8, 2017

Ages ago I created a PowerShell script that I used a couple of times by now: efficiently empty a large SharePoint list – but apparently that code does not work against a SharePoint Online list.

a simple script to empty a SharePoint Online List

So here is an updated version of the script:

Or download the script from here.

You can call the script with the following parameters:

I tried it several times on my tenant (and I even created a script to create thousands of items): Once I got rid of all the timeouts I got a delete performance of 11,84 items per second. Not great, but still faster than the Quick Edit View, right? 🙂


There is no way back – if you start the script there is no “ARE YOU SURE?” – all data is gone in a very short time.

Max Melcher
Follow me!

Max Melcher

Maximilian Melcher (MCSE, MCPD) is a Principal Consultant working at Alegri International Services in Munich, Germany. Max is a specialist in SharePoint technologies focused on search, social computing, web content management and collaboration. Max has led SharePoint implementations for Dax 30 companies since 2009.
Max’s free time is spent on twitter (@maxmelcher) mostly with a good coffee in his hands.
Max Melcher
Follow me!
1 reply

Trackbacks & Pingbacks

  1. […] SharePoint Online? Read this: Efficiently empty a large Sharepoint Online List […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.