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)
I have no idea if the equation in your formula is correct, but if it is, try
ThisItem.'Contact Match' = 'Contact Match (Mailing List Contacts)'
If you want to test for a contact that is in your mailing list, you may have to use
!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.
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.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!