Dear All,
I want to create a filter on a gallery which will filter on the following;
Drop Down Selection - Status when selected - Status Column
If "All" is selected from drop down do not filter / status column
If text is entered in a box filter form details with start with
If nothing select just present all data
I cannot seem to get it working properly, code below.
Filter(
'SharePoint List',
varReset,
And(
If(
searchStatus.SelectedText.Value = "All", true,
// If "All" is selected, do not filter on status.
Status.Value = searchStatus.SelectedText.Value // Only filter by status if specific status is selected
),
StartsWith(FormColumn, searchForm.Text)
)
)
