Sort Items based on Date

[Tapesh]

Hi 

Experts im trying to sort the items based on name if entered and when they select the sortDecending1 button the items should sort based in the recent date order.  i.e from new to old and when deselected the sort button gallery items so be normal as old to new.

I do not know if im doing it correctly or not the below code is correct or not. Can anyone help me, please? if m doing wrong and what part im doing ...

Thanks, experts

ON Items property of Gallery:   also with the below formula im getting the delegation warning

When I used the above formula or code 

Im getting an error. as below  

 

 

Please see: I have converted date time to different formate using 

ON text property :

Text(ThisItem.Created, "[$-en-US]d, mmmm yyyy")

Whereas initial it was just simple Datetime Formate 

However, the error does remain the same. I.e. unable to sort items on date order ascending or descending.

Any help Experts Thanks. 

Has to raise this query again as I did not get any feedback on my last one. 

Thanks in advance.

[RandyHayes · Accepted solution]

@Tapesh 

I'm not completely sure of your formula as you mention sorting by date, but it appears to be sorting by title.

If you want to sort by the Created date, then you can consider using this formula:

SortByColumns(
    Filter(
        'Petty Cash & GL Code' ,
        (StatusResult = "All" || Status = StatusResult) &&
        (SearchBox.Text = "" || StartsWith('Name (Title)', SearchBox.Text))
    ),
    "Created",
    If(SortDescending1, Descending, Ascending)
)    

This should give you results sorted by Created date.

Also, for future reference, if you want to sort by the Text version of a date, you should have your date in a yyyymmdd format.  Otherwise your sorting will be incorrect.

I hope this is helpful for you.