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 @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
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 @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
both will work
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
191 | |
70 | |
50 | |
38 | |
28 |
User | Count |
---|---|
243 | |
114 | |
91 | |
91 | |
71 |