cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User III
Super User III

Re: Sort Column value from biggest to lowest

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.

Highlighted
Helper III
Helper III

Re: Sort Column value from biggest to lowest

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

Highlighted
Super User III
Super User III

Re: Sort Column value from biggest to lowest

Hi @phh ,

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

The documents on this are here.

Highlighted
Helper III
Helper III

Re: Sort Column value from biggest to lowest

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.

 
 

 

 

Highlighted
Helper III
Helper III

Re: Sort Column value from biggest to lowest

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

Highlighted
Helper III
Helper III

Re: Sort Column value from biggest to lowest

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

 

Highlighted
Super User III
Super User III

Re: Sort Column value from biggest to lowest

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}
)

 

Highlighted
Helper III
Helper III

Re: Sort Column value from biggest to lowest

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. 🙂 




Highlighted
Super User III
Super User III

Re: Sort Column value from biggest to lowest

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,603)