I tried to trap like below, but not working. Run time error still produced. Any help would be appreciated. Thank you.
Source = Try Folder.Files("C:\nodirectory"),
output = if Source[HasError] then "Error" else "Good"
Solved! Go to Solution.
@bidev,
Please use the following code .
let FolderPath = "C:\nodirectory", Test = try List.Count(Folder.Files(FolderPath)[Content]), Source = if Test[HasError] then "Cannot find Data Source" else Folder.Files(FolderPath) in Source
Regards,
Lydia
@bidev,
Please use the following code .
let FolderPath = "C:\nodirectory", Test = try List.Count(Folder.Files(FolderPath)[Content]), Source = if Test[HasError] then "Cannot find Data Source" else Folder.Files(FolderPath) in Source
Regards,
Lydia
Lydia,
Thank you very much for the solution. It works perfectly!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
441 | |
196 | |
109 | |
56 | |
49 |
User | Count |
---|---|
477 | |
238 | |
134 | |
75 | |
74 |