Hi guys,
I have a icon control within a gallery that I would like to LookUp() to another data source. The 2nd data source "GS_Briefcase", has a column called "Email". If the result matches, the color of the icon should apply purple, if not result found, apply black.
Below is the filter query
If(
!IsBlank(
LookUp(
GS_Briefcase,
Email = User().Email
)
),
Color.Purple,
Color.Black
)
However, in the gallery, all of the icon control color got changed to purple if a single result matches.
So I am expecting the star icon highlighted in GREEN to be purple, and the one highlighted in RED, to be black because the Email column does not contain my email.
Am I doing something wrong here?