Check to see if sheet exists before Power Query consolidation

[Richynero]

Hi there

I have about 40 files that I need to append through Power Query. In my model the user selects a month and then the sheet with that month name is consolidated. It works great until someone uploads a file that doesn't have any sheets with that month name. How can I get power query to check if a sheet exists before trying to consolidate it? I know I can do this in VBA quite easily but I am trying to run with a Power Query only solution.

Thanks

Richard

 

[sandy666]

maybe

From Folder
Filter by month
Append (Combine)