Answered

Conditional Fill Formatting of TextBox Dependant on Input

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I think this will be an easy fix just unsure how to do it.

I have an app in which users input a number into a textbox, I have coded the Fill Button of the TextInput so that it changes colour depending on the value inputted, my code is below:

My issue is that when the TextInput is blank, it is filled Red as the code is saying Fill Red if less than 16.85. I want the TextInput to just be white if it is blank. How can I do this whilst maintaining my current code?

If(
 Value(TextInput_Tempering_Bin_Rear.Text) <=16.85,
 Color.Red,
 If(
 Value(TextInput_Tempering_Bin_Rear.Text) >=16.86 && Value(TextInput_Tempering_Bin_Rear.Text) <=17.15,
 Color.Yellow,
 If(
 Value(TextInput_Tempering_Bin_Rear.Text) = 17.50,
 Color.Green,
 If(
 Value(TextInput_Tempering_Bin_Rear.Text) >=17.51 && Value(TextInput_Tempering_Bin_Rear.Text) <=17.84,
 Color.Yellow,
 Color.Red
 )
 )
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Is this what you want?
If( IsBlank(Self.Text), Color.White, If( Value(Self.Text) <=16.85, Color.Red, If( Value(Self.Text) >=16.86 && Value(Self.Text) <=17.15, Color.Yellow, If( Value(Self.Text) = 17.50, Color.Green, If( Value(Self.Text) >=17.51 && Value(Self.Text) <=17.84, Color.Yellow, Color.Red ) ) ) ) )

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, yes that works perfectly thank you.
I also have another screen which shows this uploaded data (like a viewer), this has the same issue as my textinput, except this time the code I am using is: How would I solve this?
If( ThisItem.'Tempering Bin Rear (MT2101)' <=16.85, Color.Red, If( ThisItem.'Tempering Bin Rear (MT2101)' >=16.86 && ThisItem.'Tempering Bin Rear (MT2101)' <=17.15, Color.Yellow, If( ThisItem.'Tempering Bin Rear (MT2101)' = 17.50, Color.Green, If( ThisItem.'Tempering Bin Rear (MT2101)' >=17.51 && ThisItem.'Tempering Bin Rear (MT2101)' <=17.84, Color.Yellow, Color.Red ) ) ) )

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

You need to add Value()
Value(ThisItem.'Tempering Bin Rear (MT2101)')

Hope this helps

Was this reply helpful? Yes No