reaching 5000 items in a list

Question

I have made a test and reached 5020 items in a list. I get this message in the list settings 'The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.'

I can still add items to the list, however the above message sounds threatening enough. Do you know if Microsoft has got alerts on their end and might decide to restrict throttling or other parameters on the tenancy?

Answer 1

For Office 365, this is hard limit and can not be modified. You will need to redesign application to work around this limit.

When using Office 365 interface there are following ways to do this:

1. Organize items in folders such that no folder in list/library has more than total of 5000 items/documents and folders. One can come up with appropriate folder structure based on business sense of the application.

2. Use Indexes on field which are used to fetch data.

3. Instead of using "All Items" view, create your own view which filter data on indexed fields such that no more that 5000 records are part of view.

Reference Manage large lists and libraries in SharePoint