Calculate total from multiple choice on SharePoint List

[oappdev]

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

[Edwin-Abdalian]

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!

[v-monli-msft]

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

[oappdev]

Hi @v-monli-msft 

That is correct

• Using a Combo box for Attributes/Values
• Points is a number column

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 

[Edwin-Abdalian · Accepted solution]

you need to use the Patch function to insert the Sum in other list.

[oappdev]

Thank you @Edwin-Abdalian Will give it a try and circle back