Power Apps Filter Gallery By Dates In Last Month

Filter a gallery to show only dates in the last month.



Input

Calendar Dates is a SharePoint list with consecutive days starting 1/1/2018 and ending 12/31/2024 (2,557 rows)

TitleCalendarDate
Monday, January 1, 20181/1/2018
Tuesday, January 2, 20181/2/2018
Wednesday, January 3, 20181/3/2018
Thursday, January 4, 20181/4/2018
Friday, January 5, 20181/5/2018
Tuesday, December 31, 202412/31/2024


Code

Use this code in the Items property of a gallery.

With(
    {
        StartDate: Date(
            Year(Today()),
            Month(Today())-1
            ,1
        ),
        EndDate: Date(
            Year(Today()),
            Month(Today())
            ,1
        )-1
    },
    Filter(
        'Calendar Dates',
        CalendarDate >= StartDate,
        CalendarDate <= EndDate
    )
)


Output

Gallery shows only rows with a date in the last month. Current date is 6/16/2021.

TitleCalendarDate
Saturday, May 1, 20215/1/2021
Sunday, May 2, 20215/2/2021
Monday, May 3, 20215/3/2021
Tuesday, May 4, 20215/4/2021
Wednesday, May 5, 20215/5/2021
Thursday, May 6, 20215/6/2021
Friday, May 7, 20215/7/2021
Saturday, May 8, 20215/8/2021
Sunday, May 9, 20215/9/2021
Monday, May 10, 20215/10/2021
Tuesday, May 11, 20215/11/2021
Wednesday, May 12, 20215/12/2021
Thursday, May 13, 20215/13/2021
Friday, May 14, 20215/14/2021
Saturday, May 15, 20215/15/2021
Sunday, May 16, 20215/16/2021
Monday, May 17, 20215/17/2021
Tuesday, May 18, 20215/18/2021
Wednesday, May 19, 20215/19/2021
Thursday, May 20, 20215/20/2021
Friday, May 21, 20215/21/2021
Saturday, May 22, 20215/22/2021
Sunday, May 23, 20215/23/2021
Monday, May 24, 20215/24/2021
Tuesday, May 25, 20215/25/2021
Wednesday, May 26, 20215/26/2021
Thursday, May 27, 20215/27/2021
Friday, May 28, 20215/28/2021
Saturday, May 29, 20215/29/2021
Sunday, May 30, 20215/30/2021
Monday, May 31, 20215/31/2021