SharePoint Document Issues

Fix SharePoint Online List Search Above the 5,000-Item Threshold

Huda QurayshiHuda Qurayshi Nov 13, 2026 869 views

Question details

The user needs to find items in a SharePoint Online list that contains more than 5,000 entries.

Fix SharePoint Online List Search Above the 5,000-Item Threshold
Product
SharePoint Online
Device & OS
not provided
Scenario
Filtering or searching a large SharePoint list, including lists with indexed columns.
Observed behavior
Filters may return results only from the first 5,000 items, while the list search box may report no matching items.
Before you start

Identify an item that is missing from the results and note its column values, the search terms, and the affected list view. Check that you have permission to manage list settings; a Microsoft 365 admin may be needed to open a support request.

Solution 1Recommended

Check indexed filters and request list reindexing

Use this approach to make the list view more selective and refresh the list's search index.

The 5,000-item list view threshold limits how many items a query can process; it is not a limit on the total number of items a list can store. An indexed column alone does not guarantee that every filtered query will stay below the threshold.

1
Review indexed columns

Open the affected list, select Settings > List settings, and choose Indexed columns. Check whether the column used by the view's main filter is indexed; create an index if needed and available.

2
Make the view filter selective

Open the affected view and select Edit current view. Under Filter, use an indexed column to narrow the initial result set to fewer than 5,000 items, then save the view and test it with a known item.

3
Request reindexing

In Settings > List settings > Advanced settings, select Reindex List and confirm. Allow time for the next search crawl, then use the list search box to test the known item again.

Check indexed filters and request list reindexing
Reindexing is not immediate: Requesting reindexing schedules the list for a future crawl; it does not guarantee an immediate search result or resolve every threshold issue.
Free Microsoft Office alternative

Review SharePoint list data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for an easy move between apps. Export list data to Excel when available and review it in WPS Spreadsheets; WPS does not repair SharePoint search or its list view threshold.

Review and filter exported list data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Can a SharePoint list contain more than 5,000 items?

Yes. The 5,000-item list view threshold concerns how many items a query can process, not the total number of items the list can store.

Why doesn't indexing a column always fix the threshold error?

A query can still process too many items if its filter is not selective enough. In Edit current view, use an indexed column to narrow the initial result set to fewer than 5,000 items.

Where can I request reindexing for a SharePoint list?

Open the list and go to Settings > List settings > Advanced settings, then select Reindex List. The request is processed during a later search crawl.

What should I do if list search still finds no matching items?

Ask a Microsoft 365 admin to open a request through Support > Help & support at https://admin.microsoft.com/. Include a known missing item, the search terms, and the troubleshooting steps already tried.