Contents
Create a list on a classic SharePoint or a SharePoint Server 2019 site
- Select Settings.
- Select + New, and then select List.
- Enter a Name for the list, and optionally, a Description.
- Select Create.
- When your list opens, to add room for more types of information to the list, select + or + Add column.
If you’re blocked by the List View Threshold, but your total number of items is less than 20,000, you can add indexes to columns in SharePoint 2019. On all versions of SharePoint, you can create a filtered view with a column index to help reduce the number of results when working with large lists and libraries.
How do I overcome list threshold in SharePoint 2013?
(On-Prem/SharePoint Server Only)
- Go to Central Admin.
- Under “Application Management” click “Manage Web Applications”
- Select the web application for which you’re adjusting the list view threshold.
- Select “General Settings” then “Resource Throttling”
- Change the limit and click OK.
A List will struggle to reference a data in a Lookup column when the number of rows is over the threshold. If it’s a Document Library, consider using the SharePoint Content Organizer to route your documents (based on a condition) to different libraries with the same metadata.
If you’ve operated sites with SharePoint Lists or Libraries for any amount of time, you or one of your customers will trigger the Item Limit Threshold in a List or Library.
Is it possible to have a large SharePoint library?
Best practices and strategies for building and operating large SharePoint Lists and Libraries well above the item limit threshold List or Library above 5000 items is indeed possible with planning and some filtering/sorting compromises. If you can make it modern, you should. The modern experience improves over time; classic does not.
When SharePoint constructs the list forms, all the fields available for the list item are retrieved from the database. Lists with a large number of Lookup columns may result in complex and potentially intensive SQL statements.