Combine selective file from various folders

[Anonymous]

Need to select a xlsb file (name starts like yyyymmdd_report) from different folders with path reading like D:\daily updates\product n\yyyy\mm mmm\ The product name can be any text of 100+ counts and dd mm mmm yyyy denotes date formats. Any thoughts?

[Greg_Deckler]

So, Power Query is generally not a file search tool. Can you provide a little more background on this? What I would suggest would be to get all of the files into a single folder and then use a Folder query. But tough to really say. I suppose it would be possible to write an M function to do some file searching and if it finds a file, import it but that's really probably not the best use of Power Query.

[Mariusz · Accepted solution]

Hi @Anonymous 

A good start would be Get Data from a folder, as below

Later you can filter Folder Path column like below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn