I'm trying to figure out the best way to achieve the following or if it's even possible.
I have a sharepoint list with items and each item as a value score so the list looks something like this.
In the powerapp my users pick items from the list through a combo box and they are concatenated and stored in a text field.
I want the highest score to be stored in a separate text box as I need to use it for something else. So for example in the list above If they chose Item1 , Item2 and Item5 I would like "4" to be stored somewhere or if they chose Item1 and Item3 and Item4 then it would be "3" etc..
I'm thinking collection of somekind? I know how to get the scores and sum them but not sure how to get the highest one? Any advice ?
hi @vfdd you can achieve that with a collection indeed. add the function to the onselect property of the gallery:
OnSelect = (_GetMax,Gallery.Selected) and add a label with its text as Max(_GetMax,Value). Or you can add to OnSelect = Set(_MaxVal,If(Value(Gallery.Selected.Value) > _MaxVal,Value(Gallery.Selected.Value),_MaxVal)) now set the text value of the label to _MaxVal