Filter rows by CONTAIN criteria from a list (AND)

Hi imnotabot01001 

Download sample Excel file with query

Here's the code:

let
    Source = Excel.CurrentWorkbook(){[Name="TextTable"]}[Content],
    Result = Table.AddColumn(Source, "Check", 
    
        (FindStrings) => 
        
        List.AllTrue(List.Transform(WordList, each Text.Contains((FindStrings[Product_Name]), _ )))),
    #"Filtered Rows" = Table.SelectRows(Result, each ([Check] = true)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Check"})

in
    #"Removed Columns"

If you want to do further reading/see more examples of this kind of thing check here

Searching for Text Strings in Power Query • My Online Training Hub

regards

Phil