Max value in a gallery

[Anonymous]

Hi everyone.  I am trying to retrieve the max value in a gallery.  I need to be able to pull it from the gallery and not from the data source for a few reasons.  Ive tried various ways most recently is "Max(Gallery1_3, TextInput3_3.Text)" which gives me an error Invalid Argument Type.  If at all possible I need to pull from the gallery rather than a collection because the data being changed by the user needs to be live and this MAX formula needs to reflect the last number the input.

Thanks!!

Chris

[Nogueira1306]

You to check the max between a Gallery and a Label?

If yes, try this:
Max(First(Sort(Gallery1_3, Number, Descending)).Number, Value(TextInput3_3.Text))

That is goint to get the first item from that sort. If that does not work, sort the gallery before and than just write this:

Max(First(Gallery1_3).Number, Value(TextInput3_3.Text))

If it says that it was expecting a number just put it inside a Value()

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

[Anonymous]

Hi @Nogueira1306 , thank you very much for the quick reply.  I was able to get it partially working with this formula.  

Max(Gallery1_3.AllItems.SeqOrder,SeqOrder)

SeqOrder is the column from my datasource that I am looking to get the max value from.  The problem now is it shows the MAX when the gallery is filtered.  I am looking for the max whether the gallery is filtered or now.

Chris

[v-qiaqi-msft]

Hi @Anonymous,

Do you want to get the max value from the SeqOrder column whatever the gallery is filtered or not?

Could you please tell me more about your scenario?

If you want to pull out the max value from the Gallery items, and do not want to pull it from the data source, I am afraid there is no way to achieve your need.

Since you do not want to get it from the data source directly, the Gallery items will always be filtered by the formula you set for the Items property of the Gallery once you reference to the Gallery1_3.AllItems.

In a word, you could always get a max value from the filtered records within the Gallery since you do not want to get it from the data source.

[Anonymous]

Hi @v-qiaqi-msft ,

Yes that is exactly what I am trying to do.  The end user is changing a field in the gallery to arrange the items in sequential order.  Pulling from the gallery helps because the change does not have to be saved each time to the data source slowing the process down.

Thank you for the clarification!!!

Chris

[WarrenBelz]

Hi @Anonymous ,

You should need

Max(
   Gallery1_3.AllItems,
   Value(TextInput3_3.Text)
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Anonymous]

Hi @WarrenBelz ,

Thank you for your response! Unfortunately that is also pulling in the maximum value of the filtered items, not the entire unfiltered gallery.

Chris

[WarrenBelz]

Hi @Anonymous ,

There is no filter in that code - it should show all gallery items.