select items of a list if contains at least one of the string from a list of target strings

[MrDeg]

I’m trying to create a function that, given a list of string to check (ListToCheck) and a list of target strings (ListTargetStrings), check if the strings to check contain at least one of target Strings.

E.g.:

ListToCheck =

{

“FinancialPart_1”,

”AdditionalFinancialPart”,

”CapexPart”,

”AdditionalValues”,

”SavingsThisYear”,

”CurrentYearSavings”,

”SavingsNextYear”

}

ListTargetStrings =

{

“FinancialPart”,

”Savings”

}

Expected Output =

{

“FinancialPart_1”,

”AdditionalFinancialPart”,

”SavingsThisYear”,

”CurrentYearSavings”,

”SavingsNextYear”

}

Thank you in advance for your help.

[AlB · Accepted solution]

Hi @MrDeg 

(inputList as list) =>   
let 
    ListTargetStrings_ = {"FinancialPart","Savings"},
    output_ = List.Select(inputList,
                          each List.Accumulate(ListTargetStrings_, false, (state, current) => state or Text.Contains(_, current) ))
in
    output_

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.