web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy files from sharep...
Power Automate
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!

I have the same question (0)
  • Deenuji_Loganathan_ Profile Picture
    6,250 Super User 2025 Season 2 on at

    @Th11 

     

    Method 1: 

    To copy all files from your SharePoint folder, you can sync it with your computer, similar to how OneDrive works. Here’s how you can do it:

    1. Open SharePoint: Navigate to the SharePoint site containing the folder you want to sync.
    2. Select the Folder: Go to the document library and select the folder you want to sync.
    3. Click Sync: In the toolbar, click the "Sync" button. If prompted, allow your browser to open OneDrive.
    4. Sign In: Sign in to OneDrive if you’re not already signed in. This will start the sync process.
    5. Access Files Locally: Once synced, you can access your SharePoint files in File Explorer (Windows) or Finder (Mac) under your organization’s name.

    This way, you can manage your SharePoint files directly from your computer, just like with OneDrive.

     

    Deenuji_0-1720756296496.png

     

    Method 2:

     

    Utilize SharePoint actions to retrieve your file's properties and content, convert it into a file, and save it to your local drive.

     

    Deenuji_1-1720756680918.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 🚀

     

     

  • Sayan Profile Picture
    818 Super User 2025 Season 2 on at

    Hey @Th11 

     

    You can follow the above solutions of @Deenuji  to copy files from SharePoint to your local folder.

    I want to add that you will only be able to copy the files to your local folder using Power Automate Desktop. You cannot copy the files using Power Automate Cloud.

     

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

    If my solution helps you please give it a Thumbs up 👍 and Mark as a Solution ✔️ . It motivates to solve more problems.

     

    Thanks,

    Sayan Patra

    RPA Developer

  • Sayan Profile Picture
    818 Super User 2025 Season 2 on at

    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

     

  • VishnuReddy1997 Profile Picture
    2,656 Super User 2025 Season 2 on at

    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

  • Deenuji_Loganathan_ Profile Picture
    6,250 Super User 2025 Season 2 on at

    @Sayan 

     

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

  • Sayan Profile Picture
    818 Super User 2025 Season 2 on at

    Hey @VishnuReddy1997 @Deenuji 

    It works

     

    Thanks

    Sayan Patra

    RPA Developer

     

  • VishnuReddy1997 Profile Picture
    2,656 Super User 2025 Season 2 on at

    Hi @Sayan ,

     

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

     

    Regards,

    Vishnu Reddy

  • Th11 Profile Picture
    on at

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

  • Deenuji_Loganathan_ Profile Picture
    6,250 Super User 2025 Season 2 on at

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

     

     

  • T24k Profile Picture
    32 on at
    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. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard