Issue with Conditional Formatting

(0) Share

Report

Posted on by Georgetown15x

Dear All,

I am total dummy with no programming background, your insights or solutions for the question below is highly appreciated.

First, I have a table called - movement

Name (Type=Text)	Notes (Type=Text)	Online (Type= Yes/No)
ABC	Desk	Online
XYZ	Rest	Offline

What I am trying to do is make the rectangle fill colour change to black when is Offline.

So I've put in the function below in the rectangle's fill column

If(ThisItem.IsSelected, RGBA(0,0,0,0.1), If(ThisItem.Online="Offline",Black,RGBA(0,0,0,0)))

And it seems the function is not right...Could someone please help? Thanks.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

GarethPrisk 2,828 on at

Like
a
(1)

Report
Copy link

Link copied!
You mentioned Online was a Yes/No, or Boolean field - correct?

If(ThisItem.IsSelected, RGBA(0,0,0,0.1), If(ThisItem.Online,Black,RGBA(0,0,0,0)))

If the field is a Yes/No (Boolean, with a True/False as its actual value), then you can check it explicitly.
Georgetown15x 61 on at

Like
a
(0)

Report
Copy link

Link copied!

You are Legend!