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.

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

King Java 690

I have following file name in Azure File Storage:

User's image

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

User's image

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

User's image

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.

J N S S Kasyap 865 Reputation points Microsoft External Staff

2025-03-11T23:52:42.8833333+00:00

Hi @King Java

ADF only supports wildcards in the Copy Activity’s Source under "Wildcard file path", not in dynamic expressions. Your dataset is trying to look for a file exactly named Allision_2025-03-10*.csv, which does not exist.

Please help me with questions below
What ADF activity are you using Copy, Get Metadata, Lookup, or something else?
If you are using Copy acvitivity,Are you using the "Wildcard file path" option in the Copy Activity?
Where are these files stored inside a subfolder or the root of the Blob container?

Hope this helps. Do let us know the answers for the above questions to help further

If this answers your query, do click Accept Answer and Yes for was this answer helpful.
King Java 690 Reputation points

2025-03-12T17:52:48.64+00:00

@Anonymous Thank you. I was able to resolve the issue. Please let me know if you want your feedback to be marked as "Answer".