Filter a gallery to show only dates within the previous ‘N’ number of weeks where N is a number specified by the app maker.
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 |
Code
Use this code in the Items property of a gallery.
With(
{
StartDate: Today() - (7 * 3), // change this number
EndDate: Today()
},
Filter(
'Calendar Dates',
CalendarDate > StartDate,
CalendarDate <= EndDate
)
)
Output
Gallery shows only rows with a date in the previous 3 weeks. Current date is 6/16/2021
| Title | CalendarDate |
| Thursday, May 27, 2021 | 5/27/2021 |
| Friday, May 28, 2021 | 5/28/2021 |
| Saturday, May 29, 2021 | 5/29/2021 |
| Sunday, May 30, 2021 | 5/30/2021 |
| Monday, May 31, 2021 | 5/31/2021 |
| Tuesday, June 1, 2021 | 6/1/2021 |
| Wednesday, June 2, 2021 | 6/2/2021 |
| Thursday, June 3, 2021 | 6/3/2021 |
| Friday, June 4, 2021 | 6/4/2021 |
| Saturday, June 5, 2021 | 6/5/2021 |
| Sunday, June 6, 2021 | 6/6/2021 |
| Monday, June 7, 2021 | 6/7/2021 |
| Tuesday, June 8, 2021 | 6/8/2021 |
| Wednesday, June 9, 2021 | 6/9/2021 |
| Thursday, June 10, 2021 | 6/10/2021 |
| Friday, June 11, 2021 | 6/11/2021 |
| Saturday, June 12, 2021 | 6/12/2021 |
| Sunday, June 13, 2021 | 6/13/2021 |
| Monday, June 14, 2021 | 6/14/2021 |
| Tuesday, June 15, 2021 | 6/15/2021 |
| Wednesday, June 16, 2021 | 6/16/2021 |