Answered

Sort Column value from biggest to lowest

(0) Share

Report

Posted on by Community Power Pla...

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

Sort.jpg

I have the same question (0)

All responses (28)

Answers (2)

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
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 (1)

Report
@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... on at

Like (0)

Report

Hi @TJO,

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

See the pictures

sort1.jpg

Sort2.jpg

Was this reply helpful? Yes No
TJO 230 on at

Like (0)

Report

@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... on at

Like (0)

Report

Hi @TJO
No?

Was this reply helpful? Yes No
TJO 230 on at

Like (0)

Report

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

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

Like (0)

Report

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 (0)

Report

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

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

Like (0)

Report

Hi @TJO,

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

-phh

Calu.jpg

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

Like (0)

Report

Hi @TJO,

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

-PHH

Was this reply helpful? Yes No