How to Search Between Minimum and Maximum Values in SharePoint Online
Question details
The user needs to locate SharePoint Online list or library items whose numeric value falls between a minimum and maximum, and wants to know if Power Apps can provide an easier range-search solution.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- The user manages documents or items in SharePoint Online and needs to filter or search by a numeric range, such as an identifier between two values.
- Observed behavior
- SharePoint Online search does not provide a direct built-in range search for arbitrary numeric values; Power Apps-based range search requires a separate Microsoft Power Apps solution.
Check whether the target SharePoint column is a number, currency, or date column. If you plan to use search, verify that the column or managed property is indexed and allow time for SharePoint Online to finish crawling.
Filter a SharePoint list or library by a numeric range
Use the built-in column filter in a SharePoint Online list or document library when the values are stored in a number, currency, or date column and you need to see only items between two values.
SharePoint list and library views provide a direct Between filter for numeric and date columns. This is the fastest way to isolate records between a minimum and maximum without using SharePoint search or Power Apps.
In SharePoint Online, go to the site and select the target list or document library from the left navigation or from Site contents.
Click the filter arrow next to the numeric column header, select Filter by, and then choose Between.
Type the lower value in the first box and the upper value in the second box, then apply the filter.
Use the view selector to create or save a view so you can reuse the same range filter later.
Use KQL to refine SharePoint search results with a range query
Use this approach when your numeric field is mapped to an eligible searchable managed property and you need range filtering from the SharePoint search box.
Explore Power Apps for a custom range search
Use this option when you want a custom app or form where users can enter minimum and maximum values and filter SharePoint data dynamically.
Use WPS Office as a Free Microsoft Office Alternative for SharePoint Document Tasks
WPS Office is a free, lightweight Office suite that opens and edits Word, Excel, and PowerPoint files downloaded from SharePoint Online. It offers a familiar ribbon interface and Microsoft Office format compatibility, so you can keep working on SharePoint documents without changing your workflow.
- 1. Download WPS Office Free: Go to the official WPS Office download page, select your operating system, and run the installer.
- 2. Open a SharePoint document: Download the file from SharePoint Online, right-click the file, choose Open with, and select WPS Office Writer, Spreadsheet, or Presentation.
- 3. Save in a Microsoft-compatible format: After editing, save the file as .docx, .xlsx, or .pptx to keep it compatible with SharePoint Online and Microsoft Office.
Frequently Asked Questions
Can I search SharePoint Online for a value between two numbers directly from the search box?
SharePoint search does not provide a general built-in range search for every column. You can use the list column filter on numeric or date columns, or use KQL range syntax if the field is mapped to an eligible managed property.
Which SharePoint column types support a Between filter for minimum and maximum values?
Number, currency, and date/time columns support the Between filter in SharePoint list and library views. Text columns do not work reliably for numeric range filtering.
Can Power Apps create an easier range search against SharePoint data?
Yes. A Power Apps screen can connect to a SharePoint list and use Filter or LookUp with conditions such as Value >= MinInput and Value <= MaxInput. For detailed app-building help, post in the Microsoft Power Apps Community.
Does WPS Office add a range search feature to SharePoint Online?
No. WPS Office is a desktop and mobile Office alternative; it does not change SharePoint Online search behavior. It can open, edit, and save SharePoint documents in Microsoft-compatible formats.
