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

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-quarters/. Author: Matthew Devaney.

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

Filter a gallery to show only dates within the previous ‘N’ number of quarters 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())-( 3 * 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 quarters. Current date is 6/16/2021 Title CalendarDates Thursday, December 17, 2020 12/17/2020 Friday, December 18, 2020 12/18/2020 Saturday, December 19, 2020 12/19/2020 Sunday, December 20, 2020 12/20/2020 Monday, December 21, 2020 12/21/2020 … … Wednesday, June 16, 2021 6/16/2021 (182 rows)