Power Apps Filter Gallery By Dates In Last Week

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

Power Apps Filter Gallery By Dates In Last Week

Filter a Power Apps gallery to show only dates in the last week. 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 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 ) ) Code language: JavaScript ( javascript ) Output

Gallery shows only rows with a date in the last week. Current date is 6/16/2021. Title CalendarDate 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