Fix SharePoint Online List Search Above the 5,000-Item Threshold
Question details
The user needs to find items in a SharePoint Online list that contains more than 5,000 entries.

- 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.
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.
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.
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.
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.
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.

Escalate persistent search issues to Microsoft support
Use this option if indexed filtering and reindexing do not resolve the problem.
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.

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.




