Request for Assistance: Alteryx Workflow to Check Accessibility of Multiple Excel Files and Send Not

Question

H

File1.xlsx

File3.xlsx

File2.xlsx

i Alteryx Community,

I hope everyone is doing well.

I am working on an Alteryx workflow that needs to check the accessibility of three Excel files before proceeding with further processing. Need to know if the file or files are lock or someone is using the file. My goal is for the workflow to send an email notification in both scenarios:

* If all files are accessible
* If any file is locked or inaccessible

Here are the files I need to check:

* File1.xlsx
* File2.xlsx
* File3.xlsx

Could you please assist me with the best approach or provide a sample workflow for this setup? I’d appreciate any guidance, best practices, or examples you can share.

Thank you very much for your help!

Kamen

KamenRider · Answer

Thanks @Qui for the response. Unfortunately, we need an Alteryx solution. Any help and assistance from others @binu_acs  @atcodedog05 @apathetichell @MarqueeCrew . Hope to hear from you guys

Kamen

Qiu · Answer

@KamenRider

Thank you for the request but I am sorry that I only know one Function "FileExists" that can return if the predefined file with full path is existing or not.

For other information, I think maybe PowerShell Script can help, but I dont about details about PowerShell.

KamenRider · Answer

Thanks @OTrieger. I do hope others can help me. @Qiu @binu_acs @atcodedog05