SharePoint Document Issues

Fix SharePoint Online Search for Number and Currency Columns

Bushra ParveenBushra Parveen Nov 18, 2026 869 views

Question details

Find number and currency column values in SharePoint Online search results.

Fix SharePoint Online Search for Number and Currency Columns
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.
Before you start

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.

Solution 1Recommended

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.

1
Check search visibility

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.

2
Find the crawled properties

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.

3
Configure managed-property mappings

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.

4
Reindex the content

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.

5
Test a property query

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.

Map the columns to suitable managed properties and reindex
Allow time for indexing: Reindexing requests a fresh crawl; it does not update results immediately. If results are still missing after indexing, verify the mapping, the property type, the query syntax, and the searcher's access to the item.
Free Microsoft Office alternative

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.

Open and edit spreadsheets containing number and currency valuesCompatible with Microsoft Office formats, including XLSX, DOCX, and PPTXUse familiar document, spreadsheet, and presentation toolsMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

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.