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.
Item | Score |
Item1 | 2 |
Item2 | 2 |
Item3 | 3 |
Item4 | 2 |
Item5 | 4 |
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 ?
Thank you
Solved! Go to Solution.
hi @Anonymous 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
both will work
I haven't tried it yet, but there should be a MAX function that gives you the value directly by providing table and column.
If not just sort the table-column descending und get the first value with First().
If you struggle I might find some time to check this out.
hi @Anonymous 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
both will work
User | Count |
---|---|
168 | |
90 | |
74 | |
69 | |
57 |
User | Count |
---|---|
212 | |
159 | |
98 | |
89 | |
73 |