web

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

News and Announcements icon

Power Platform CommunityForums Power Apps CDS optionset

Power Apps

Unanswered

CDS optionset

(0) Share

Report

Report

Posted on by A Wennerwik

144

Hi, I'm trying to set the fill property based on an items optionset value, and can't get it to work.

Is there a secret to doing this? I thought this would be straightforward, but it's proving to be nothing but that.

If(ThisItem.'Contact Match' = 'Contact Match (Mailing List Contacts)'.Yes,Color.Red,Color.Blue)

Any ideas?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @McMonty

I have no idea if the equation in your formula is correct, but if it is, try

If( !IsBlank( ThisItem.'Contact Match' = 'Contact Match (Mailing List Contacts)' ), Red, Blue )

If you want to test for a contact that is in your mailing list, you may have to use

If( !IsBlank(Lookup(ContactList, ContactName=ThisItem.ContactName),Red, Blue )

As the equation to test where the you are looking to establish membership of a ContactName in a table of contacts. You would replace ContactList and ContactName with the actual table and field names.
A Wennerwik 144 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, managed to fix it. The syntax was correct, but the app only accepted it after I saved, closed and reopened again. Haven't seen that before.

Join the conversation