Happy Saturday
Have a sharepoint list call Risk Scoring
Have 2 column one call Attributes/Values and the other Points.
What is the best approach to collect the total when they select multiple choice from a dropdown
[x] Lives with someone poor support
[x] Lives alone, good support system
------------------------------------------
Total: 8
Thank you in advance
Solved! Go to Solution.
1- OnChange of your ComboBox: ClearCollect(colSelectedItems,cmbRiskScores.SelectedItems.Points)
2- Create a label and set the Text to : Sum(colSelectedItems,Points)
--------------------------------------------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!
Hi @oappdev ,
Is Attributes/Values a multiple-selection choice column? And Points a number column? And how would want the numbers in Points column to be summed?
Regards,
Mona
That is correct
I was able to create a Label and add this to the Text Property from @Edwin-Abdalian
Sum(ComboBox2.SelectedItems,Points)
Displaying the correct sum on the label
I would like to submit the sum to a Column in SharePoint call Total Score
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
171 | |
60 | |
32 | |
32 |
User | Count |
---|---|
334 | |
271 | |
103 | |
71 | |
56 |