Forum Discussion
Needing error handling for empty folder source
I have a queue folder with many subfolders for different queue data that I download Excel files every day. Each subfolder has a query made for it, and my end result is an append of all the final tabl...
let
Source= Folder.Files ("S:\My Folder\Queue\Subfolders"),
Navigation1 = if Table.CountRows(Source)>0 then Source{0}[Content] else <fake empty table with a [Content] column that you prepared before>
in
Navigation1
This sort of worked but now my Transform Parameter is bugging out because dummies me said they were Excel files and they are CSV files.
Please provide sample data that fully covers your issue.
