Power Apps Filter Gallery With Two DatePickers

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-filter-a-gallery-by-date-range-examples/power-apps-filter-gallery-with-two-datepickers/. Author: Matthew Devaney.

Power Apps Filter Gallery With Two DatePickers

Filter a gallery to show only dates between the selected start date and end date in two datepickers. Input

Calendar Dates is a SharePoint list with consecutive days starting 1/1/2018 and ending 12/31/2024 (2,557 rows) Title CalendarDate Monday, January 1, 2018 1/1/2018 Tuesday, January 2, 2018 1/2/2018 Wednesday, January 3, 2018 1/3/2018 Thursday, January 4, 2018 1/4/2018 Friday, January 5, 2018 1/5/2018 … … Tuesday, December 31, 2024 12/31/2024 Screen

Create two datepickers in a canvas app called dte_StartDate and dte_EndDate . Code Filter(

'Calendar Dates' , CalendarDate >= dte_StartDate.SelectedDate, CalendarDate <= dte_EndDate.SelectedDate ) Code language: JavaScript ( javascript ) Output

Gallery shows only rows between selected dates between the start date and end date in the two datepickers. Current date is 6/16/2021 Title CalendarDate Wednesday, June 16, 2021 6/16/2021 Thursday, June 17, 2021 6/17/2021 Friday, June 18, 2021 6/18/2021 Saturday, June 19, 2021 6/19/2021 Sunday, June 20, 2021 6/20/2021