Highlight gallery if data appears in separate data source

[ckserra]

Hi everyone.

I have two data sources, GameLists and TTDDefects.  All my data pulls from GameList and any formdata submitted goes to TTDDefects.  I am trying to shade in an item in a  Gallery once the GameID number appears on both lists.  I have tried "If(ThisItem.GameID = TTDDefects.GameID,Red,Blue)" but get an error saying a number and table cannot be compared.  

Thanks in advance!

Chris

[gabibalaban · Accepted solution]

@ckserra ,

Try this approach:

If(
  IsBlank(LookUp(TTDDefects,GameID=ThisItem.GameID)),
  Red,
  Blue
)

Depends on number of items in Gallery, this approach can be a little bit slow.

Hope it helps !

[ckserra]

@gabibalaban Thats perfect, thank you very much!

Chris

[ckserra]

@gabibalaban Is there a way to have it do what you suggested and still be able to highlight if selected?  I use this "If(ThisItem.IsSelected , RGBA(233,150,122,1))" in another instance and it works well.

Thanks again!

Chris