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
)
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 |