getting max value from a gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

timl 37,199 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous

This should return the maximum value from your gallery:

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

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you both very very much !!

Was this reply helpful? Yes No
boom_powerapps 101 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
timl 37,199 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No