Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pmscorca
Post Prodigy
Post Prodigy

Adding a custom column to a copy activity

Hi,

is it possible to add a custom column to a copy activity?

I'd like to add a load date for each tables copied from a source to a destination, using the for each activity.

Any helps to me, please? Thanks

1 ACCEPTED SOLUTION

Hi,

I've solved specified this column and the related expression:

pmscorca_0-1719657363390.png

@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')


In the lakehouse the actual datetime column is created as a string/char type and not a date type.

View solution in original post

4 REPLIES 4
NandanHegde
Super User
Super User

yes, you can use system variables and Functions to map to the additional columns .

So in your case UTCNow() and format it as per your needs




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
NandanHegde
Super User
Super User

Similar to ADF, in data pipeline copy activity as well you can add additional column 

 

https://stackoverflow.com/questions/68407493/adding-a-dynamic-column-in-copy-activity-of-azure-data-...




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Hi, but how specifying the actual date in the highlighted box?

pmscorca_0-1719598404923.png

 

Hi,

I've solved specified this column and the related expression:

pmscorca_0-1719657363390.png

@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')


In the lakehouse the actual datetime column is created as a string/char type and not a date type.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

Top Solution Authors