cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Support
Community Support

Re: Problems with delegation when filtering by date

Hi @PYGDL ,

It would not affect the result you want to achieve. Please make sure you have set the "Data row limit for Non-delegable queries" option to maximum vlaue -- 2000 within Advanced settings of App settings of your app already.

 

If you have changed above Delegation limit, the Filter('reporte de Tiempos', ID >= 19000 && ID<=21000) formula would return 2000 records at most (from ID=19000 to ID=21000).

 

Please take a try with above solution I provided, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Problems with delegation when filtering by date

@v-xida-msft ID is not delegable for any operation other than = (equal).  Using the greater than and less than operators will not return valid results from SharePoint.

@PYGDL You'll need to consider some of the other options presented in the replies to achieve your goal.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Resolver III
Resolver III

Re: Problems with delegation when filtering by date

To sort this on my end, I made a number column that is in the form yyyymmdd, i.e. 20190501, a unique number.

This can be fully delegated then, and for formatting, you could have a calculated column

Highlighted
Super User
Super User

Re: Problems with delegation when filtering by date

@xzDan 

Yes...works well, that and the other choice of converting to string are options as I mentioned in reply #3.  But definitely not by ID or Date alone as they are nondelegable currently in SharePoint.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Regular Visitor

Re: Problems with delegation when filtering by date

Thank you all so much for your help.

 

In the end, I applied the @RandyHayes  solution and it worked great.
I created a new column in the SP list where the date is saved in numerical format, example: 20190720, and I use these number in the filter of each gallery.

To fill in this column in the existing records, perform a Flow that did all the work taking 5000 records each time.

 

There is even an improvement in the performance of the application.

 

Again, thank you all for your answers.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

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

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

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!

Top Solution Authors
Top Kudoed Authors
Users online (6,608)