If Substring from a List contains Subtring, return that item from the list

[Anonymous]

I have a column containing broken/good domains

I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]

[Anonymous]

It keeps giving this error. I always run into this field access issue in other projects too
I have tried assigning the column to a variable but to no avail.

= Table.AddColumn(Test, "Random", each let Column1 = [Column1] in List.Select(Column1,each List.Contains([Email Domain],_,(x,y)=>Text.Contains(y,x))))

Just to be clear [Column1] contains lists of the correct domains

Thanks 🙂

[wdx223_Daniel · Accepted solution]

= Table.AddColumn(Test, "Random", each List.Select([Column1],each List.Contains(TheTableNameWhichEmailDomainComesFrom[Email Domain],_,(x,y)=>Text.Contains(y,x))))

[wdx223_Daniel]

List.Select([Column1],each List.Contains([Email Domain],_,(x,y)=>Text.Contains(y,x)))