Multiply the value of two dropdown fields in PowerApps

(0) Share

Report

Posted on by joshieboy

519

Hello,

I have two dropdown fields in PowerApps each pulling from a SharePoint list. Both dropdowns store values 1-5 and I want if a user selects a value in dropdown 1 and another in dropdown 2, that a third field (text field) shows those values multiplied - so if a user selects 3 and then 5, the value of the third field will be 15.

Further to this, I would like for that field to be color coded such that if a value is between 1and 6, its green, if its 8-12 its yellow, 15-16 is orange and 20-25 is Red. These are the only combinations. Any feedback on how to achieve this appreciated.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

BlessedCobba 459 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Something like this for the text label

Text(Dropdown1.Selected.Value*Dropdown2.Selected.Value)

Conditional color formatting i've never tried but it would be some form of if statement in the colour property of the field (Updated, Thanks Asan)

If( Value(TextLabel.text) <= 6, Color, Value(TextLabel.text) <= 12, Color, Value(TextLabel.text) <= 16, Color, Value(TextLabel.text) <= 25, Color)
AsanKani 710 on at

Like
a
(1)

Report
Copy link

Link copied!
@BlessedCobba .. You are said right.. but one small modification required in your formula..
This is right..
Text(Dropdown1.Selected.Value*Dropdown2.Selected.Value)
@joshieboy Need to modified below formula then it will be work.. what every your required value & color you can choose...
If( Value(TextLabel.Text) <= 6, Color, Value(TextLabel.Text) <= 12, Color, Value(TextLabel.Text) <= 16, Color, Value(TextLabel.Text) <= 25, Color)
Did this post solve your problem? Please click Accept as Solution so that others may find it more quickly.
If you liked my response, please give it a Thumbs Up.
joshieboy 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for the prompt feedback. I did the first piece with the multiplication and it works well. I just had to change .Value to .Result. For the color coding, what property am I setting this on, as the formula for multiplication is set on Default.
Verified answer

BlessedCobba 459 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Depends on which part you wish to colour but if its the background then should be the Fill property
joshieboy 519 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow. This works beautifully. Thanks again.
AsanKani 710 on at

Like
a
(1)

Report
Copy link

Link copied!

@joshieboy Property Name : Color in which tool used like Label or textinput box used formulae... simply color used text like Red, Green, Blue or you can use RTGB(255,255,0,1) like...