Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Using power automate to move file from one Sharepoint to other

(0) ShareShare
ReportReport
Posted on by 58

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.

  • sudharsan1985 Profile Picture
    sudharsan1985 1,325 on at
    Re: Using power automate to move file from one Sharepoint to other

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

     

  • mayankgoyal Profile Picture
    mayankgoyal 58 on at
    Re: Using power automate to move file from one Sharepoint to other

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

  • sudharsan1985 Profile Picture
    sudharsan1985 1,325 on at
    Re: Using power automate to move file from one Sharepoint to other

    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)'.

    image.png

     

     

     

     

     

     

    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.

    image.png

    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.

    image.png

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

    image.png

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard