cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Helper V
Helper V

How did you define the FilterValue?

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (51,785)