Forum Discussion

Son_Of_William's avatar
Son_Of_William
Frequent Visitor
3 years ago
Solved

How to select mutiple items from a List

Hi there,    I am trying to narrow down a list using a couple of criteria using Text. Contains I have used the below formula but no luck so far             = List.Select(Custom2, each Text.Contai...
  • AlienSx's avatar
    3 years ago

    Hi, replace comma with space over here

     

    "Project"),and

     

    as an option consider this line of code

    = List.Select(Source, (x) => List.Contains({"Books", "Project"}, x, (w, z) => Text.Contains(z, w)))