How do I delete a list with over 5000 items?

%3CLINGO-SUB%20id%3D%22lingo-sub-972078%22%20slang%3D%22en-US%22%3EHow%20do%20I%20delete%20a%20list%20with%20over%205000%20items%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-972078%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20that%20was%20forgotten%20about%20and%20it's%20continuously%20growing.%20It%20has%20over%20100k%20items%20and%20I%20need%20to%20delete%20the%20list%20because%20it's%20over%20the%205000%20item%20threshold.%20Does%20anyone%20know%20how%20I%20can%20do%20it%20quickly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-972078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-973124%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20a%20list%20with%20over%205000%20items%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-973124%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292517%22%20target%3D%22_blank%22%3E%40timparsons%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I'm%20assuming%20you%20tried%20to%20delete%20the%20list%20the%20easy%20way(using%20the%20UI)%20and%20it%20didn't%20work%20out.%3C%2FP%3E%3CP%3EMaybe%20if%20you%20try%20it%20using%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2FPnP-PowerShell%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPnP%20Powershell%3C%2FA%3E%20it%20could%20work%3F%20Could%20try%20the%20command%20%22Remove-PnPList%20-Identity%20%3CLISTNAME%3E%20-Force%22%20and%20see%20if%20it%20works%3F%3C%2FLISTNAME%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-974669%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20a%20list%20with%20over%205000%20items%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-974669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365643%22%20target%3D%22_blank%22%3E%40Carlos_Marins%3C%2FA%3E%26nbsp%3B%20That%20didn't%20work%2C%20unfortunately.%20How%20could%20I%20specify%20which%20site%20the%20list%20is%20on%20using%20a%20similar%20command%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977821%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20a%20list%20with%20over%205000%20items%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977821%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F292517%22%20target%3D%22_blank%22%3E%40timparsons%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20get%20any%20error%20trying%20to%20do%20it%3F%3C%2FP%3E%3CP%3EAbout%20the%20site%20question%2C%20you%20don't%20know%20which%20site%20is%20the%20list%20being%20stored%20on%3F%20Because%20you%20need%20that%20info%20to%20connect%20to%20your%20site%20through%20PnP%20PowerShell%2C%20using%20the%20%22Connect-PnPOnline%22%20command.%20Maybe%20that's%20why%20it%20didn't%20work%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20found%20%3CA%20href%3D%22https%3A%2F%2Feschrader.com%2F2018%2F05%2F09%2Fdeleting-a-large-list-from-sharepoint%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20article%20that%20seems%20to%20solve%20your%20issue.%20Let%20me%20know%20how%20it%20goes%20for%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a list that was forgotten about and it's continuously growing. It has over 100k items and I need to delete the list because it's over the 5000 item threshold. Does anyone know how I can do it quickly?

3 Replies

Hey @timparsons ,

 

So, I'm assuming you tried to delete the list the easy way(using the UI) and it didn't work out.

Maybe if you try it using the PnP Powershell it could work? Could try the command "Remove-PnPList -Identity <ListName> -Force" and see if it works?

 

Regards

@Carlos_Marins  That didn't work, unfortunately. How could I specify which site the list is on using a similar command?

Hi @timparsons !

 

Did you get any error trying to do it?

About the site question, you don't know which site is the list being stored on? Because you need that info to connect to your site through PnP PowerShell, using the "Connect-PnPOnline" command. Maybe that's why it didn't work for you.

 

Also, I found this article that seems to solve your issue. Let me know how it goes for you!

 

Regards