Office 365 – SharePoint Online – Dealing with the 5000 item limit

Believe it or not, it is entirely possibly to hit the 5000 item limit that is put in place for any view of lists in SharePoint Online in Office 365. If you do hit this, you will find an error telling you that the item limit set by the administrator has been exceeded.
There is a limit of 5000 items in any view on a list - if your list is going to get anywhere near that limit, use an indexed column and then create filters that make sure that you won't go beyond 5000 items in a view. For example, limit a view to the last 12 months of data, or limit the view to 4000 items.
Office 365 - SharePoint Item Limit If you find yourself in the situation where you can't do anything with the list, having exceeded this 5000 item limit in the default view, you won't even be able to delete the list! If this happens, open the list in SharePoint Designer 2010, then click 'Administration Web Page' in the 'Manage' group on the ribbon. The ID is indexed by default, so create a view that is that is guaranteed to return less than 5000 items, using filtering based on the ID of the column. Now, go into that view and move out enough of the items in the list to get you below the 5000 item limit. Once that's done, you can create a new indexed column (or maybe more than one). Now, edit your views to filter based on those indexed columns. Good to go!
Again, prevention is better than cure here - It took me a few hours to find this work-around and you should always aim to reduce impact on users. After I first encountered this issue, I future-proofed using the tips above (indexing and view limits) to make sure that this wouldn't happen for other lists.
I hope this has helped a little bit. Drop a comment below if you have any questions or comments.
  • Comments
  • Trackbacks
  • Further Info
10
  1. September 16, 2012 at 8:42 pmAndrey - Reply

    I have a problem how to delete the list with 5000+ items and can't do it on Sharepoint Online. Sorry, but the explanation "If you find yourself in the situation ..." and after was not so clear. Could you be so kind to put some print screens how to make it?

    Cancel
Leave a Reply

Leave a Reply

Reply to:

posted on   June 12, 2012
in   SharePoint
tagged   , , , , ,