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...
Omid_Motamedise
Super User
Super UserUse this one
let
Source= Folder.Files ("S:\My Folder\Queue\Subfolders"),
Navigation1 = try Source {0}[Content] otherwise null
in
Navigation1- lbendlin
You cannot append null to a table. Needs to be an empty table.
Table:
= #table({"Column1","Column2"},{{"Q","A"}})
Table2:
= #table({"Column1","Column2"},{})
