0

How to upload all folders, subfolders and files from file explorer to SharePoint library using PowerAutomate?

How i can upload all folders, subfolders and files from file explorer to SharePoint library using PowerAutomate? I am able to get files in a folder but dont know how i can traverse each subfolder and look for a file till last.

Improve this question

1 Answer 1

Reset to default
0

Have a look at desktop flows and RPA features:

Desktop flows broaden the existing robotic process automation (RPA) capabilities in Power Automate and enable you to automate all repetitive desktop processes. Automating is quicker and easier than ever with the new intuitive Power Automate desktop flow designer using the prebuilt drag-and-drop actions or recording your own desktop flows to run later.

https://learn.microsoft.com/en-us/power-automate/desktop-flows/introduction

But easier (and cheaper) might be other solutions:

  1. OneDrive Sync Client:

You can use the OneDrive sync client to sync your SharePoint document library to your local machine. Any files, folders, or subfolders that you copy to the synced folder on your desktop will automatically upload to the corresponding location in SharePoint. Pros: Easy setup, real-time sync, no scripting required. Cons: Limited to OneDrive/SharePoint and relies on the local sync process.

  1. SharePoint Migration Tool (SPMT)?

  2. PowerShell Script with PnP PowerShell?

    Copy-PnPFile [-SourceUrl] [-TargetUrl] [-Overwrite] [-Force] [-IgnoreVersionHistory] [-NoWait] [-Connection ]

Improve this answer
3
  • I tried one drive for business to sync folders with SharePoint library. But my question is, will that be taking up space in server's hard drive as the location of organization folder created after sync is showing as C drive only?
    – Adarsh Awasthi
    Commented Aug 27 at 10:29
  • What do you mean by server's hard drive? SharePoint Online storage space? Yes, the documents will count towards the SharePoint and OneDrive limits. Local hard drive? It depends on the sync options. You can choose which folders to sync support.microsoft.com/en-us/office/… or where should the copy be stored AFTER SYNC: answers.microsoft.com/en-us/msoffice/forum/all/…
    – grisha
    Commented Aug 27 at 12:40
  • I am checking to see if the problem has been resolved.
    – RaytheonXie-MSFT
    Commented Aug 30 at 8:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.