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.

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.

13 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.

  2. Hi is there a way to copy entire folders, subfolders and files from one tenancy to another? I have managed to get my flow to copy folders, subfolders & files from one SharePoint library to another, but can’t seem to get the connection to work between tenancies? I have global admin on both the source and destination tenant, but get “Unauthorized” on my Copy Folder Action? The exact same flow works fine when i copy site to site on the same tenancy?

    1. Can you check the connections used for the actions. It sounds like you are using the same connection. Cation interacting with different tenants will need different connections.

  3. I’m wondering if you found a solution to the guest account issue? I want to automate a weekly upload (possibly more frequent in the future) to our client’s SharePoint. And if we can’t do this with a guest account, I am wondering what kind/level of access we would want to request from the client in order to automate.

    1. All you should need to do is create a connection to the other tenant within your tenant. Then with that account have access to write to the client’s site. Alternatively you could also initiate this from the client’s tenant of course

  4. All what you need to transfer directly between SharePoint tenant to another , a GUI copy tools like ShareGate and Gs Richcopy 360 . both can save your time

    1. That isn’t really the same thing. If you want to sync just a couple of files between tenants then this approach will reduce costs and be more efficient. ShareGate is more a migration tool when you want to copy large amounts of files.

Leave a Reply

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