How to express wildcard character(s) in Azure Logic Apps

Question

I have following file name in Azure File Storage:

I was trying to use following Expression to grab today's file in Azure Data Factory:

But, somehow, I am getting error saying it would not recognize the file:

I am wondering how to express wildcard character here.

BTW, the files are in Azure Blob Storage. I am not sure that makes anything different from files in Azure File Storage.

Thanks.

Answer 1

Hello @King Java,

I have reproduced the above scenario and got the similar error.

The above kind of error occurs when you gave wrong folder name. Please cross-check your folder path in the dataset.

I am wondering how to express wildcard character here.

ADF does support the Dynamic expressions in the wild card file path in the copy activity and lookup activity.

Here is how you can do it.

These are my sample files in File storage similar to you.

In the dataset, select till the file storage name.

For copy or lookup activity, you can select the wild card file path and give your expression in the file name. And give your folder name if you need.

For sample, I have used lookup activity.

@concat('Allision_',formatdatetime(adddays(utcnow(),0),'yyyy-MM-dd'),'*','.csv')

After the execution of the pipeline, it will extract the data of all the files which have the file name starts with Allision_<yyyy-MM-dd>*.csv.

You can confirm the generated wildcard file in the input of the activity.

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.