Sort Descending

(0) Share

Report

Posted on by Caleb62881177

789

Hello Everyone,

I would like to sort the expression in descending order of Column4.

Concat( Filter( SPList, Column1 = ThisItem.Column1 && Column2 = ThisItem.Column2 && Column3.Value = ThisItem.Column3.Value ), If( IsBlank(Column4) || Len(Trim(Column4)) = 0, "", Column4 & ";" ) )

I hope the information I shared can help.

@WarrenBelz @ANB @mmbr1606 @Amik @timl @EricRegnier

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Caleb62881177

Assuming you want to sort the data prior to concatenating it with Concat, the formula would look like this:

Concat( Sort( Filter( SPList, Column1 = ThisItem.Column1 && Column2 = ThisItem.Column2 && Column3.Value = ThisItem.Column3.Value ), Column4, SortOrder.Descending ) , If( IsBlank(Column4) || Len(Trim(Column4)) = 0, "", Column4 & ";" ) )
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @timl , Your solution worked. Thank you very much for all your effort.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Caleb62881177 - you're welcome!