Power Query - List Contains

[gheyman]

I know you can use the following formula to filter to a List.

= Table.SelectRows(#"Renamed Columns", each List.Contains(SearchItem_UTable,[PartNumber]) or List.NonNullCount(SearchItem_UTable)=0)

My List is named: SearchItem_UTable

Is there a way to filter if the column "contains" the data within it?

If my "List" value is 1026170-101 and for example one of the rows has a value of:

1026170-101, 1026156-101, 1027772-101, 1028239-101 (please note these part numbers could be subject to change based on LRIP changes)

Is there a way to do this? But I want use my "List" as the filter source

Thanks

 

[RoryA]

You can supply a comparer function, so:

= Table.SelectRows(#"Renamed Columns", each List.Contains(SearchItem_UTable,[PartNumber],(x as text, y as text)=>Text.Contains(x, y)) or List.NonNullCount(SearchItem_UTable)=0)

 

[gheyman]

Thank You! Happy Holidays Rory!

 

[RoryA]

Glad to help, and merry Christmas!