Hello
So i am using this :
SortByColumns(Filter('[dbo].[databse1]',StartsWith(PONum, TextSearchBox1.Text),StartsWith(LookUp(CachedOperatorTypes,Id=OperatorId,FirstName), TextSearchBox1_1.Text)),"ReceivedDateTime",If(SortDescending1, Ascending,Descending))
This thing works fine and shows the latest date on TOP. See the screenshot.
But, When I go to Advanced settings and change the data row limit to 2. it doesn't shows the latest dates. How to fix that .. See the screenshot
Solved! Go to Solution.
Hi @Anonymous
It will show the latest date but it will depend on the delegation limit
Another option will be to load data in a collection in batches of 2k (delegation limit)
And then sort base don the collection
Hi @Anonymous
Both your screenshots are sorted correctly
You have set data row limit for delegation to 2
if you have a delegation warning then it will only fetch 2 records
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@RezaDorrani Why different dates? It should show the same dates weather i put 500 or 2 in row limits?
Hi @Anonymous
It is becuase the items returned are different
In your gallery, add a label and set its text to ThisItem.ID (this will help understand which item is being showcased)
Also when delegation limit is set to 2, it will first load 2 records and then perform your filter (if you are getting a delegation warning)
I just posted a video describing delegation
https://www.youtube.com/watch?v=gwiErbYtRdA
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Is there anyway, so it shows the latest date even after changing the delagation row limits?
Hi @Anonymous
It will show the latest date but it will depend on the delegation limit
Another option will be to load data in a collection in batches of 2k (delegation limit)
And then sort base don the collection
User | Count |
---|---|
212 | |
94 | |
85 | |
49 | |
38 |
User | Count |
---|---|
271 | |
103 | |
102 | |
60 | |
59 |