Using power automate to move file from one Sharepoint to other

(0) Share

Report

Posted on by mayankgoyal

Hi, I have a Sharepoint A to which we have full access and able to upload and download all files.

I have a Sharepoint B to which we only have read access to a folder with 1 file i.e. to download file

I am looking for a way to automatically sync up latest copy of this file from B's folder (read access one) to a folder in A (full access one) because we have a automated functionality to download any files from Sharepoint A with full access. Please suggest if power automate will be suitable for the same. Whenever user updates file in Sharepoint B, the latest copy should reflect in folder in Sharepoint A as well.

As an alternate, also suggest if there is a direct automated way of downloading file from SharepointB where we have only read access.

We have to do one automation and downloading this file from sharepoint is one step.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

Hi @mayankgoyal

Try to use the below scenario

1. I had created a flow that will trigger when a file is created or modified and I have used the trigger action called 'When a file is created or modified (properties only)'.

2. Use the action named 'Get file content using path' to get the file content. Provide the 'Full Path' from the above action.

3. Add the 'Scope' action and inside add the action named 'Create File' mapped to the destination library.

4. Add another 'Scope' action and choose the 'Configure run after' property like the below. Which makes this scope to run only if the create file action failed which is because the file with the same name already exists, in this case, we have to update the file.

So inside this action, add 'Update File' action like the below.

Save the flow and try to run it and you should be successful. 😀

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
mayankgoyal 58 on at

Like (0)

Report
Copy link

Link copied!

@sudharsan1985 - Thanks a lot for your response, I have a question on this -

What level of access do we need on site from where we have to copy the files. I have only read access on source site (from which I have to move files) and full access on site to which I need to move files to. Seems power automate connector doesn;t allow connecting with just read access.

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

Hi @mayankgoyal

For moving or copying files, I think the least is to have contribute permission to the file. Please refer the below documents and also the blog article that covers the copy & move file with different scenarios

https://docs.microsoft.com/en-us/connectors/sharepointonline/#move-file?WT.mc_id=M365-MVP-5003938

https://spknowledge.com/2020/09/20/power-automate-how-to-auto-copy-or-move-files-in-sharepoint-library/

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No