cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phh
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
-Peter

28 REPLIES 28

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



-PHH

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 🙂

-PHH

Hi @WarrenBelz and @timl,

I have tried to follow her from this link https://www.youtube.com/watch?v=vyBsk7-1Mxk&t=1836s
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
- PHH

 

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)),
              SortPriority,
              If(SortDescending,Ascending,Descending)
)

 

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

UpdateContext({SortPriority:"valHaBestilt",
               SortDescending:!SortDescending}
)

 

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)),
              SortPriority,
              If(SortDescending,Ascending,Descending)
)

 

You can then sort that column with this formula.

UpdateContext({SortPriority:"valHaMangler",
               SortDescending:!SortDescending}
)

 

View solution in original post

Helpful resources

Announcements
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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,355)