cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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
Helper I
Helper I

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
Helper I
Helper I

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)

 

 

Resolver I
Resolver I

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

New Member

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.  

 

Helper I
Helper I

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

View solution in original post

New Member

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (65,010)