You’re offline. This is a read only version of the page.
Announcements
16
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)'))
Hi @AhmadZairin ,
Maybe something like this
Share
Report
All responses (
Answers (
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.
