Sort by Date

[Anonymous]

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

[RezaDorrani]

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

[Anonymous]

@RezaDorrani  Why different dates? It should show the same dates weather i put 500 or 2 in row limits?

[RezaDorrani]

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

[Anonymous]

@RezaDorrani 

Is there anyway, so it shows the latest date even after changing the delagation row limits?

[RezaDorrani · Accepted 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