Conditional fill background on choice selection

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I am trying to set a background colour on either the entire row or the choice or just the choice selection but neither are working with the below code - any pointers to what I'm doing wrong?

If(
DataCardValue19.Selected.Value = "ANo! Product deemed to high a hazard! Use alternative product or method.",
Red,
DataCardValue19.Selected.Value = "Yes, Follow this COSHH assessment.",
Green,
White
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sudosaurus,

I think you have some small typos in your formula.

The first text begins with an A. And the second option ends with a dot. The text of your choice options looks different.

Can you try below and see if that works?

If( DataCardValue19.Selected.Value = "No! Product deemed to high a hazard! Use alternative product or method.", Red, DataCardValue19.Selected.Value = "Yes, Follow this COSHH assessment", Green, White )

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @Expiscornovus

Yes I noticed the typo with the "A" at the beginning. However then realised that I had put a "." at the end of one of my choice values in SP list. Which is likely why the formula wasnt working.

Works great now thanks! 😄

Was this reply helpful? Yes No