I have a table of Bands. I also have a table of “Connections”, which basically is a table of associated contacts for specific bands. The connection references the band name.
I am making an action under the Bands to add a ‘Connection’. I would like this action to ONLY appear on Bands where the Band name appears under the “Affiliation” column in the 'Connections table.
Currently I have
IN(Bands[Band Name],Connections[Affiliation]) But for some reason the expression is valid… seems to make sense… doesn’t do what I want it to… Just shows nothing.
I’ve tried Bands[Band Name]=ANY(Connections[Affiliation]) But I get cannot compare list with name (because Affiliation is a reference to Band Name and as such is a list)
What am I missing here? How can I solve this issue with my logic lol
Thanks everyone for your time!