cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PoohBear
Level 8

Date Filters are not working

All of sudden my app stopped working today because it uses date filters. This is extremely infuriating!! What changed and how can I fix it????

12 REPLIES 12
PoohBear
Level 8

Re: Date Filters are not working

Here is my formula. This used to work fine, but filtering by Today() returns no data now. 

 

SortByColumns(Filter(LastN('Archive-Parking Spot List',500),EmployeeEmail=CurrentUserName.Text && 'Start Date'=Today()),"Start_x0020_Date_x0020_Text",Ascending)

Highlighted
Super User
Super User

Re: Date Filters are not working

There was an update today that affected Today/Now.  See the following blog post:  https://powerapps.microsoft.com/en-us/blog/delegation-enhancements-for-lookups-today-now-and-addcolu...

PoohBear
Level 8

Re: Date Filters are not working

If enter the formula as below (less than today) I get data. However, if I put > or = nothing comes back. If I remove the filter I can see everything including the list item for today.

SortByColumns(Filter(LastN('Archive-Parking Spot List',1000),EmployeeEmail=CurrentUserName.Text && 'End Date'<Today()),"Start_x0020_Date_x0020_Text",Ascending)

PoohBear
Level 8

Re: Date Filters are not working

Thank you so much for giving me this link. I will try to resolve with it!


@LRVinNC wrote:

There was an update today that affected Today/Now.  See the following blog post:  https://powerapps.microsoft.com/en-us/blog/delegation-enhancements-for-lookups-today-now-and-addcolu...


 

Knich
Level: Powered On

Re: Date Filters are not working

Have you confirmed your data source Archive-Parking Spot List contains today's date and/or employee email in the last 500 records?

PoohBear
Level 8

Re: Date Filters are not working

Yes. Even if I bump to 1000 (only 513 list items) I still get nothing

 

Super User
Super User

Re: Date Filters are not working

Are you getting a delegation warning on this query?  If so, what do you have the data row limit for non-delegable queries set to in your app settings?  The default is 500 -- you can increase to a max of 2000.  If this data source has more than 2000 entries, you will never be able to return this data with this query.

PoohBear
Level 8

Re: Date Filters are not working

So that is the issue, when I bump the Data Row limit to 2000 I get the expected result. Howerver, I am not getting a delegation warning because of the LastN in the formula. How can I change that formula so I don't run into this issue?

Knich
Level: Powered On

Re: Date Filters are not working

Unfortunately, I ran into delegation issues until I switeched to a SQL database for my data. 

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,110)