Answered

Applying Color to Conditional Formatting from a List

(0) Share

Report

Posted on by CindyZ

I have a SharePoint list that populates some forms. I'd like label controls to change color when a an item is selected from a dropdown.

For instance, if I choose, Item B on my form, then I'd like a separate label control to change to RGBA(166,25,46,1); if I choose Item F, then I'd like it to change to RGBA(130,138,231,1), etc.

Can I do that from a list and if so, would you please provide me with an example formula.

Thank you.

Color Question.JPG

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@CindyZ

You may want to consider storing your colors as Hex values in the SharePoint list and using the Color Value function to display them. I wrote an article explaining how to do it which I’ll link to below:

Link to ColorValue vs RBGA function article:

https://matthewdevaney.com/whats-the-difference-between-these-powerapps-functions/

If you need more guidance I can follow up with additional instructions for conditional formatting later.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

CindyZ on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney Thanks so very much for both the help and the quick reply! I had no idea so I appreciate your pointing me to your article. I'll be reading it right away! Love the cat photo!!!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@CindyZ,
Based on the issue that you mentioned, do you want to color the Label based on Text string like RGBA(166,25,46,1)?
I have made a test on my side where there is no way to achieve this currently in the PowerApps.
We can easily substitute the RGBA Text string using the following formula:

LookUp(SPlist,Item=Dropdown1.Selected.Result,'Color RGBA')

However, it's Text value while the Fill property expects a Color value. Theoretically, we can translate this into a Color value. ColorValue() seems to work while it only supports CSS color name(e.g."RoxyBrown"), or a 6-digit hex value(e.g. "#ffd700"), or 8-digit hex value(e.g. "#ff7f5080").
You can click the article here for more details.
As an alternative solution, you can store the color as CSS Color Name, or a 6-digit hex value, or an 8-digit hex value, then you can refer to it in the ColorValue().
Best Regards,
Qi

Was this reply helpful? Yes No