Fix a SharePoint Online Lookup Column Over the 5,000-Item Threshold
Question details
The user needs to make a SharePoint Online lookup column usable when its source list exceeds 5,000 items.

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

Split the lookup source into smaller lists
Use separate source lists when indexed filters do not resolve the lookup limitation.
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.

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.




