Power Apps Filter Gallery By Dates In Last Quarter

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

Power Apps Filter Gallery By Dates In Last Quarter

Filter a Power Apps gallery to show only dates in the last quarter. 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()) -If( Mod(Month(Today()) -1 , 3 ) = 0 , 0 , Mod( Month(Today()) -1 , 3 ) ) -3 , 1 ),

EndDate : Date ( Year(Today()), Month(Today()) + 3 -Mod(Month(Today()) -1 , 3 ) -3 , 1 ) -1 }, Filter(

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

Gallery shows only rows with a date in the last month. Current date is 6/16/2021. Title CalendarDate Friday, January 1, 2021 1/1/2021 Saturday, January 2, 2021 1/2/2021 Sunday, January 3, 2021 1/3/2021 Monday, January 4, 2021 1/4/2021 Tuesday, January 5, 2021 1/5/2021 Wednesday, January 6, 2021 1/6/2021 Thursday, January 7, 2021 1/7/2021 Friday, January 8, 2021 1/8/2021 Saturday, January 9, 2021 1/9/2021 Sunday, January 10, 2021 1/10/2021 Monday, January 11, 2021 1/11/2021 Tuesday, January 12, 2021 1/12/2021 Wednesday, January 13, 2021 1/13/2021 Thursday, January 14, 2021 1/14/2021 Friday, January 15, 2021 1/15/2021 Saturday, January 16, 2021 1/16/2021 Sunday, January 17, 2021 1/17/2021 Monday, January 18, 2021 1/18/2021 Tuesday, January 19, 2021 1/19/2021 Wednesday, January 20, 2021 1/20/2021 Thursday, January 21, 2021 1/21/2021 Friday, January 22, 2021 1/22/2021 Saturday, January 23, 2021 1/23/2021 Sunday, January 24, 2021 1/24/2021 Monday, January 25, 2021 1/25/2021 Tuesday, January 26, 2021 1/26/2021 Wednesday, January 27, 2021 1/27/2021 Thursday, January 28, 2021 1/28/2021 Friday, January 29, 2021 1/29/2021 Saturday, January 30, 2021 1/30/2021 Sunday, January 31, 2021 1/31/2021 Monday, February 1, 2021 2/1/2021 Tuesday, February 2, 2021 2/2/2021 Wednesday, February 3, 2021 2/3/2021 Thursday, February 4, 2021 2/4/2021 Friday, February 5, 2021 2/5/2021 Saturday, February 6, 2021 2/6/2021 Sunday, February 7, 2021 2/7/2021 Monday, February 8, 2021 2/8/2021 Tuesday, February 9, 2021 2/9/2021 Wednesday, February 10, 2021 2/10/2021 Thursday, February 11, 2021 2/11/2021 Friday, February 12, 2021 2/12/2021 Saturday, February 13, 2021 2/13/2021 Sunday, February 14, 2021 2/14/2021 Monday, February 15, 2021 2/15/2021 Tuesday, February 16, 2021 2/16/2021 Wednesday, February 17, 2021 2/17/2021 Thursday, February 18, 2021 2/18/2021 Friday, February 19, 2021 2/19/2021 Saturday, February 20, 2021 2/20/2021 Sunday, February 21, 2021 2/21/2021 Monday, February 22, 2021 2/22/2021 Tuesday, February 23, 2021 2/23/2021 Wednesday, February 24, 2021 2/24/2021 Thursday, February 25, 2021 2/25/2021 Friday, February 26, 2021 2/26/2021 Saturday, February 27, 2021 2/27/2021 Sunday, February 28, 2021 2/28/2021 Monday, March 1, 2021 3/1/2021 Tuesday, March 2, 2021 3/2/2021 Wednesday, March 3, 2021 3/3/2021 Thursday, March 4, 2021 3/4/2021 Friday, March 5, 2021 3/5/2021 Saturday, March 6, 2021 3/6/2021 Sunday, March 7, 2021 3/7/2021 Monday, March 8, 2021 3/8/2021 Tuesday, March 9, 2021 3/9/2021 Wednesday, March 10, 2021 3/10/2021 Thursday, March 11, 2021 3/11/2021 Friday, March 12, 2021 3/12/2021 Saturday, March 13, 2021 3/13/2021 Sunday, March 14, 2021 3/14/2021 Monday, March 15, 2021 3/15/2021 Tuesday, March 16, 2021 3/16/2021 Wednesday, March 17, 2021 3/17/2021 Thursday, March 18, 2021 3/18/2021 Friday, March 19, 2021 3/19/2021 Saturday, March 20, 2021 3/20/2021 Sunday, March 21, 2021 3/21/2021 Monday, March 22, 2021 3/22/2021 Tuesday, March 23, 2021 3/23/2021 Wednesday, March 24, 2021 3/24/2021 Thursday, March 25, 2021 3/25/2021 Friday, March 26, 2021 3/26/2021 Saturday, March 27, 2021 3/27/2021 Sunday, March 28, 2021 3/28/2021 Monday, March 29, 2021 3/29/2021 Tuesday, March 30, 2021 3/30/2021 Wednesday, March 31, 2021 3/31/2021