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
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}
)
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
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 @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 @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, @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,
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 @Anonymous ,
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 have read the article but unfortunately can not make it work since I use some different values. for example. calculating values and text fields and choices field. Do you have a solution for that? Well please have a guide step by step if possible 🙂
-Peter
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional