Hi @Lokesh Rajpoot ,
Thank you for posting query in Microsoft Q&A Platform.
When we click on preview button from source tab of Copy activity, then its actually a schema operation to consider additional column as well to show in preview. And at this moment the function which you used
@convertFromUtc
not supports schema operations. Hence you are seeing that error.
But still when we run the pipeline in debug mode or trigger more additional column data will get correctly in sink location. If your intention is only to take date in format yyyy-MM-dd
then you can consider using expressions as @formatDateTime(utcNow(),'yyyy-MM-dd')
Hope this helps. Please let us know if any further queries.
--------------
Please consider hitting Accept Answer
button. Accepted answers help community as well.