cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Sort by Date

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 screenshotR3eceived datae.pngRecieved date 2.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Sort by Date

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

View solution in original post

5 REPLIES 5
Highlighted
Dual Super User
Dual Super User

Re: Sort by Date

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
Not applicable

Re: Sort by Date

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

Highlighted
Dual Super User
Dual Super User

Re: Sort by Date

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

 

 

Highlighted
Anonymous
Not applicable

Re: Sort by Date

@RezaDorrani 

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

Highlighted
Dual Super User
Dual Super User

Re: Sort by Date

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

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,145)