locked
ADF V2 Add Dynamic Content - Format the For Each Loop Item Value in Copy Activity File Path Dynamic Content RRS feed

  • Question

  • The below function not working, I tried various options.. Can any one help..

    concat(@{formatDateTime(@{item().FileDate},'dd')} ,'.csv')

    Here FileDate is String with the format of 01/01/2016 9:06 AM

    I am passing the For Each Loop Item Value to Copy activity Dynamic Content and formatting the date and do the String Concatenation. 

    The below are working , but when i frame the full string, its not working.

    @{item().FileDate}

    @{formatDateTime('01/01/2016 9:06 AM','dd') }

    @{concat('01','.csv')}



    Liyasker Samraj K

    Sunday, November 3, 2019 2:26 PM

Answers

  • Hi Liyasker,

    The expression should be :

    @concat(formatDateTime(item().FileDate, 'dd'), '.csv')

    Hope this helps.

    Monday, November 4, 2019 6:33 AM