Label Colour if Blank

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I think this is a simple one but can't figure it out.

I have a Label in a gallery showing the Weight, using the code ThisItem.'Final Dryer Cleaning Waste'.

Then depending on that number, I am changing the Fill Colour of the label using the code below:

If(
 Value(Self.Text) < 300,
 Color.LimeGreen,
 Value(Self.Text) < 351,
 Color.Orange,
 Color.Red
)

However, when the Label is blank because no Weight has been submitted, the Label is Lime Green as it is following the code above (less than 300). But I just want the Label to be white if it is blank, or even better if it could say 'No Weight Submitted' when it is blank.

Any help is much appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

On the Fill property of the Label, try:

If( Len(ThisItem.'Final Dryer Cleaning Waste') = 0, Color.White, If( Value(Self.Text) < 300, Color.LimeGreen, Value(Self.Text) < 351, Color.Orange, Color.Red ) )

On the Text property, try:

If( Len(ThisItem.'Final Dryer Cleaning Waste') = 0, "No Weight Submitted", Text(ThisItem.'Final Dryer Cleaning Waste') )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Amik ,

That works absolutely perfectly!

Was this reply helpful? Yes No