Archive for month: February, 2017

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.

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.