Power Platform Community Forum Thread Details

Hello,

I need to move files older than 2018 from one SharePoint document library to another within the same tenant. I would also like to keep the files organized in their parent folders, or if it’s easier the whole folder structure (some files are very nested).

I’ve done a fair amount of searching and I believe I have the first part done.
Get files (properties only) – Apply Filter Query: Modified lt datetime'2018-01-01T00:00:00Z'
Then, Move file in a For Each loop with the destination site address.

This would dump everything into one folder, I’m unsure how to keep the folder structure.
Thank you for any input.

Categories:

General topics

I don't have a solution for you because I would use a different tool to accomplish this, which is Sharegate.

ShareGate ensures that all metadata, version history, and permissions are preserved during the migration process. Additionally, ShareGate can handle large-scale migrations with ease, including the ability to run multiple migration sessions simultaneously. It provides comprehensive reports on the migration process, including logs of what was migrated, any errors encountered, and overall status. ShareGate also retains the original folder structure during the migration, ensuring that the organization of files remains intact. Its intuitive and user-friendly interface makes it easier for users to set up and manage migrations without extensive technical knowledge.

Unfortunately, ShareGate can only copy and not move files. If you think about it, this is a good thing because if something goes wrong, you can start over. If the files got deleted from the original location and something went wrong, what would you do?

However, this is where a Power Automate flow could be used to get the files from 2018 and have the flow delete each one. With deleting files, you don't need to worry about the folder structure, retaining version history or the file metadata and they will be in the recycle bin if they need to be restored.