Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Copy all files from a folder in Sharepoint to a local folder in Windows in c:\download

(1) ShareShare
ReportReport
Posted on by 2
I am completely new to Power Automate, I need help to copy all the files ( .xlsx, .csv, .txt files) from a folder in Sharepoint to a local folder in windows at c:\download. 

I would like this flow to run every Monday at 2am or whenever needed.

Any help will be greatly appreciated.
  • Suggested answer
    Copy all files from a folder in Sharepoint to a local folder in Windows in c:\download
    Hi.
     
    Create a New Flow and choose Scheduled cloud flow.
    Set the flow to run every Monday at 2:00 AM.
     
    Add SharePoint Trigger:
    Add a New step and select List folder:
    Site Address: Select or enter the SharePoint site URL.
    Folder Path: Choose the folder where your files are located on SharePoint.
     
    Add Apply to Each Action:
    Use the output from the List Folder as the input for this action. 
     
    Since Power Automate Cloud cannot access local file systems directly, we'll now call Power Automate Desktop to handle the local file system part:
    Add an HTTP action (this will trigger the desktop flow).
    Set it up to call a desktop flow you've created (which we'll create next)
     
     
    Open Power Automate Desktop and create a new flow.
     
    Use the Launch new browser action to open SharePoint.
    Use the Get files from folder action for downloading the filtered files to your local folder (C:\download).
     
    Test the desktop flow to ensure it works properly. Once done, link this flow to the cloud flow via HTTP triggers or directly through the Power Automate Desktop connector.
     
    In Power Automate Cloud, use the HTTP trigger or desktop flow action to trigger the Power Automate Desktop process.
     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard