web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter with DatePicker

Power Apps

Unanswered

Filter with DatePicker

(0) Share

Report

Report

Posted on by RJF61

1,265

I have the following gallery filter but am receiving a delegation error on the info in "blue". Also, the Filter is not providing the appropriate information. Any suggestions?

Filter(
[@MEWPInspection],
StartsWith(
MEWPWO,
tbSearchWO.Text
) && (CreatedByDN = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank()) && (Text(
Created,
DateTimeFormat.ShortDate
) = Text(
DatePicker1.SelectedDate,
DateTimeFormat.ShortDate
) || Text(
DatePicker1.SelectedDate,
DateTimeFormat.ShortDate
) = Blank())
)

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61

This would be the delegable version of the formula.

Filter( [@MEWPInspection], StartsWith( MEWPWO, tbSearchWO.Text ) && ( CreatedByDN = ComboBox1.Selected.Value || ComboBox1.Selected.Value = Blank() ) && ( Created = DatePicker1.SelectedDate || IsBlank(DatePicker1.SelectedDate) ) )

The reason why the formula doesn't return the expected rows could be due to delegation. The other reason is that your source Created column may contain values with a date and time component. Therefore, testing against DatePicker1.SelectedDate (ie, a date with a time of 00:00), may not return the records that you expect.

Join the conversation