Skip to main content

Notifications

Power Automate - Power Automate Desktop
Unanswered

Copy files from sharepoint to local desktop folder

(3) ShareShare
ReportReport
Posted on by

Hi all,

I am trying to copy the files from SharePoint to the local desktop folder. please guide me which approach is better. power automate(cloud) or PAD ? Thanks in advance!

  • Suggested answer
    CU13122055-0 Profile Picture
    CU13122055-0 2 on at
    Copy files from sharepoint to local desktop folder
    Can you guys share me the details for each action.
    I set it up and got errors while running it
  • Suggested answer
    Deenuji_Loganathan_ Profile Picture
    Deenuji_Loganathan_ 6,080 on at
    Copy files from sharepoint to local desktop folder
    @@dataset: 'Communication site - https://sharepoint.com'
    @@id: '/HR Documents'
    @@connectionDisplayName: 'Cr8665f_shared_sharepointonline_55b5c933'
    External.InvokeCloudConnector Connection: 'e6f1f68c-1c8b-4666-9ef7-deea7a4aa652' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'ListFolder' @dataset: $'''https://sharepoint.com''' @id: $'''/HR Documents''' @ListFolderResponse=> ListFolderResponse
    LOOP FOREACH CurrentItem IN ListFolderResponse
        @@dataset: 'Communication site - https://sharepoint.com'
    @@id: '%CurrentItem.Id%'
    @@connectionDisplayName: 'Cr8665f_shared_sharepointonline_55b5c933'
    External.InvokeCloudConnector Connection: 'e6f1f68c-1c8b-4666-9ef7-deea7a4aa652' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'GetFileContent' @dataset: $'''https://sharepoint.com''' @id: CurrentItem.Id @inferContentType: True @GetFileContentResponse=> GetFileContentResponse
        File.ConvertFromBinary BinaryData: GetFileContentResponse File: $'''C:\\Users\\Documents\\Captcha\\%CurrentItem.Name%''' IfFileExists: File.IfExists.DoNothing
    END
    Hi @THH, Please follow the above simple code for the same use case.

    Flow screenshot:
  • T24k Profile Picture
    T24k 32 on at
    Copy files from sharepoint to local desktop folder
    HI @DEENUJI LOGANATHAN, Thanks for your response. If you don't mind, can you please open the first 4 steps and send those screenshot to me. I am facing some issue in my bot. 
  • Deenuji_Loganathan_ Profile Picture
    Deenuji_Loganathan_ 6,080 on at
    Re: Copy files from sharepoint to local desktop folder

    @Th11 

     

    This use case comes with cloud actions and if we copy our code and paste here it wouldn't work as like other code.

    You can follow the below actions and in case of any queries please let me know we will assist you on the same.

     

    Deenuji_0-1721135141770.png

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Power Automate Desktop Community Champion 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

     

     

  • Th11 Profile Picture
    Th11 on at
    Re: Copy files from sharepoint to local desktop folder

    Hi @Deenuji , @Sayan could you please share the PAD code in this chat. Thanks!

  • VishnuReddy1997 Profile Picture
    VishnuReddy1997 2,212 on at
    Re: Copy files from sharepoint to local desktop folder

    Hi @Sayan ,

     

    Great to hear! If it works mark it as a solution so it will help others in future.

     

    Regards,

    Vishnu Reddy

  • Sayan Profile Picture
    Sayan 694 on at
    Re: Copy files from sharepoint to local desktop folder

    Hey @VishnuReddy1997 @Deenuji 

    It works

     

    Thanks

    Sayan Patra

    RPA Developer

     

  • Deenuji_Loganathan_ Profile Picture
    Deenuji_Loganathan_ 6,080 on at
    Re: Copy files from sharepoint to local desktop folder

    @Sayan 

     

    Please follow the @VishnuReddy1997 suggested link and let me know if you encounter any issues.

  • VishnuReddy1997 Profile Picture
    VishnuReddy1997 2,212 on at
    Re: Copy files from sharepoint to local desktop folder

    Hi @Sayan ,

     

    Please follow the below link.

    Link: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-Desktop-SharePoint-actions-can-t-use-Variables/td-p/2344023 

     

    (Note:- if you got your solution you can mark as solution and gives kudos)


    Thanks & Regards

    Vishnu Reddy

  • Sayan Profile Picture
    Sayan 694 on at
    Re: Copy files from sharepoint to local desktop folder

    Hey @Deenuji 

    while using "Get file content" I am facing an issue that the File Identifier field does not take the Dynamic value it gives error that bad request.

     

    Are you passing the value dynamically or selecting from dropdown. can you please share the screenshot.

     

    Getting Error: 

     

    Sayan_0-1720769374100.png

    Sayan_1-1720769414294.png

     

    Working:

     

    Sayan_3-1720769545467.png

     

     

     

    -----------------------------------------------------------------------------------------------------------------------------

    Thanks,

    Sayan Patra

    RPA Developer

     

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,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard