Answered

Sorting BrowserGallery1

(0) Share

Report

Posted on by TriEssent

Hello,

I am trying to sort my screen by date instead of by title. I am unsure of the syntax to use here. My date column is called "Date".

Thanks in advance for any help that can be given.

This is the current syntax:

SortByColumns(Filter([@'RV-XFMR-PM'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@TriEssent

Please consider changing your Formula to the following:

SortByColumns( Filter([@'RV-XFMR-PM'], StartsWith(Title, TextSearchBox1.Text) ), "Date", If(SortDescending1, Descending, Ascending) )

I hope this is helpful for you.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@TriEssent,
Based on the issue that you mentioned, do you want to sort the Date column within your 'RV-XFMR-PM'?
Could you please share a bit more about the scenario?
I agree with @RandyHayes, the formula he provided is correct, if you just need to sort the Date column and search Title column for the start string, just do it.
If you also want to search the Date column based on the start string, I think I could do some addition.

SortByColumns(Filter([@'RV-XFMR-PM'], StartsWith(Text(Date), TextSearchBox1.Text)), "Date", If(SortDescending1, Descending, Ascending))

Note: This may cause a delegation warning for the Text() function. If your data set is not very huge, you could ignore it.
Hope it could help you.
Best Regards,
Qi
TriEssent 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help, @RandyHayes. If I may ask - where does the SortOrder.Descending go to make it sort with the newest dates on top?
TriEssent 6 on at

Like
a
(0)

Report
Copy link

Link copied!

This seems to work:

SortByColumns(Filter([@'RV-XFMR-PM'], StartsWith(Title, TextSearchBox1.Text)), "Date",Descending)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@TriEssent

Yes, that will give you a sorted list of dates with most recent at the top.