Tenant to tenant Copy files SharePoint

Have you ever tried copying files from one tenant to another using Power Automate?

Create a file in another tenant

Well, the copy file action isn’t going to work in this case. So we will need an alternative

When you try to connect into another tenant using Power Automate you migth ghetting error message like the one below:

We are unable to find the site address. Please try selecting a site address from the dropdown

Copy SharePoint files from one tenant to another using Power Automate Microsoft Office 365 image 21

So if the create file action doesn’t recognize the other tenant url how can we make this work?

Create a connection

You can click on the … of the Create file action and then create a new connection ( or select one that is already there).

Then hit the sign in button.

Copy SharePoint files from one tenant to another using Power Automate Microsoft Office 365 image 22

As you now complete the sign in with an account local to the tenant where you want to copy your file to then you can copy the file to another tenant.

Copy SharePoint files from one tenant to another using Power Automate

Use cases for tenant to tenant copies

There may be multiple reasons for using this tenant to tenant copying of files.

You might be in the middle of a migration? Or maybe you need to synchronise two document libraries in two different tenants. There can be many different reasons.

When you use different connections however, you might want opt make it visible in your actions in your flow which connection you are using?

So in the above example, it would probably help to prefix the name of the SharePoint actions with the name of the tenant that you are connecting to.

Avatar for Pieter Veenstra

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

6 thoughts on “Copy SharePoint files from one tenant to another using Power Automate”
  1. Hi Pieter, it’s quite useful. However, can one create a connection with guest account in other tenant, i.e. without having a proper account in other tenant domain but have Edit/Member level access to a particular SharePoint library? I am trying to sign in to other tenant with the guest account that has access and it is failing to create connection.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.