How to skip the process of a file when datasource.notfound in Power Query?

[gerotutu]

Power Query takes from a cell the path it should go for the source files.

I want to handle the situation when there are no files in that folder or when there isn't any text in the cell referring to the path.

I tried, among many other things, the functions try... otherwise without any success.

This is how my code starts:

let
DataAcesPath = Excel.CurrentWorkbook(){[Name="DataAcesPath"]}[Content][Column1]{0},
Origen = Folder.Files(DataAcesPath) ,
#"Archivos ocultos filtrados1" = Table.SelectRows(Origen, each [Attributes]?[Hidden]? <> true),

Many many thanks for your support,
Geronimo

 

[GraH - Guido]

What needs to be done when the error occurs?
- Still loading the previous result (which I believe is not overwritten when the error occurs)
- Loading a message in a table stating there were no files to treat
- Something else?

 

[gerotutu]

Thanks for your answer! I didn't write it down in the body of this thread.

I want to just simply skip the steps set to that path/folder (or cheat them with an empty table) so it can continue with the following folders.

 

[GraH - Guido]

You can go with if Table.IsEmpty(Origen ) then #table({}, {}) else Origen