If List 1 match with any in List 2 then true

[Zorgmed]

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"

[AlB · Accepted solution]

Hi @Zorgmed 

List.Intersect comes in handy here.  I've only added the last step to your code:

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"}),

    NewColumn = Table.AddColumn(#"Removed Other Columns", "Result", each List.Count(List.Intersect({[Custom], [Custom.1]}))>0, type logical)
in
    NewColumn

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.