Not all files contains the sheet selected when Transformed and it's giving error

Hi dp1900,

Technically, there is a flag on the import wizard form (bottom-lef corner):

It generates a code to skip files with errors (including missing tabs) by adding something like this:

= Table.RemoveRowsWithErrors(#"Removed Other Columns1", {"Transform File"})

Or you can transform the helper function to something like this, if you want to have more control (e.g. conditionally substitute tab names orsomething alike):

let
    Source = Excel.Workbook(Parameter1, null, true),
    Check = List.Contains(Source[Name], "P&L")
in
    if Check then Source{[Item="P&L",Kind="Sheet"]}[Data] else #table({},{})

Cheers,

John