Forum Discussion
bidev
10 years agoFrequent Visitor
How to check if a file exists
I have a code that looks the file exists or not before doing further processing. Result of "try Source" evaluation, Test[HasError] in if statement returns "False" always, whether or not there was a file "MyLog.log" in the path "C:\Log-Files\Empty-LogFolder\".
Appreciate if you can shed some light on it. Code below. Thank you.
***********************************
let
File_Path = "C:\Log-Files\Empty-LogFolder\MyLog.log",
Source = Csv.Document(File.Contents(File_Path),[Delimiter=";", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]),
Test = try Source,
Output = if Test[HasError] then "True" else "False"
in
Output
3 Replies
- ankitpatira
Community Champion
- bidevFrequent Visitor
Thank you, ankitpatira. Appreciate your help.
- Syndicate_Admin
Administrator
HI,
The link is 404. Is there a link on microsoft ?