Text.Contains with List Parameter

[donkey shrek]

I want to check if each column value contains a substring of each value in a list, and output "FOUND" if true.

Current Code:

= Table.AddColumn(#"Source", "TEST", each if Text.Contains([Email Domain], RandomList) = true then "Found" else "Invalid")

 

[RoryA]

I don't think that Text.Contains will work with a list (but I haven't tested). However you could, per your other question, use List.ContainsAny with a custom comparer function like this:

= Table.AddColumn(Source, "TEST", each if List.ContainsAny({[Email Domain]}, RandomList, (x, y)=>Text.Contains(x, y)) then "Found" else "Invalid")

 

[donkey shrek]

Thanks!