Copy files between SharePoint libraries (Power Automate)

Copy files one by one can be painful if you’ve got a lot of them or if you need to do it regularly, there has to be a way how to automate this with Power Automate.

Let’s build a simple workflow to copy all files from one location to another on user request. That means we want to start from Instant flow using Manually trigger flow trigger.

Add New step: ‘Get files (properties only)’ and select the source of the files.

Add New step: ‘Copy file’. Select the source site, and use the ‘Identifier’ output from ‘Get files (properties only)’ as the ‘File to Copy’.

Select ‘Destination Site Address’ and for the ‘Destination folder’ fields. Instead of using dynamic content in the field click on the folder icon on the right side to display selection of all available libraries on the destination site. Also select what should happen it file already exists on the destination site.

copy files power automate
copy files power automate

Now you can find it under My flows and run it by pressing the Play button.

copy files power automate

If your document library contains also folder structure, you might need to add one more condition into the Power Automate flow to copy the folders together with the files.

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.


Add a Comment

Your email address will not be published. Required fields are marked *