Copy files including created and modified date with Power Automate
Posted On October 13, 2021
“I use Power Automate to archive files, is there a way to keep the original created and modified date when I copy them to archive?”
When you use Power Automate to copy or move files between SharePoint libraries, you might miss some information. You’ll lose the original author and creation date, and last modification date and the user who modified it. Flow will replace all this information. The author and editor will be replaced with the user running the flow. The creation and modification date will be replaced by the flow run date. If you want to keep the original information, you must copy it by yourself.
Copy the users and dates
While it might be possible to change the Created, Created By, Modified, and Modified By with an HTTP request, you shouldn’t do that. Once you start messing with this information, the whole SharePoint accountability will be lost. It should always stay clear who created or modified a document, and when. Even if it’s a a copy of a document, or an archived document. Therefore, I can’t recommend to change the standard SharePoint columns.
But with that in mind, there’s nothing wrong with adding new columns to the other library. You can add a separate custom column for each of the information. Two people picker columns for the author and editor, two date and time columns for the dates.
Once you have the extra columns, you can update them. After you copy/move each of the files, update the column values.
All that’s left is to modify the library views to show your columns instead of the default ones.
You shouldn’t use Power Automate to rewrite the created date when you copy files between libraries. It’s a very bad practice. But you can add your columns to store any additional values you need. You can store the original author and editor, including the dates, if you create and update the columns. All that’s needed is to update the columns after each copy/move of a file and change the view on the library.