Hello,
i would like some help with a gallery filter.
i have this collection:
And this FIlter: Distinct(colAll, Term)
and here the gallery Items:
If( FilterTerm.Selected.Value = Blank(),
SortByColumns(
Search(
Filter(
colAll,
And(
StartDate >= DateAdd( Today(), - Weekday( Today(), StartOfWeek.Monday)-7, TimeUnit.Days),
StartDate <= DateAdd(Today(), 1 - Weekday( Today(), StartOfWeek.Monday ) + 240, TimeUnit.Days ),
Term = FilterTerm.Selected.Value
)
),
txtNameFilter.Text, "Description"
),
"StartDate"
),
SortByColumns(
Search(
Filter(
colAll,
And(
StartDate >= DateAdd( Today(), - Weekday( Today(), StartOfWeek.Monday)-7, TimeUnit.Days),
StartDate <= DateAdd(Today(), 1 - Weekday( Today(), StartOfWeek.Monday ) + 120, TimeUnit.Days ),
Term = FilterTerm.Selected.Value
)
),
txtNameFilter.Text, "Description"
),
"StartDate"
)
)
I want all rows visible when filters are not applied and that is not happening. Also the filter only works with a few items not all.
Any ideas? Thank you
