Others

Fix a SharePoint Online Lookup Column Over the 5,000-Item Threshold

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

The user needs to make a SharePoint Online lookup column usable when its source list exceeds 5,000 items.

Fix a SharePoint Online Lookup Column Over the 5,000-Item Threshold
Product
SharePoint Online
Device & OS
not provided
Scenario
A lookup column references a source list that has grown beyond the List View Threshold.
Observed behavior
The lookup column or related queries may fail, and indexed columns and filtered views do not resolve every lookup limitation.
Before you start

Identify the lookup column, its source list, and the views or actions that fail. Check whether the relevant filter columns are indexed and whether you have permission to change list settings.

Solution 1Recommended

Use indexed columns and selective filters in affected views

Try this when a view or query involving the lookup is failing; it can reduce the items SharePoint needs to process.

The 5,000-item List View Threshold limits certain operations, not the total number of items a list can store. Indexed filters can help with queries but do not remove every lookup limitation.

1
Find the filter columns

Open the affected list, select the view menu, and choose Edit current view. Identify a column that can narrow the results, such as a period or business area.

2
Create an index

Open Settings > List settings > Indexed columns, select Create a new index, and choose the relevant filter column. Index creation on a large list may itself be subject to limitations.

3
Filter the view

Return to Edit current view, add a selective filter using the indexed column, and save the view. Test the view and the lookup action that previously failed.

Use indexed columns and selective filters in affected views
Indexing has limits: A filtered view may improve a query without fixing the lookup picker or other lookup operations. If the lookup still fails, consider splitting the source data.
Free Microsoft Office alternative

Review exported SharePoint list data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for reviewing exported list data. It supports common Microsoft Office formats for easier migration, but it does not change SharePoint lookup thresholds or replace live lookup relationships.

Review and filter exported list data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

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

Yes. The List View Threshold applies to certain operations and queries; it is not a 5,000-item storage limit for the list.

Can I turn off the lookup threshold in SharePoint Online?

SharePoint Online does not provide a reliable setting to disable this limitation. Use selective indexed filters where applicable, or consider smaller source lists.

Why does my lookup still fail after I index a column?

An index can help SharePoint process a selective view or query, but it does not remove every lookup limitation. Test the specific lookup action, then consider splitting the source list if it still fails.

Will splitting the source list preserve existing lookup values?

Not automatically. Before replacing the old lookup column, plan how to map existing items to the new source lists and migrate their relationships.