Find the MAX in collection, and assign values to another variable

Like (0) Share

Report

Posted on 23 Aug 2023 14:54:04 by lardo5150 Microsoft Employee

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.

Categories:

General Questions

Dataflows

Connecting to Data

All responses (6)

Answers (1)

BCBuizer 22,096 Super User 2025 Season 1 on 23 Aug 2023 at 15:30:59

Like (1)

Report

Re: Find the MAX in collection, and assign values to another variable

Hi @lardo5150 ,

Edit: Good to see you get this sorted 🙂
lardo5150 Microsoft Employee on 23 Aug 2023 at 15:30:05

Like (1)

Report

Re: Find the MAX in collection, and assign values to another variable

I had to use Value(SUMCases) (that is my SPO calculated column) instead of just SUMCases.
Thanks!
lardo5150 Microsoft Employee on 23 Aug 2023 at 15:24:10

Like (0)

Report

Re: Find the MAX in collection, and assign values to another variable

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.
BCBuizer 22,096 Super User 2025 Season 1 on 23 Aug 2023 at 15:22:23

Like (1)

Report

Re: Find the MAX in collection, and assign values to another variable

Hi @lardo5150 ,

Can you please share the results? Perhaps the column type is a text, not a number?
lardo5150 Microsoft Employee on 23 Aug 2023 at 15:17:56

Like (0)

Report

Re: Find the MAX in collection, and assign values to another variable

Seems to be returning something right in the middle, not the max for some reason.
Verified answer

BCBuizer 22,096 Super User 2025 Season 1 on 23 Aug 2023 at 14:57:12

Like (1)

Report
Re: Find the MAX in collection, and assign values to another variable

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