Unanswered

Filter only working with early values when an If statement is embedded

(0) Share

Report

Posted on by esutherland

So I'm trying to filter the items in a gallery but for some reason the early entries only show up when I have an If statement in it?

Filter(
 DESK_BOOKINGS,
 BookingDate = DatePicker1.SelectedDate
)

doesn't return early entries but

Filter(
 DESK_BOOKINGS,
 If(
 IsBlank(DatePicker1) = false,
 BookingDate = DatePicker1.SelectedDate,
 BookingDate = DatePicker1.SelectedDate
 )
)

this code does. it's the same whether the If statement goes through the true or else statements

Ultimately I'm going to use a collection instead of pulling direct from the sharepoint list which shouldn't have this issue but I'm just very confused why the second code works while the first doesn't when they basically do the same thing

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @esutherland

try to use:

Filter( DESK_BOOKINGS, IsBlank(DatePicker1.SelectedDate) || IsEmpty(DatePicker1.SelectedDate) || BookingDate = DatePicker1.SelectedDate )

That will help manage Blank or Empty state of picker and show all records if there is nothing Picked also
keep in mind Date picker as Default is set up to Today() means if you don't have any records with Today date there is nothing to show.

To change this, go to Properties and change Default property of Date Picker replace Today() with IsBlank()

You can change this to IsBlank() means as default there is nothing picked in the Date picker what should help to show all records

Was this reply helpful? Yes No
esutherland 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Nah that code still doesn't include the early entries when I try it, I think you've misunderstood the issue: the datepicker is irrelevant, I'm just pulling a list of values from that date and the datepicker aspect of it works perfectly fine even if it's set to default. It's just that the filter is excluding early entries from my list with the same date (shows ID 240 on 8/12 but not ID 135 on 8/12). For some reason it's fixed when I add an If statement. I have no idea why

Was this reply helpful? Yes No