Dropdown sum powerapps

Question

I would like to make a sum of all dropdown values into a label text box.

I am using following formula, but I do not understand where am I going wrong.

Can anyone assist?

I have also added a screenshot if that helps anyhow.

Note: scores is the table name the dropdown values feed from.

Sum(scores, Dropdown3.Selected.Value + Dropdown3_1.Selected.Value + Dropdown3_2.Selected.Value)

Ganesh, formula is invalid. Error persists. Name isn't valid. This identifier isn't recognized. — Jose1978, Dec 2, 2020 at 6:07
Have you tried formula in answer? Can you share screenshot of error message? — Ganesh Sanap - MVP, Dec 2, 2020 at 7:16
Hi ganesh, yes I've tried both formulas. I do not think it is formula error but something else. I have emailed a picture with error message. — Jose1978, Dec 2, 2020 at 8:26
I think there is issue with the drop-down controls in your form or in SharePoint connector. Try refreshing SharePoint data source, removing and re-adding dropdown controls in your form. — Ganesh Sanap - MVP, Dec 4, 2020 at 15:22

Ganesh Sanap - MVP · Accepted Answer · 2020-12-01 18:19:06Z

0

Set the Text property of label to:

Sum(Dropdown3.Selected.Value, Dropdown3_1.Selected.Value, Dropdown3_2.Selected.Value)

If data type of selected item value from drop-down is string then use:

Sum(Value(Dropdown3.Selected.Value), Value(Dropdown3_1.Selected.Value), Value(Dropdown3_2.Selected.Value))

Microsoft documentations:

answered Dec 1, 2020 at 18:19

42.8k21 gold badges30 silver badges58 bronze badges

If you want to store the value of Sum to use anywhere else then you can use variables in power apps.
– Ganesh Sanap - MVP
Dec 1, 2020 at 18:21

Add a comment |

1 Answer 1