cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
oappdev
Level 8

Calculate total from multiple choice on SharePoint List

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

 

Capture.PNG

 

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Edwin-Abdalian
Level 10

Re: Calculate total from multiple choice on SharePoint List

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

View solution in original post

5 REPLIES 5
Edwin-Abdalian
Level 10

Re: Calculate total from multiple choice on SharePoint List

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!

Community Support Team
Community Support Team

Re: Calculate total from multiple choice on SharePoint List

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
oappdev
Level 8

Re: Calculate total from multiple choice on SharePoint List

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
Level 10

Re: Calculate total from multiple choice on SharePoint List

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

View solution in original post

oappdev
Level 8

Re: Calculate total from multiple choice on SharePoint List

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

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,281)