list to filter column using Text.Contains function

Thanks HotChilli, my M knowledge is too simple so I didn't realize that I didn't even pick the correct function.  I'm trying to understand just one of the functions in your solution.  What are the arguments in Text.Contains?

Anonymous, list-to-filter-column-using-Text-Contains-function.pbix is correct.  Although I don't understand the variables in your functions, I'm trying to recreate your functions.  There's no parameter in your file when opened with PQ.  When I right-click on the list and select "create function" in the Queries pane, the list and the created function are moved to another folder.  Am I recreating your function in the right way?  Thanks!

Thanks Anonymous, your functions work but extremely slow.  So I'm hoping for a faster solution.

HotChilli, the data source is on the web.  I've inserted the "not" operator into your solution.  By doing so, I've inverted the filter logic to be: "not" and "contains any" (including partial matches of the items in the 'searchfor' list.  The filter logic is the last transformation step ("Custom1") in the following M code:

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://s3.amazonaws.com/dl.ncsbe.gov/ENRS/2020_11_03/results_precinct_sort/STATEWIDE_PRECINCT_SORT.txt"), null, null, 1252)}),
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter("#(tab)", QuoteStyle.Csv), {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5", "Column1.6", "Column1.7", "Column1.8", "Column1.9", "Column1.10", "Column1.11", "Column1.12", "Column1.13", "Column1.14", "Column1.15", "Column1.16", "Column1.17", "Column1.18", "Column1.19"}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Split Column by Delimiter", [PromoteAllScalars=true]),
    #"Filtered Rows" = Table.SelectRows(#"Promoted Headers", each [county] = "BERTIE" or [county] = "DURHAM" or [county] = "MARTIN" or [county] = "NEW HANOVER" or [county] = "NORTHAMPTON" or [county] = "PITT" or [county] = "STOKES" or [county] = "SURRY" or [county] = "TYRRELL" or [county] = "WILKES"),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"precinct_code"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns"),
    Custom1 = Table.SelectRows(#"Removed Duplicates", (x) => List.AnyTrue(List.Transform(searchfor, each not Text.Contains(x[precinct_code], _))))
in
    Custom1

The 'searchfor' list (item 'PROVI ' has a trailing space character) is:

However, it's not correctly filtering out the partial matches below:

precinct_code

These partial matches would also result if I were to delete the "not" operator from the last transformation step.  So why isn't the "not" operator working in the last transformation step?  Thanks (and same thanks if AlexisOlson can troubleshoot)!

Ok @HotChili, I'm deleting the "Custom1" step.  Then I'm adding a custom column with the step:

= Table.AddColumn(#"Removed Duplicates", "Custom", each (x) => List.AnyTrue(List.Transform(searchfor, each Text.Contains(x[precinct_code], _))))

This step creates a column with "function" as values.  However, the custom column's format type won't let me change to "True/False".  So I can't filter the column at all.