cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

DateDiff to filter a weekly schedule

New to PowerApps and trying to build an app that will tell our conference schedule.

 

Here's what I've got:

 

I'm using the formula below to set today at the filter value on my BrowseGallery screen.

 

SortByColumns(Filter('CRP Readiness Tracker', DateDiff(Day_x0020_1_x0020__x002d__x0020_,Now())=Value(FilterValue)), "Title", If(SortDescending1, Descending, Ascending))

 

I have navigational buttons at the top of the BrowseGallery screen that are Today, Tomorrow, and Next 7 days.

 

For today and tomorrow I'm using the formulas below, respectively and they work great.

 

UpdateContext({FilterValue:0})

UpdateContext({FilterValue:-1})

 

I'm struggling with the formula for the "Nexxt 7 Days" button.  Here's what I have, but it's pulling up data for 7 days from now, not all the days in between.

 

UpdateContext({FilterValue:-7})

 

Thanks in advance for your help!

Hailey

 

1 REPLY 1
Highlighted
Helper V
Helper V

Re: DateDiff to filter a weekly schedule

How did you define the FilterValue?

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,532)