web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Label Colours Based on...

Power Apps

Answered

Label Colours Based on the Number

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have an app in which the user inputs a number, then when this is dragged through into a gallery on a label as ThisItem.Number.

I want the colour of the label to change based on the number inside it. Below is the colours I want it to go to:

So 16.85% or below would turn red (Min NO GO)

16.86%-17.15% would be yellow (Green Lower Control)

17.50% would be green

17.51% - 17.84% would be yellow

18.14% and above would be red

Thanks for any help in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

For your label Color, below can be the formula:
If( ThisItem.Number <= 16.85, Color.Red, If( ThisItem.Number >= 16.86 && ThisItem.Number <= 17.15, Color.Yellow, If( ThisItem.Number = 17.50, Color.Green, If( ThisItem.Number >= 17.51 && ThisItem.Number <= 17.84, Color.Yellow, Color.Red ) ) ) )

Does this help?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ethan_R ,

Yes Ive just tried this code and seems to be working perfectly, thank you.

Join the conversation