locked
Power Query Forum - Filter with "Text.Contains" RRS feed

  • Question

  • Hello,

    I am trying to filter out other files that will have random names and only focus on the files that have "Data" in their file name. I though the way to do this is by naming the files and say in Power Query the "Text.Contains". I feel like this should work because the filter is just a list of true and false, but this logic does not work on the row "Filtered Rows"

    let

        Source = Folder.Files("C:\File\Path\Location"),

        #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx") and (Text.Contains([Name],"Data") )

    in

        #"Filtered Rows"

    Wednesday, December 2, 2020 4:52 PM

Answers