getting max value from a gallery

(0) Share

Report

Posted on by Community Power Pla...

I have a gallery called

glry_ReworkData

I have a label called "lbl_ID" this has the ID for the datasource descending.

that label references a field called - OLD_RW_ID in the datasource.

What I need: i need to reference this value

I need the value 95.2 to show in a Label. on my form.

How do i get the Max value from that gallery from

Thanks Dave

Categories:

General Questions

Using Apps Using Formulas

All responses (5)

Answers (1)

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report

Re: getting max value from a gallery

Hi @boom_powerapps,

It might be better for you to raise a new post as you may get a better response.

The high level approach is to sort the data source or the gallery AllItems by the numeric column in descending order by calling the Sort function. You would then call the First function to retrieve the row and to access the associated text column.
boom_powerapps 101 on at

Like (0)

Report

Re: getting max value from a gallery

@LaurensM @timl What if you want to return the MAX but also return text associated with the MAX value? For example, if Cars = 50, I see how to return the 50 but how do I return the text Cars for example?
Community Power Pla... on at

Like (0)

Report

Re: getting max value from a gallery

Thank you both very very much !!
LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: getting max value from a gallery

Hi @Anonymous,

Try the Max() function. Below you'll find an example using the gallery name and text field or using the data source and column name:

//Gallery + control (change to correct names) Max(Gallery1.AllItems, Value(Subtitle1.Text)) //Data source + column name Max(TableName, ColumnName)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
Verified answer

timl 34,933 Super User 2025 Season 1 on at

Like (1)

Report
Re: getting max value from a gallery

Hi @Anonymous

This should return the maximum value from your gallery:

Max(glry_ReworkData.AllItems, Value(lbl_ID.Text) )