Numerical Filter Lower than Some Value for Gallery

(0) Share

Report

Posted on by AhmadZairin

Hello ,
I have 1 question
Is it possible to filter in the text input for the gallery in numerical ? such as mentioned below

The idea is rather simple, to suggest materials based on those characteristics that are already in Excel.
But i do not only want it to suggest 1 material. Let say for example I keyed in 30 all the value which are higher than the value in the 'OPERATING TEMP(C)' will be susceptible. If i keyed in number 63(which is not there) , i want every number in 'OPERATING TEMP(C)' that is higher than 63 showed in the gallery.
Here is my code in the Gallery
:

Sort

( Filter

(Mastercopy,
SYSTEM=DropdownSystem_2.Selected.Result && 'Sub System'=DropdownSubsystem_2.Selected.Result &&'EQUIPMENT TYPE'=DropdownEquipmentType_2.Selected.Result && COMPONENT=DropdownComponent_2.Selected.Result &&

FilterBox.Text in 'OPERATING TEMP (°C)'),

Value('OPERATING TEMP (°C)'))

Help3.0.png Help3.1.png Help3.2.png Help3.3.png Help3.4.png

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AhmadZairin ,
Maybe something like this
Sort( Filter( Mastercopy, SYSTEM=DropdownSystem_2.Selected.Result && 'Sub System'=DropdownSubsystem_2.Selected.Result && 'EQUIPMENT TYPE'=DropdownEquipmentType_2.Selected.Result && COMPONENT=DropdownComponent_2.Selected.Result && Value('OPERATING TEMP (°C)') > Value(FilterBox.Text) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No