0

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)

Snapshot of my app

5
  • What is the error message you get on label control? Dec 1, 2020 at 18:11
  • 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? 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
  • 1
    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. Dec 4, 2020 at 15:22

1 Answer 1

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:

  1. Sum function
  2. Value function
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.