Forum Discussion
How to Set Dynamic File Names in a Copy Activity for Lakehouse in Microsoft Fabric?
Hi HamidBee ,
There is an alternative:
New and changed files can be copied from one lakehouse to another in an incremental manner. It uses “ Filter by Last Modified ” to determine which files to copy.
After completing the steps here, Data Factory scans all files in the source store, applies file filters that are filtered by “ Filter by Last Modified ”, and then copies the new files and files that have been updated since the last time to the target store.
For more information, please refer to:
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
I think you are close, but instead of use the concate() directly in the copy activity, you need to create a variable called 'source file name', then add a Set Variable activity where you can define the variable using Add dynamic content, and input @concat('Monthly Report', utcNow('yyyyMMM'),'.xlsx') .
see my learning notes attached.