I am using the following to filter a Gallery; there is also a Combo Box, Checkbox and DatePickers that can be added to the filter using the formula.
Without the checkbox the Gallery shows me ONLY items associated with the choice made in the Combo Box, as desired.
However, as configured, when I check the Checkbox and set the DatePickers the Gallery returns all items on the list that are within the search range rather than ONLY the items within the range that are associated with the content of the Combo Box.
If(ReviewScreenEventDateRangeCheckbox,
Filter(
'Test List',
DateOfEvent>DateAdd(ReviewScreenEventStartDatePicker.SelectedDate,-1,Days)
&&
DateOfEvent<DateAdd(ReviewScreenEventEndDatePicker.SelectedDate,1,Days)
),Sort(
Filter(
'Test List',
Len(ReviewScreenSearchComboBox.Selected.Value) = 0 ||
StartsWith(
Title,
ReviewScreenSearchComboBox.Selected.Value)
),
varSortGallery
))


Report
All responses (
Answers (