web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated Column Base...
Power Apps
Unanswered

Calculated Column Based on Value of Dropdown

(0) ShareShare
ReportReport
Posted on by 222

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?

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @ACPBSCi 

    Could you provide a screenshot that illustrates your issue please?

  • ACPBSCi Profile Picture
    222 on at

    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.

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @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

  • ACPBSCi Profile Picture
    222 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard