I'm trying to change the color of an icon based on whether or not another related record exists.
My app has Suppliers and Supplier Quality Documents. A Supplier Quality Document name is based on the Supplier Number and Type of Document, the format being "(SupplierNumber) - (type of document), ie SUPP-0022 - ISO9001. DataCardValue23 is the supplier number; DataCardKey64 is the type of document. My formula is below, I've confirmed the LookUp function is correctly pulling the record and returning the name by printing it out to a label. Not sure why my If statement is always providing false though.
If( LookUp('Supplier Quality Documents',
(DataCardValue23.Text & " - " & DataCardKey64.Text) in Name, Name)
in (DataCardValue23.Text & " - " & DataCardKey64.Text), Green, Red )