Fix SharePoint Online Search for Number and Currency Columns
Question details
Find number and currency column values in SharePoint Online search results.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- A user searches for values stored in number or currency columns after configuring managed properties and reindexing a list or library.
- Observed behavior
- Search returns no results for the number or currency values.
Identify the affected list or library, column names, and a known value to test. You need permission to manage the search schema and list or library settings; some options may require a SharePoint administrator.
Map the columns to suitable managed properties and reindex
Use this approach to make the column values available for managed-property queries.
SharePoint search uses crawled properties to collect column values and managed properties to make them available to queries. A value that can be queried through a managed property will not necessarily appear in a plain keyword search.
In SharePoint Online, newly created managed properties are limited to Text or Yes/No types. For numeric queries, use an appropriate existing queryable numeric managed property, such as an available RefinableInt or RefinableDecimal property.
Open the affected list or library, select Settings, and open List settings or Library settings. Under Advanced settings, confirm that items are allowed to appear in search results.
Open Site settings > Search schema, or ask a SharePoint administrator to open the search schema in the SharePoint admin center. Search Crawled Properties for the number and currency column names.
In Search schema > Managed Properties, select an appropriate unused queryable numeric property and add the matching crawled property under Mappings to crawled properties. Use separate suitable mappings for the number and currency columns, and save your changes.
Return to List settings or Library settings > Advanced settings and select Reindex list or Reindex document library. Allow time for SharePoint to crawl the content and update the index.
In the SharePoint search box, test a known value using a query such as ManagedPropertyName=123, replacing the property name and value with your own. Test the number and currency mappings separately.

Test a Title mapping for keyword search
Consider this administrator-managed workaround if a number value still does not appear in ordinary keyword searches.
Work with Office files using WPS Office
WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations. Its familiar interface and Office format compatibility make it easy to move existing files into your workflow. It does not change SharePoint search indexing or schema settings.

Frequently Asked Questions
Why doesn't a plain keyword search find my numeric value?
A numeric value may be available through a queryable managed property without being included in the full-text index. Try a property query such as ManagedPropertyName=123 after confirming the mapping and allowing time for indexing.
How do I reindex a SharePoint list or library?
Open List settings or Library settings > Advanced settings, then select Reindex list or Reindex document library. SharePoint updates the search index during a later crawl.
Can I create a new numeric managed property in SharePoint Online?
New managed properties in SharePoint Online are limited to Text or Yes/No types. For numeric queries, check for an appropriate existing queryable property, such as an available RefinableInt or RefinableDecimal property.
Why can one user find an item while another cannot?
SharePoint search respects item permissions. Check the affected user's access to the list or library and the specific item before troubleshooting the search schema.
Will mapping the number column to Title also fix currency searches?
It helped in one reported case, but it is not a reliable guarantee. Test the currency value separately and check its own crawled-property mapping if it remains missing.




