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!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,023)