I have an SPO List.
I am grabbing this list and putting it in a variable......var_MaxList
There is column called case load.
I want to find the MAX number there and return the entire line into another variable.
So basically, go through the entire collection, find the engineer with the MOST number of cases, and return that to a variable.
Then with that variable I can pull out the different values from SPO.
The other piece is there is a chance that two or more people will have the same amount, so MAX could return three different lines.
I just want it to return the first one found.
I had to use Value(SUMCases) (that is my SPO calculated column) instead of just SUMCases.
Thanks!
It is a calcualted column if that makes a difference.
It is adding two other columns in SPO.
It is returning something right in the middle (9), when I have someone with 30.
Seems to be returning something right in the middle, not the max for some reason.
Hi @lardo5150 ,
By sorting the collection by the amount and then taking the first item, you can get the required result:
Set(
gblMax,
First(
Sort(
Collection,
AmountColumn,
SortOrder.Descending
)
)
)
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional