Hi Anvy Elizabeth ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As per my understanding , you are trying to concatenate the sink filename with date as a postfix along with the extension. Please let me know if that is not what you are looking for .
I tried using fileExtension option to create the postfix to store date with the extension for the sink file. It worked for a file but didn't for another. Assuming the requirement is to append current date at the end of the filename, I added dynamic content in file extension as below expression:
@concat(formatDateTime(utcnow(),'yyyy-MM-dd'),'.csv')
Although it works , but the file extension is meant to detect the output file name and the expected values are '.csv','.txt' etc. I would recommend you to use filename option in the sink dataset to create the dynamic filenames.
For more details on the implementation, kindly checkout this video: How to provide dynamic name to the target file based on pipelinerundate In azure data factory
Hope it helps. Kindly accept the answer by clicking the Accept answer
button. Thankyou.