web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Find the MAX in collec...

Power Apps

Unanswered

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

(0) Share

Report

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

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

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @lardo5150 ,

Can you please share the results? Perhaps the column type is a text, not a number?

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (1)

Report

I had to use Value(SUMCases) (that is my SPO calculated column) instead of just SUMCases.
Thanks!

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @lardo5150 ,

Edit: Good to see you get this sorted 🙂

Was this reply helpful? Yes No

Join the conversation