cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ACPBSCi
Resolver I
Resolver I

Calculated Column Based on Value of Dropdown

I have different fields with a default weighted value, e.g.:

Likelihood of Success = 10

The user selects a rating for that field from a dropdown list of choices and each rating has a value:

High = 5

Medium = 3

Low = 0

When the user rates the field, I want the app to calculate the total weighted value and populate a field in my SharePoint list:

Likelihood of Success (10), High (3): 10 * 3 = 30

What would that expression look like when the value of the rating varies and the default weighted value does not?

If High, then 5; If Medium, then 3; If Low then 0 * 10

Would I use the data card value in my expression or set some variables and use those?

1 ACCEPTED SOLUTION

Accepted Solutions

@ACPBSCi 

If you put the Items property of the dropdowns as shown on the right you can set the final score as shown on the lower formula. This formula is the one you can modify to change the weight given to each dropdown's score. 

1.png

View solution in original post

4 REPLIES 4
Drrickryp
Super User
Super User

@ACPBSCi 

Could you provide a screenshot that illustrates your issue please?

ACPBSCi
Resolver I
Resolver I

I don't have much to show you, but here is my app:

App1.PNG

When they select the rating, the corresponding value of the rating needs to be multiplied by the default weighted value of the topic they were rating. Then that calculated value needs to populate my SharePoint list:

App2.PNG

I have the Value fields in my app and they will be hidden, so I can set those values to whatever I calculate. I'm just not really sure how to begin. I set 3 variables OnStart:

VarHigh, 5

VarMed, 3

VarLow, 0

So if a field's value = High, I would use varHigh in the calculation. That's as far as I've gotten, I'm afraid.

@ACPBSCi 

If you put the Items property of the dropdowns as shown on the right you can set the final score as shown on the lower formula. This formula is the one you can modify to change the weight given to each dropdown's score. 

1.png

View solution in original post

ACPBSCi
Resolver I
Resolver I

Thank you, @Drrickryp ! I will give that a try!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,000)