From your question, what I understand is: you’re storing MIN_THICKNESS and MAX_THICKNESS in SharePoint, and you want the user to select a single thickness value and return all records where that value falls between Min and Max (even if only one of them is filled).
Important Note (Delegation)
With SharePoint, this type of logic (range filter with optional Min/Max) is not fully delegable, because:
- IsBlank() on columns is not delegable
- OR (||) conditions are not delegable
This means that for large lists, Power Apps may only evaluate the first 500–2000 records.
Practical Solution (Works in most cases)
Filter(
YourSharePointList,
(IsBlank(MIN_THICKNESS) || MIN_THICKNESS <= Value(ComboBox1.Selected.Value)) &&
(IsBlank(MAX_THICKNESS) || MAX_THICKNESS >= Value(ComboBox1.Selected.Value))
)
If only MIN is filled → checks value ≥ MIN
If only MAX is filled → checks value ≤ MAX
If both are filled → checks value is between MIN and MAX
If your list is large
For larger datasets, consider:
Applying additional filters / indexed columns
Redesigning data (e.g., storing precomputed logic)
Using a more delegable data source (Dataverse / SQL)
Optional Improvement
You can improve readability by storing the selected value in a variable:
UpdateContext({ varThickness: Value(ComboBox1.Selected.Value) })
Then use:
Filter(
YourSharePointList,
(IsBlank(MIN_THICKNESS) || MIN_THICKNESS <= varThickness) &&
(IsBlank(MAX_THICKNESS) || MAX_THICKNESS >= varThickness)
)
Summary
Your design (MIN + MAX columns) is correct
Use a range filter (>= MIN && <= MAX)
Be aware of delegation limits with SharePoint
✅ If one of the responses here solved your issue, please mark it as Accepted so others facing the same problem can benefit as well.
👍 If this or any other reply here helped you, feel free to give it a Like. It helps others and is always appreciated.
