Multiply the value of two dropdown fields in PowerApps

[joshieboy]

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.

[BlessedCobba]

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]

@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]

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.  

[BlessedCobba · Accepted solution]

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

[joshieboy]

Wow.  This works beautifully.  Thanks again.

[AsanKani]

@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...