Forum Discussion

bidev's avatar
bidev
Frequent Visitor
10 years ago
Solved

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's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion

    bidev Check out this post which describes on writing IF ELSE statement in power query.

    • bidev's avatar
      bidev
      Frequent Visitor

      Thank you, ankitpatira.  Appreciate your help.