SharePoint Document Issues

How to Search a SharePoint Lookup Column with More Than 5,000 Items

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

Question details

The user needs to quickly find a value in a SharePoint lookup column linked to a list with more than 5,000 records because the dropdown shows no search option.

How to Search a SharePoint Lookup Column with More Than 5,000 Items
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
A user is editing or creating a SharePoint item and must select a value from a large lookup column.
Observed behavior
The lookup dropdown displays a long list without a search box, making it time-consuming to locate a record.
Before you start

Confirm you have permission to edit the SharePoint list or column settings and identify the source list that feeds the lookup column. If you cannot change column settings, use the built-in dropdown scroll workaround instead.

Solution 1Recommended

Narrow the Source List with a Filtered View and Apply It to the Lookup Column

Use this when you can modify the source list: a filtered view reduces unrelated values and makes the lookup selection shorter in SharePoint list forms.

This method does not add a search box, but it can significantly reduce the number of options if your target record belongs to a predictable subset.

1
Open the source SharePoint list

In SharePoint, navigate to the source list that the lookup column references, and select Settings > List settings.

2
Create a filtered view

Under Views, select Create view, choose Standard View, enter a name, and apply filters such as Status is equal to Active or Created is greater than [Today]-30.

3
Save the view

Click OK or Save to store the new filtered view.

4
Assign the view to the lookup column

Open the destination list settings, select the lookup column, and set the lookup source view to the new filtered view if your SharePoint version exposes that option.

5
Test the form

Create or edit an item and open the lookup dropdown to confirm that only the filtered subset appears.

Narrow the Source List with a Filtered View and Apply It to the Lookup Column
No built-in search box: SharePoint does not currently provide a lookup search box for lists over 5,000 items. This workaround only shortens the list; it does not enable searching within the dropdown.
Free Microsoft Office alternative

Open and Edit SharePoint Files in a Free, Lightweight Office Suite

WPS Office is a free, lightweight alternative for working with Office documents, including files stored or shared through SharePoint workflows. It preserves familiar formatting and supports Microsoft Word, Excel, and PowerPoint file types, so you can open .docx, .xlsx, and .pptx files without an extra subscription.

Opens and edits common SharePoint document formats including .docx, .xlsx, and .pptxFree lightweight suite with a familiar ribbon-style interfaceKeeps formatting and formulas intact when switching from Microsoft OfficeAvailable across Windows, macOS, Android, and iOS for flexible workNo paid Office subscription needed for daily document tasks
QA img-9

Frequently Asked Questions

Why doesn't my SharePoint lookup column show a search box when the source list exceeds 5,000 items?

SharePoint does not currently include a search box for lookup columns that reference large lists. The lookup dropdown shows available values, and the only built-in option is to scroll through the list until Microsoft changes this behavior.

Can I reduce the number of values in a SharePoint lookup dropdown?

Yes, if you have permission to modify the source list. Create a filtered view on the source list and, where available, assign that view to the lookup column. This does not add search, but it can shorten the shown values.

Does WPS Office fix the SharePoint lookup column search problem?

No, WPS Office cannot change SharePoint's lookup column behavior because the limitation is in Microsoft SharePoint. WPS Office can still open, edit, and save the Office files you work with in SharePoint-compatible workflows.

How can I request Microsoft to add search to large SharePoint lookup columns?

Find the related SharePoint feedback request in your Microsoft 365 or SharePoint feedback portal and vote for it. Sign in with your Microsoft account and add a comment describing your large-list lookup scenario.

Which Office formats can WPS Office open from SharePoint?

WPS Office supports common Microsoft Office formats, including .docx, .xlsx, and .pptx, so you can download or sync SharePoint files and continue working on them without losing formatting.