Power Platform Community Forum Thread Details

Hello

I am trying to expand on my gallery filtering to now include date picker options as well as my Drop down to sort by Status but not having any luck

This is what i am using everything works fine before the 2nd IF(startDate.SelectedDate I want the user to be able to select a range of dates to show items if the status and modified date are between the 2 date pickers.

SortByColumns(
Filter(
ServiceRequest,
Department=Office365Users.MyProfile().Department,
IsBlank(StatusSelector.Selected.Result)=true Or Status.Value= StatusSelector.Selected.Result
,If(StartDate.SelectedDate)= "Modified" || "Modified" = EndDate.SelectedDate),
"{Identifier}",
Ascending
)

Categories:

Building Power Apps

Hi @Nix23,

Based on the formula you provided, I think there is something wrong with it. I have made a test on my side, please consider take a try with the following workaround:

1. Remove the Today() function from the DefaultDate property of the StartDatePicker and EndDatePicker control.

2. Set the Items property of your Gallery to following:

SortByColumns(
 Filter(
 ServiceRequest,
 Department = Office365Users.MyProfile().Department,
 If(IsBlank(StatusSelector.Selected.Result), true, Status.Value = StatusSelector.Selected.Result),
 If(
 !IsBlank(StartDate.SelectedDate) && !IsBlank(EndDate.SelectedDate),
 Value(Text(Modified, "yyyymmdd")) >= Value(Text(StartDate.SelectedDate, "yyyymmdd")) && Value(Text(Modified, "yyyymmdd")) <= Value(Text(EndDate.SelectedDate, "yyyymmdd")),
 true
 )
 ),
 "{Identifier}",
 Ascending
)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,