Power Apps Filter Gallery By Dates In Next Week

Filter a gallery to show only dates in the next week.



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: Today()-(Weekday(Today(), StartOfWeek.Sunday))+7,
        EndDate: DateAdd(Today(),(7- Weekday(Today(),StartOfWeek.Sunday))+7,Days)
    },
    Filter(
        'Calendar Dates',
        CalendarDate > StartDate,
        CalendarDate <= EndDate
    )
)


Output

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

TitleCalendarDate
Sunday, June 20, 20216/20/2021
Monday, June 21, 20216/21/2021
Tuesday, June 22, 20216/22/2021
Wednesday, June 23, 20216/23/2021
Thursday, June 24, 20216/24/2021
Friday, June 25, 20216/25/2021
Saturday, June 26, 20216/26/2021