File not found handler

Hi bidev,

Based on test, I can achieve your requirement, perhaps you could refer to below code:

let

    Path = "C:\Users\xxxxx\Desktop\audit.csv",

    Result = try Binary.ToText(File.Contents(Path)),

    Output =if Logical.From(Result[HasError]) then "not exist" else "exist"

in

Output

Screenshots.

Exist:

Not exist:

Descript:

Path = "C:\Users\xxxxx\Desktop\audit.csv", // the file path.

File.Contents(Path) // get the file from specify path and convert it to binary.

Binary.ToText(), // convert binary format to text.

Try //catch the error , if the action has error, it means the file doesn’t exist.

Output =if Logical.From(Result[HasError]) then "not exist" else "exist" //use if to format the result to text.

Reference:

Binary.ToText

File.Contents

Logical.From

Regards,

Xiaoxin Sheng