Power App - Sum of Numbers in Drop Downs

(0) Share

Report

Posted on by tg136

HI Guys,

I have created a sharepoint list with 3 sections -

Each section has a couple of questions relating to Risk and the user populates the answer to these questions from a dropdown with either a "0", "2","5" or a "10"

At the end of each section I want some written commentary from the user justifying the overall Risk Score for sum of the values in that section - This is where my problem lies

How do I insert something what totals up the scores (for that section only) so it appears to the user when they are writing text to justify the Risk score for that section -

Please keep in mind I am a novice also - thanks

I did insert a text label and then the following formulae in the "text" ---

"Total Risk Score: " & Sum(Op_Score_1.value,DataCardValue7.value)

Name isnt valid 'value' isnt recognised

I changed value to .text and still the same problem

Also, the text label did not appear when hitting 'play' - Visibility is set to true

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

In your text label for now try Sum(Value(Dropdown.Selected.Text),Value(Dropdown2.Selected.Text)) Use whatever your dropdown name is in place of Dropdown and Dropdown2.

Was this reply helpful? Yes No
tg136 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks worked a treat ! - Can I ask - In order to display the sum would you

1) Create a column in your sharepoint list specifically for the Total of all the scores and then in the Power App - Sum up your total in that Column
2) Insert a Text label into your form and put your formulae in there. When I tried this and hit play the text label moved everywhere when I scrolled the screen - I think as it wasnt a question in the sharepoint list

Was this reply helpful? Yes No
tg136 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks worked a treat ! - Can I ask - In order to display the sum would you

1) Create a column in your sharepoint list specifically for the Total of all the scores and then in the Power App - Sum up your total in that Column
2) Insert a Text label into your form and put your formulae in there. When I tried this and hit play the text label moved everywhere when I scrolled the screen - I think as it wasnt a question in the sharepoint list

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Many different ways.
The problem with 1 is you would have to Submit the form or Update the SPList each time a dropdown is changed if you wanted the sum to be accurate all the time. But if it is only needed at the end all dropdown values are stored that would be fine.

Is your label in a form? You could set it's visible property to varSum and then whenever you want to see it put: Set(varSum, true) in the OnSelect of a button or the text box of the commentary.

Was this reply helpful? Yes No
tg136 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I only need to display it at the end of the drop down questions as a visual for the end user. I dont need the sharepoint list to update Could you provide a little more information on this method please ,

"You could set it's visible property to varSum and then whenever you want to see it put: Set(varSum, true) in the OnSelect of a button or the text box of the commentary"

I'm not sure I follow what you are suggesting here - thanks for your time 🙂

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem.
Click on your label. Look for the Visible in the dropdown = fx bar. Make Visible = varSum
This will now make your label disappear because varSum has to be true for it to appear.
At the end when the questions have been answered set it to true.
Pretty much every control has an OnSelect property. If there is a button the user clicks after the questions put in the buttons OnSelect = Set(varSum, true)
You can make it go away by Set(varSum, false) in another OnSelect
You can also put the label and an X icon in a container and just set the containers Visible to varSum. You can use the OnSelect of the X icon to set(varSum, false) and close the container.

Was this reply helpful? Yes No