SharePoint Online's list view threshold of 5,000 items has not changed since SharePoint 2010. It is the single most common operational limit that Microsoft 365 admins encounter in production environments, and the most misunderstood. This reference covers what the threshold is, exactly which operations it affects, and every supported workaround.
What Is the SharePoint List View Threshold?
The list view threshold is a server-side limit that prevents list queries from scanning more than 5,000 items in a single operation. When a query would exceed this limit, SharePoint blocks the request and returns an error rather than attempting to process a result set large enough to degrade shared infrastructure performance for all users on the tenant.
The limit applies to the number of items a query must scan, not just the number it returns. A filtered view on a 10,000-item library that returns only 50 results can still trigger the threshold if the underlying query scans more than 5,000 rows to find those results. A column index on the filter field prevents this by letting SharePoint jump directly to the matching rows.
The 5,000-item threshold cannot be raised in SharePoint Online. In on-premises SharePoint Server, farm administrators can adjust this limit, but the option does not exist in Microsoft 365. Large-list design decisions must work within the limit, not around it by raising it.
Threshold Limits by Operation Type
Beyond the primary 5,000-item view limit, SharePoint Online enforces several related constraints - each with its own error message and fix.
| Operation or scenario | Limit | What happens when exceeded |
|---|---|---|
| List view query (standard hours) | 5,000 items | Error: "The attempted operation is prohibited because it exceeds the list view threshold." |
| List view query (maintenance window) | 20,000 items | Higher limit applies during SharePoint Online's scheduled off-peak maintenance windows |
| Lookup columns per query | 12 lookup columns | Query blocked; reduce lookup columns in the view definition |
| Maximum items in a single list or library | 30 million items | List becomes inaccessible; no new items can be added until items are deleted |
| REST API / CSOM single-request batch | 5,000 items per page | Must use pagination ($skiptoken) to retrieve result sets exceeding 5,000 items |
PnP PowerShell Get-PnPListItem without -PageSize |
5,000 items | Returns error on lists above 5,000 items; use -PageSize 500 parameter |
| Indexed columns per list | 20 indexed columns | Additional indexes cannot be created; views relying on unindexed columns hit the threshold |
| SharePoint admin centre bulk operations | Varies by operation | Some bulk admin actions are unavailable for libraries above 5,000 items; use the SharePoint REST API or a tool like ShareMaster instead |
Working Within the Threshold
Microsoft documents the following strategies for managing large lists in SharePoint Online, all confirmed to work in production:
- Index the columns used in view filters. Any column used as a filter condition in a view must be indexed for that view to work reliably when the library exceeds 5,000 items. Go to List Settings, then Indexed Columns, and add an index for each column your most-used views filter by. You have 20 index slots per list.
- Partition large libraries using folders or metadata. When a view is scoped to a folder, SharePoint evaluates the threshold against that folder's contents rather than the entire library. A library holding 50,000 files partitioned into folders of 4,000 files each supports standard views without threshold issues in each folder. Cross-folder views that span the full library still require indexed columns to avoid the threshold.
- Lead every filtered view with an indexed column. The first filter condition in a view must use an indexed column. Additional filter conditions on non-indexed columns are then applied after the indexed filter has already reduced the result set below 5,000 items.
- Use SharePoint search for reporting across large libraries. The SharePoint search REST API is not subject to the list view threshold. For export and reporting scenarios spanning libraries with tens of thousands of items, querying via search is a practical alternative to direct list queries.
- Reduce library size through archiving or bulk deletion. The most direct solution is to keep libraries below the threshold by removing content you no longer need. ShareMaster's Space Master includes bulk delete tools for files and items, and Report Master can generate a file-count-by-library export to help you identify which libraries are the best candidates for archiving or cleanup.
For a full reference of all SharePoint Online size and capacity limits, see the SharePoint Online limits reference.
To identify which libraries in your tenant are approaching the threshold, Report Master can export a storage and file-count report for every library in a site collection in a few minutes, without any scripting.
Try ShareMaster free for 14 days