Sharepoint list button reference specific column from a lookup?
I have my main list, List 1, where everything happens and have json buttons on it. In this list, i have a column for "Area", that is a lookup type from List 2, where the title is the area name and the members column have all the people working in that area.
I want to make a button, in List 1, visible to only the people that work in the Compliance area, for example. Is it possible to reference a specific column from the title of the lookup column in JSON?
I tried using [$ColumnLookupArea.Members.email] == @me. But it doesnt work