cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshieboy
Helper V
Helper V

Multiply the value of two dropdown fields in PowerApps

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.

1 ACCEPTED SOLUTION

Accepted Solutions
BlessedCobba
Resolver III
Resolver III

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

View solution in original post

6 REPLIES 6
BlessedCobba
Resolver III
Resolver III

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
Skilled Sharer
Skilled Sharer

@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
Helper V
Helper V

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
Resolver III
Resolver III

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

joshieboy
Helper V
Helper V

Wow.  This works beautifully.  Thanks again.

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

 

  

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,856)