This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 51%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
I am creating a pipeline activity where Get Metadata checks for the file in a folder and if it exists then it should trigger a dataflow, else stop the activity and not execute the dataflow.
Any suggestions how to do it
So far i have done like below. Check for the file and pass to a If Condition and if TRUE execute Dataflow. The problem is if FALSE (fileNotExists) is getting captured in the variable but activity is not stopping. Also how to get the rowsWritten from the dataflow and pass that to another if condition outside?
How to put *.parquet in the highlighted filleName parameter field so Get Metadata can look for all parquet files and pass exists true or false?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Hi Arun,
We can't use wild card in get meta data activity. It looks for specific file and returns true or false for exists. That is why we recommended the approach using filter below.
Thanks
Suba
Hi Kumar, Arun ,
Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.
Please feel free to click Yes for Was the answer helpful survey
Have a good day!
Regards,
AnnuKumari-MSFT
Hi @Kumar, Arun
please check this video to stop the pipeline when no file found https://youtu.be/ISc0-TiU-do
Hope this helps. Pl let us know otherwise, if you have further questions.
Thanks
Suba
@Subashri Vasdudevan Saw that video but it works only if i know the file name. In my case the file name is not fixed as we are generating parquet files. Also i need to stop the pipeline gracefully and not fail.
Hey, the approach in video doesn't look for any specific file. Instead of test.* In the expression in filter activity you can mention . parquet. It will look for parquet files and give the matched count. And if you don't want to fail the pipeline, simply don't use any activity inside false part of if condition. In true part you can have all logic to process the file. Hope this helps.
Thanks Subashri, your video helped. I couldn't exactly use what is provided in the video, but i tweaked and customized the design and fixed the issue.
Hey Arun,
Please put the rest of the pipeline activities in the True Part of the If condition. This will ensure that the rest of the activities will only execute if the condition is True.
To get the RowsWritten from the dataflow and pass that to another activity, please refer to the following thread:
Please don't forget to click on 
if you find this helpful.
Thanks @vedant desai i did a detailed testing and seems like Get Metadata for file exists is not checking working correctly. In our case all are parquet files, there are no set names to pick. Is there a way GET Metadata can pickup based on wildcards?