How to Search a SharePoint Lookup Column with More Than 5,000 Items
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.

- 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.
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.
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.
In SharePoint, navigate to the source list that the lookup column references, and select Settings > List settings.
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.
Click OK or Save to store the new filtered view.
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.
Create or edit an item and open the lookup dropdown to confirm that only the filtered subset appears.

Scroll and Select a Value from the Large Lookup Dropdown
Use this when you cannot change the SharePoint list or column settings and need to finish data entry immediately.
Create a Power Apps Custom Form with a Searchable Combo Box
Use this if your organization uses Microsoft Power Apps and you need a long-term form with keyword search against large lookup data.
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.

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.




