Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Sort Column value from biggest to lowest

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


Hi @phh ,

I do not use calculated columns in SharePoint for a number of reasons including the difficulties you are having.

You may be better off using AddColumns to your data set using the same calculation.

Hi @WarrenBelz,

I just do not know how to make my field "ha missing" in sharepoint and how I minus the 2 values ​​from each other Do you have any explanation for that.

It is also important to me that it can update up in sharepoint.

Preferably step by step


Hi @phh ,

I was simply agreeing with @timl 's AddColumns suggestion as you tagged me.

The documents on this are here.

Hi @WarrenBelz@timl 
 As you can see, the field really works at the last "ha missing" But not by the others. I can not really understand what you are writing. Is it possible to make everyone work depending on which column it is? Hope you understand.




Hi @WarrenBelz and @timl again,

I'm sorry I do not quite understand what you write and have sent.
Is it possible?

If possible you will then be able to make a guide step by step in how to do it. If this is not possible you will then make a guide in how to do the sorting function on all the others but not "have shortcomings"

Plz, would like help 🙂


Hi @WarrenBelz and @timl,

I have tried to follow her from this link
Title works but "Ha Bestilt" does not work? In sharepoint, it stands to be single line. What should I do so that it can also sort?

See the picture


Hi Peter

If your gallery isn't sorting in numeric sequence because HaBestilt is of data type "single line text", you can create a column that contains the numeric representation of HaBestilt - let's call this valHaBestilt.
You would set the items property of your gallery to this:

SortByColumns(AddColumns(Jordpr0ver5, "valHaBestilt", Value(HaBestilt)),


For your sort label, you would then set the SortPriority variable to sort by valHaBestilt like so:



Hi @timl,
It worked what you wrote! 🙂

I have 2 where addcolumns must be used.
How do I put them together inside the items property of your gallery. 
Look at the pictures.

The image with "ha missing" worked but just could not get the other sort buttons to work when I tried earlier. I just want to know how to put several together in items property

I hoppe you understand. 🙂 

Hi Peter,

I'm glad that works. You can use AddColumns to add 'Ha Mangler' like so.


SortByColumns(AddColumns(Jordpr0ver5, "valHaBestilt", Value(HaBestilt), "valHaMangler", Value(HaMangler)),


You can then sort that column with this formula.



View solution in original post

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,887)