Power Automate

How to copy multiple folders and files from on-premise site to sharepoint site.

(1) Share

Report

Posted on by CU05081433-1

How to copy multiple folders and files from on-premise site to sharepoint site.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (2)

Report
You will need to install Data Gateway in order to move files from on-prem to SharePoint Online.

Alternately you could use PnP PowerShell

Install-Module -Name "PnP.PowerShell" Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/yoursite" -UseWebLogin $sourcePath = "C:\LocalFolderPath" $destinationLibrary = "Documents" # The name of your document library Get-ChildItem -Path $sourcePath -Recurse | ForEach-Object { $targetFolder = $_.FullName.Substring($sourcePath.Length) $targetFolder = $targetFolder.TrimStart("\") $targetUrl = "$destinationLibrary/$targetFolder" if ($_.PSIsContainer) { # Create folder in SharePoint New-PnPFolder -Name $targetFolder -Folder $destinationLibrary } else { # Upload file to SharePoint Add-PnPFile -Path $_.FullName -Folder $targetUrl } }

Was this reply helpful? Yes No
CU05081433-1 6 on at

Like (1)

Report

Thank you for the suggestion. I have installed the gateway, and I am able to copy files only. I want to copy nested folder and file using power automate and struggling to accomplish the task.

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (2)

Report

Are you using Script or flow?

If it is script, I can provide an updated one.

If it is flow, the create file action lets you create a Folder by specifying the destination path as /Foldername/Filename.

Was this reply helpful? Yes No
CU05081433-1 6 on at

Like (1)

Report

Thank you Sudeep for the response. I tried the flow step you have suggested but no luck. I am still testing the flow.

Bir

Was this reply helpful? Yes No