SharePoint Document Issues

Work Around the SharePoint 5,000-Item List View Threshold

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

Find a way to query and manage a SharePoint list with approximately 500,000 records without triggering list view threshold errors.

Work Around the SharePoint 5,000-Item List View Threshold
Product
SharePoint lists
Device & OS
not provided
Scenario
A large list is accessed through views, lookups, filters, REST, JSOM, and CSOM.
Observed behavior
List operations produce threshold errors when they attempt to process too many items.
Before you start

Confirm whether the list is in SharePoint Online or SharePoint Server, and identify the columns and queries that cause errors. Check how many items match each proposed filter before relying on it to narrow a query.

Solution 1Recommended

Use indexed columns and selective filters

Use this approach to make views and queries target a small subset of a large list.

The list can contain more than 5,000 items, but an operation can be throttled if SharePoint must process too many items to produce its result. Returning fewer than 5,000 items alone does not guarantee that a query will succeed.

In SharePoint Online, administrators cannot raise the List View Threshold. Creating an index on an already large list may itself be limited or take time, so check whether the index is available before relying on it.

1
Identify a selective column

Open the list and choose a column, such as a status or category, whose filter value matches a small portion of the records. Avoid relying on a value that matches most of the list.

2
Create an index

Open Settings > List settings > Indexed columns, select Create a new index, and choose the column. If index creation is unavailable or fails, check the list's indexing limits and consider partitioning the data.

3
Filter the view

Open the list view menu, select Edit current view, and add a filter on the indexed column. Save the view and test whether it opens without a threshold error.

4
Revise and test queries

Update REST, JSOM, or CSOM queries to filter on the indexed column, then test each query with representative data. Use pagination where appropriate, but do not rely on a page size or REST $top value alone to bypass throttling.

Use indexed columns and selective filters
Lookup limits are separate: Views and queries that use many lookup, person, or similar columns can also encounter lookup-related limits. Reduce the number of such columns in the operation if lookup errors persist.
Free Microsoft Office alternative

Work with SharePoint-related spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with compatible documents and spreadsheets. It can help you migrate everyday file work, but it does not change SharePoint list thresholds or fix SharePoint queries.

Review and organize exported list data in WPS SpreadsheetsCompatible with Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX filesFamiliar interface makes everyday Office tasks easy to learnFree, lightweight tools support a smoother move from Microsoft Office files
microsoft office alternative - wps office

Frequently Asked Questions

Do I have to reduce the entire list to fewer than 5,000 items?

No. A SharePoint list can contain more than 5,000 items. Instead, design views and queries to process a selective subset, typically using indexed columns and filters.

Can I increase the threshold in SharePoint Online?

No. SharePoint Online administrators cannot raise the List View Threshold. Use selective indexed queries, partition the data, or consider another data platform.

Why does a query fail when it returns fewer than 5,000 items?

SharePoint may need to process more than 5,000 items to find those results. Check the indexed columns and filters used by the view or query; a small result set or page size alone does not guarantee success.

Where can I add an index to a SharePoint list?

Open the list, go to Settings > List settings > Indexed columns, and select Create a new index. On a large existing list, index creation may be limited or take time.

Will folders automatically prevent threshold errors?

No. A view or query must be scoped to an appropriate folder and may still need selective indexed filters. Test the folder-scoped operation with the actual data.