V12 Data Factory how to Check File Exist or Not in a Folder Activities Get metadata and Set Var

Azure Data Factory -How to check File Exists or not in Azure Data Lake Store Folders using Activity get meta data and Set Variables .

How to Check if File Exists or Does not Exist in Blob Storage and Send Email in Azure Data Factory- ADF Tutorial , in this video we are going to learn How to Check if File Exists or Does not Exist in Blob Storage and Send Email in Azure Data Factory - ADF , Azure Data Factory Step by Step

Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial
Scenario-based training on Azure Data Factory

[rakeshmishra]

Hi There, nice video, but one question I'd like to ask: If the files available/exists in the source folder then the pipeline will execute as-usual but what if the files not available in the source folder, the pipeline should not fail rather making a dry run or blank execution (do nothing). Could you please show us the process with loading data into sql table.

[darkmatter]

Hi there, thank you for your precious help!
Would you know if is possible use this functionality applying regex on the path to get True if exists at least one file in the folder? Something like this:

>>> SOURCE/FOLDER/*.xlsx

I'm trying do this and its not working.
And when I have tryed do passing only tha path of the folder its returning True even thoug without the name of the file or having not de file in the folder.

[dharmveerchaudhary]

Pls give any idea, how to kill infinite loop created inside the until activity in azure data factory