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. The goal is to skip the following steps (or cheat the next steps with an empty table).
I tried, among many things, the functions try... otherwise without success.
This is how my code starts:
Could you please help me out with this?
Many many thanks for your support,
Geronimo
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. The goal is to skip the following steps (or cheat the next steps with an empty table).
I tried, among many things, the functions try... otherwise without success.
This is how my code starts:
Power Query:
let
DataAcesPath = Excel.CurrentWorkbook(){[Name="DataAcesPath"]}[Content][Column1]{0},
Origen = Folder.Files(DataAcesPath) ,
#"Archivos ocultos filtrados1" = Table.SelectRows(Origen, each [Attributes]?[Hidden]? <> true),
Could you please help me out with this?
Many many thanks for your support,
Geronimo