I have been trying to solve this for a few hours but my knowledge is not enough to crack this.
I have a sharepoint list and display it in a Gallery.
I have a Search box, 2 slider and 3 drop downs to filter the Gallery. So far this works fine and as desired.
Filter('Inlay Selector',
DropdownVendor.Selected.Value = Vendor.Value,
DropdownIC.Selected.Value = 'IC Vendor'.Value,
DropdownICFamily.Selected.Value = 'IC Family'.Value,
Slider1.Value >= 'Antenna Width mm',
Slider1_1.Value >= 'Antenna Height mm',
SearchBox.Text in 'Vendor Product Code' Or SearchBox.Text in 'Antenna Width mm')
Now I would like to use 3 toggle, so certain filter criteria won't be applied; my intention is to allow the user to disable each of the Dropdowns, so results are not filtered.
Filter('Inlay Selector',
If(Toggle2.Value,DropdownVendor.Selected.Value = Vendor.Value),
If(Toggle2_2.Value,DropdownIC.Selected.Value = 'IC Vendor'.Value),
If(Toggle2_1.Value,DropdownICFamily.Selected.Value = 'IC Family'.Value),
Slider1.Value >= 'Antenna Width mm',
Slider1_1.Value >= 'Antenna Height mm',
SearchBox.Text in 'Vendor Product Code' Or SearchBox.Text in 'Antenna Width mm')
Is there a good way to do this? What I created doesn't work. If I toggle any of the three toggles off, the gallery is empty.
