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????
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)
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...
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)
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...
Have you confirmed your data source Archive-Parking Spot List contains today's date and/or employee email in the last 500 records?
Yes. Even if I bump to 1000 (only 513 list items) I still get nothing
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.
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?
Unfortunately, I ran into delegation issues until I switeched to a SQL database for my data.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
179 | |
67 | |
36 | |
33 |
User | Count |
---|---|
341 | |
271 | |
113 | |
73 | |
58 |