Power Query Forum - Filter with "Text.Contains"

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"

Answer 1

Hi @SSibbett

This works no problem here assuming the number of closing parentheses is OK:

 let  
     Source = Folder.Files("C:\File\Path\Location"),  
     #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx") and (Text.Contains([Name],"Data")))  
 in  
     #"Filtered Rows"  

Could you confirm and if this solves your problem please mark this reply as answer to help others with a similar issue - Thanks