14 January, 2016

Increase list item threhsold view - SharePoint Online

Hello Guys, Good to have myself back again to this SharePoint world. It’s been a quite busy hectic time from last few months but here is my article on so called problem of threshold limits with respect to SharePoint lists.

SharePoint Online delivers the powerful features of SharePoint without the associated overhead of managing the infrastructure on your own.

Everybody is aware that SharePoint lists as has certain limit to accumulate number of items so the question is - 

Can i increase list item threshold view in SharePoint online, which by default is 5000? In other words, this error message-

"The number of items in this list exceeds the list view threshold, which is 5000 items" error when you view a SharePoint Online list in Office 365 Enterprise”

Answer would be – No but there is some workaround by which we can play with this limit. 

How? Here is the way-
To work around this issue, split the items into multiple lists so that no list exceeds 5,000 items. Because you'll be unable to view the list items beyond the limit of 5,000 items, you must configure metadata-based navigation so that you can access all the list's contents.

To enable metadata-based navigation, follow the "Enable Metadata Navigation and Filtering" and "Configure Metadata Navigation" sections of the following Microsoft website: 


After metadata navigation is enabled, the list's contents will become available. We recommended that you then reduce the list's contents to less than 5,000 items.

That’s it guys- above mentioned steps are enough to overcome the error message but after following the above mentioned steps, if you still have any doubts then please feel free to reach out. I would be more than happy to help you as well as resolves your issues. Happy SharePoint!