web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Unable to filter a Sha...

Power Apps

Answered

Unable to filter a SharePoint list's Created date based on a Date Picker

(0) Share

Report

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have this formula inside the Gallery items property to filter a SharePoint list using a date picker:-

(Filter('Work Orders',
(Created = colSelectedDate Or IsBlank(colSelectedDate))

and when the user click on the Search button, i am assigning this value to the local variable:-

UpdateContext({colSelectedDate: DashBoardDatePicker.SelectedDate});

but the filter will not return any result. i have these setting for the Date Picker i am using for the search & filter:-

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Created is both a date and a time. To filter on that you need to use >= and <= to specify the time range. = won't work because the time component won't match.

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report
@Pstork1 But how I can define the date rang this did not work:-

SortByColumns(Filter('Work Orders', ((Created >= colSelectedDate And Created <= colSelectedDate) Or IsBlank(colSelectedDate))

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

You need to use the DataAdd() function to add or subtract 1 day from colSelectedDate for one of the evaluations.

Was this reply helpful? Yes No

Join the conversation