SharePoint Document Issues

How to Fix SharePoint Search Not Returning All Results

Algirdas Jasaitis Oct 23, 2026 868 views

Question details

The SharePoint search bar fails to find every list item for a searched number, despite the missing items being visible when filtering columns directly.

How to Fix SharePoint Search Not Returning All Results

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: A user is searching for specific records (such as a revision number) using the list's search bar but receives incomplete results.
Observed behavior: Certain items are missing from the search results. However, when filtering the specific column (e.g., Rev_Number) manually, the missing items (like revision 13437) are visible in the list.

Before you start

Ensure you have list owner or site admin permissions, as troubleshooting crawled properties and list-level search configurations requires elevated access.

Solution 1Recommended

Verify Indexing Status and Check for Duplicate Identifiers

SharePoint search relies on an index that may experience delays or collapse duplicate entries into a single result.

Unlike column filters which query the list data in real-time, the search bar relies on the SharePoint search index. If items were recently added or modified, they may simply be pending an index crawl.

Wait for the search crawl

Allow up to 24 hours for SharePoint Online's continuous crawl to index newly added or modified list items.

Check for duplicate values

Sort your list by the identifiers you are searching for (e.g., SO Number and SO Line). If multiple items have identical values, SharePoint search might group them or only display the first item created.

Test in a different view

Click the gear icon in the top right, select 'List Settings', and ensure you are testing the search in the Modern experience, or toggle to Classic experience to see if search behavior differs.

Verify Indexing Status and Check for Duplicate Identifiers

Search Grouping Behavior: When SharePoint detects duplicate key values across list items, the search topology may trim duplicates to save space, resulting in 'missing' items in your query results.

Solution 2

Inspect List Search Configurations and Managed Properties

Ensure the list is configured to allow search and that the specific column is properly mapped in the search schema.

Solution 3

Copy Data to a New List via Power Automate

If the original list's search index is permanently corrupted or improperly configured by a past administrator, migrating the data to a fresh list acts as a reliable workaround.

Free Microsoft Office alternative

Enhance Your Document Workflow with WPS Office

While SharePoint manages your team's lists and intranets, editing downloaded documents shouldn't require an expensive software subscription. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your document, spreadsheet, and presentation needs.

1. Download your file: Select the document in your SharePoint document library and click Download to save it to your local device.
2. Open with WPS Office: Launch WPS Office, click on 'Open', and select your downloaded file. The formatting will be perfectly preserved.
3. Edit and save: Make your necessary edits and save the file in its original Microsoft format before uploading it back to SharePoint.

Fully compatible with standard Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight application that loads quickly and runs smoothly on older devicesFamiliar tabbed user interface makes transitioning from Microsoft Office seamlessBuilt-in robust PDF editing tools for comprehensive document management

microsoft office alternative - wps office

Frequently Asked Questions

Why does filtering a SharePoint list show items that search misses?

Filtering queries the list data directly in real-time, whereas the search bar relies on the SharePoint search index. If an item hasn't been crawled yet, or if there is an indexing error, the search bar won't find it, even though the data exists.

Can duplicate column values affect SharePoint search results?

Yes. If multiple list items share identical values in key identifier columns, the SharePoint search topology might group them together to remove duplicates, resulting in only the oldest created item being displayed in the search results.

How long does it take for SharePoint to index a new list item?

In SharePoint Online, the continuous crawl process typically indexes new or modified items within 15 minutes to an hour. However, service delays or heavy tenant loads can occasionally extend this timeframe up to 24 hours.

What is a managed property in SharePoint search?

A managed property is a configuration in the SharePoint Search Schema that maps internal 'crawled properties' (like a specific list column) to a standardized property. This allows users to search, filter, and sort by that specific data point.

Document & File Issues