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...
lbendlin
Super User
Super Userlet
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