SharePoint Document Issues

Fix Missing Library Files in a SharePoint Search Refiner

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

Find why a Deal ID search refiner returns only some files from a SharePoint library.

Fix Missing Library Files in a SharePoint Search Refiner
Product
Microsoft SharePoint Search
Device & OS
not provided
Scenario
A production search refiner uses RefinableString02, mapped to the crawled property ows_txtDealID, to filter library files by Deal ID.
Observed behavior
Some files are consistently omitted for particular Deal IDs despite reindexing, re-uploading, and confirming that the files are not checked out.
Before you start

Choose a Deal ID with missing results and collect the URLs of both returned and missing files. Use an account with permission to inspect library metadata and search settings, or ask a SharePoint administrator for help.

Solution 1Recommended

Verify Deal ID metadata and the search property mapping

Use this check when files with the same Deal ID produce inconsistent refiner results.

1
Compare file metadata

Open the library, select each example file, and view its details or properties. Confirm that the Deal ID is populated and matches the expected value, including spacing and spelling.

2
Inspect the managed property

In the SharePoint search schema, find RefinableString02 and verify that it is mapped to ows_txtDealID and configured for the search and refinement behavior you need. An administrator may need to check both site collection and tenant-level settings.

3
Check the refiner configuration

Edit the search refiner web part and confirm that it uses RefinableString02. Review any configured display or result limits that could hide values or results.

4
Reindex after changes

If you correct metadata or the mapping, open the library's settings and use Advanced settings > Reindex Document Library. Allow time for crawling and indexing before testing the Deal ID again.

Verify Deal ID metadata and the search property mapping
Indexing is not immediate: A mapping change does not instantly update existing search results. Reindex the affected library after the change and allow time for the search index to refresh.
Free Microsoft Office alternative

Work with Office documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files, making it easier to move everyday document work between suites. It does not repair SharePoint search indexing or refiners.

Open and edit documents from your SharePoint library after downloading themCompatible with Microsoft Office formats including DOCX, XLSX, and PPTXFamiliar editing tools for an easier transition from Microsoft OfficeFree, lightweight software for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why are files missing only when I use the Deal ID refiner?

Compare the files' Deal ID values in the library's details pane, then check that RefinableString02 is mapped to ows_txtDealID in the search schema. Also inspect the refiner web part's configuration and limits.

How do I reindex the affected library?

Open the library settings, select Advanced settings, and choose Reindex Document Library. Allow time for SharePoint to crawl and update the search index before retesting.

Can permissions affect SharePoint search results?

Yes. Search results are security-trimmed. Open a missing file's URL with the searching account and check file and folder permissions; also check approval status if content approval is enabled.

What should I provide to Microsoft Support?

Include example missing and returned file URLs, Deal IDs, the search query and refiner settings, the managed-to-crawled-property mapping, and the results of your reindexing and permissions checks.