Forum Discussion
gerotutu
3 years agoNew Member
How to skip the processing of a file when datasource.notfound in Power Query?
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 t...
gerotutu
3 years agoNew Member
Thanks lbendlin
Would you teach me how to do it?
I've been trying several ways, but I cannot find the way to write in the code, "if the folder is empty, use this empty table"
Cheers
- lbendlin3 years ago
Super User
Folder.Files() produces a lot of columns. Which of these do you need in the next steps?
Read about #table()