Hi,
I have a gallery for SP List records that I currently have either a field filter, text search or field filter with text search! To improve the filtering options I want to add some drop down lists on other fields that work in conjunction with existing filter/searches.
My current filter uses "All" so nothing is filtered (there is no "All" value in the list field) and the new drop downs will also have an "All" so not to filter. This is likely to be LOTS of if statement to get all possible combinations. Is there a simple way to exclude filter option if the selected item is "All"?
Existing gallery item.
If(
RiskFilterChoice.Selected.Value = "New",
Filter(
'Risk Register - Trial',
'Risk Status' = "Draft"
),
If(
RiskFilterChoice.Selected.Value = "All",
Filter(
'Risk Register - Trial',(RiskSearchBox.Text in 'Risk Title' Or RiskSearchBox.Text in 'Risk ID')
),
Filter(
'Risk Register - Trial',
(RiskSearchBox.Text in 'Risk Title' Or RiskSearchBox.Text in 'Risk ID') And 'Inherent Risk Rating' = RiskFilterChoice.Selected.Value)
)
)
Thanks
Neil
