Fix Missing Library Files in a SharePoint Search Refiner
Question details
Find why a Deal ID search refiner returns only some files from a SharePoint library.

- 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.
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.
Verify Deal ID metadata and the search property mapping
Use this check when files with the same Deal ID produce inconsistent refiner results.
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.
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.
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.
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.

Compare search scope, permissions, and result behavior
Use this method to determine whether missing files are excluded by the query, access controls, or search result settings.
Escalate a persistent indexing issue to Microsoft Support
Use this option if the metadata, mapping, access, and search configuration checks do not explain the missing production results.
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.

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.




