Power Apps Filter Gallery By Dates In Previous 'N' Months

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-by-dates-in-previous-n-months/. Author: Matthew Devaney.

Power Apps Filter Gallery By Dates In Previous ‘N’ Months

Filter a gallery to show only dates within the previous ‘N’ number of months 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 : Date ( Year(Today()), Month(Today()) -2 , // change this number Day(Today()) )+ 1 ,

EndDate : Date ( Year(Today()), Month(Today()), Day(Today()) ) }, Filter(

'Calendar Dates' , CalendarDate >= StartDate, CalendarDate <= EndDate ) ) Code language: JavaScript ( javascript ) Output

Gallery shows only rows with a date in the previous 2 months. Current date is 6/16/2021 Title CalendarDate Saturday, April 17, 2021 4/17/2021 Sunday, April 18, 2021 4/18/2021 Monday, April 19, 2021 4/19/2021 Tuesday, April 20, 2021 4/20/2021 Wednesday, April 21, 2021 4/21/2021 Thursday, April 22, 2021 4/22/2021 Friday, April 23, 2021 4/23/2021 Saturday, April 24, 2021 4/24/2021 Sunday, April 25, 2021 4/25/2021 Monday, April 26, 2021 4/26/2021 Tuesday, April 27, 2021 4/27/2021 Wednesday, April 28, 2021 4/28/2021 Thursday, April 29, 2021 4/29/2021 Friday, April 30, 2021 4/30/2021 Saturday, May 1, 2021 5/1/2021 Sunday, May 2, 2021 5/2/2021 Monday, May 3, 2021 5/3/2021 Tuesday, May 4, 2021 5/4/2021 Wednesday, May 5, 2021 5/5/2021 Thursday, May 6, 2021 5/6/2021 Friday, May 7, 2021 5/7/2021 Saturday, May 8, 2021 5/8/2021 Sunday, May 9, 2021 5/9/2021 Monday, May 10, 2021 5/10/2021 Tuesday, May 11, 2021 5/11/2021 Wednesday, May 12, 2021 5/12/2021 Thursday, May 13, 2021 5/13/2021 Friday, May 14, 2021 5/14/2021 Saturday, May 15, 2021 5/15/2021 Sunday, May 16, 2021 5/16/2021 Monday, May 17, 2021 5/17/2021 Tuesday, May 18, 2021 5/18/2021 Wednesday, May 19, 2021 5/19/2021 Thursday, May 20, 2021 5/20/2021 Friday, May 21, 2021 5/21/2021 Saturday, May 22, 2021 5/22/2021 Sunday, May 23, 2021 5/23/2021 Monday, May 24, 2021 5/24/2021 Tuesday, May 25, 2021 5/25/2021 Wednesday, May 26, 2021 5/26/2021 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