Answered

Sort Column value from biggest to lowest

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have tried to search for something that could give a lot of the answer to how many filter function that can rank the values from largest to smallest and vice versa.

That's the value of "ha missing" I would like to have ranked

If it can be explained step by step it will be very nice!!!

I hope you can help me, please!

See the picture
-Peter

Categories:

Building Power Apps

I have the same question (0)

All responses (28)

Answers (2)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi Peter,

The SortByColumns can help you.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-sort

In this case, you would amend the Items property of your gallery using the formula beneath.

SortByColumns( <InsertExistingItemsFormulaForGallery1>, "ha missing", Descending )

Was this reply helpful? Yes No
TJO 230 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous You can set you gallery items property to sort depending on a boolean variable:

SortByColumns( tabDaten, "Ha Missing", If( varSortAscending, Ascending, Descending ) )

Then on the sort button OnSelect property you toggle the boolean variable:

Set(varSortAscending, !varSortAscending)

So without setting pressing the sort button the sorting should be descending upon loading at first since varSortAscending will be blank/false.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TJO,

It just turns the column around. the black not on the values.

See the pictures

Was this reply helpful? Yes No
TJO 230 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous That is weird. Maybe there is a problem with the space in your column name (if your data is in SharePoint or Excel). Could you try with "ha_x0020_missing"

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TJO
No?

Was this reply helpful? Yes No
TJO 230 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous mmh, could you paste your whole formula in here please

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TJO,

The first formula is for the gallery and the second formula is for the icon.

SortByColumns(
Jordprøver5,
"Ha_x0020_mangler",
If( varSortAscending,
Ascending,
Descending
)
)

Set(varSortAscending, !varSortAscending)

-Peter

Was this reply helpful? Yes No
TJO 230 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous The formulas seem correct.
Could this be a number stored as text issue?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TJO,

The field is a calculated field and is, and it is set to number.

-phh

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TJO,

Have you had a look at it or is it not possible?

-PHH

Was this reply helpful? Yes No