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 II
Super User II

@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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,400)