Connecting to Folder but filtering by file name

[dancarr22]

Hello,

We are conecting to a folder which has multiple files -- basically 3 different file formats.  Is there a way when we connect to the folder -- maybe going into 'Advanced' where it shows it in M code -- and filtering by specific file names?  i.e. We have file names "Positions", "Transactions" and "Returns" all in the same folder.  Only want to view where file names begin with 'Position' or end with .xls -- like filtering positions* or *.xls.

Thanks!

Dan

[v-yuezhe-msft]

@dancarr22,

Change the code in your Advance Editor to the following:

let
    Source = Folder.Files("YouPath\folder"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xls"))
in
    #"Filtered Rows"

Then in Query Editor you are able to view only those files with .xls in Query Editor, there is an example for your reference.

Regards,

[dancarr22]

Thanks!  This is great -- answer 90% of my question.

One follow-up then will close this: how would I filter by file name instead of file extension -- i.e. All files that begin with or contain '%Equity%'.

Thanks for your assistance with this -- greatly appreciated.

[v-yuezhe-msft · Accepted solution]

@dancarr22,

Add a custom column in Query Editor using the following formula, then filter the custom column to "Yes".

if Text.Contains([Name], "Equity") then "Yes" else "No"

You can review the example below.

Regards,