Answered

Color Code a Person field set to "Pending"

(0) Share

Report

Posted on by tagustin2020

Hello,

I have a gallery with a Mechanical Engineer column which is a person field. If an ME hasn't been assigned yet, the column is set to Pending as per this Text formula:

With({dn:Match(ThisItem.'ME Assigned'.DisplayName, "^.*\s.").FullMatch},
If(IsBlank(dn), "pending", dn & "."))

I would like to set any Pending items to Red so they stand out more as an item that needs to be addressed. Can someone help me figure out how to set the Color property to achieve this? Thank you, Teresa

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@tagustin2020

Are you trying to set the label as red or the entire row? Also, are you trying to Fill the color or just change the Text color?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@tagustin2020

Just to cut to the chase on some of this...

Set your appropriate property to the following:

If you want the label to be filled with Red, then put this in your Fill Property:

  If(Self.Text = "pending", Red, Transparent)

If you want the label to be the color, then put this in your Color Property:

  If(Self.Text = "pending", Red, Black)

If you want the Row to be filled with Red, then put this in your TemplateFill Property of the Gallery:

  If(yourMELabelName.Text = "pending", Red, Transparent)

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes

Thank you Randy. I appreciate you providing solutions for all 3 scenarios. I applied the one to change the color of the text and it worked perfectly!

Kind regards,
Teresa

Was this reply helpful? Yes No