If List 1 match with any in List 2 then true

[mduntley]

Below is my M code, I am trying to add a column to show if List 1 match with anything in list 2. I am expecting the first line to be true and the last 2 to be false

let
    Cities = Table.FromRows({{"New York", "Los Angeles", "Chicago", "Red", "Orange", "Yellow", "New York"},
                             {"Miami", "Houston", "Dallas", "Blue", "Purple", "Pink", "Brown"},
                             {"Phoenix", "Philadelphia", "San Antonio", "Black", "White", "Gray", "Turquoise"}}),
    #"Added Custom" = Table.AddColumn(Cities, "Custom", each {[Column1],[Column2],[Column3]}),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each {[Column4],[Column5],[Column6],[Column7]}),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom1",{"Custom", "Custom.1"})
in
    #"Removed Other Columns"

 

[JGordon11]

let
    Cities = Table.FromRows({{{"New York", "Los Angeles", "Chicago"}, {"Red", "Orange", "Yellow", "New York"}},
                             {{"Miami", "Houston", "Dallas"}, {"Blue", "Purple", "Pink", "Brown"}},
                             {{"Phoenix", "Philadelphia", "San Antonio"}, {"Black", "White", "Gray", "Turquoise"}}}),
    Result = Table.AddColumn(Cities, "AnyMatch?", each List.ContainsAny([Column1],[Column2]))
in
    Result