Last active
July 11, 2024 16:24
-
-
Save vgrem/cf6cba630dc6b81b1bd8 to your computer and use it in GitHub Desktop.
Upload files into Document Library in SharePoint Online
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll" | |
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" | |
Function Ensure-Folder() | |
{ | |
Param( | |
[Parameter(Mandatory=$True)] | |
[Microsoft.SharePoint.Client.Web]$Web, | |
[Parameter(Mandatory=$True)] | |
[Microsoft.SharePoint.Client.Folder]$ParentFolder, | |
[Parameter(Mandatory=$True)] | |
[String]$FolderUrl | |
) | |
$folderNames = $FolderUrl.Trim().Split("/",[System.StringSplitOptions]::RemoveEmptyEntries) | |
$folderName = $folderNames[0] | |
Write-Host "Creating folder [$folderName] ..." | |
$curFolder = $ParentFolder.Folders.Add($folderName) | |
$Web.Context.Load($curFolder) | |
$web.Context.ExecuteQuery() | |
Write-Host "Folder [$folderName] has been created succesfully. Url: $($curFolder.ServerRelativeUrl)" | |
if ($folderNames.Length -gt 1) | |
{ | |
$curFolderUrl = [System.String]::Join("/", $folderNames, 1, $folderNames.Length - 1) | |
Ensure-Folder -Web $Web -ParentFolder $curFolder -FolderUrl $curFolderUrl | |
} | |
} | |
Function Upload-File() | |
{ | |
Param( | |
[Parameter(Mandatory=$True)] | |
[Microsoft.SharePoint.Client.Web]$Web, | |
[Parameter(Mandatory=$True)] | |
[String]$FolderRelativeUrl, | |
[Parameter(Mandatory=$True)] | |
[System.IO.FileInfo]$LocalFile | |
) | |
try { | |
$fileUrl = $FolderRelativeUrl + "/" + $LocalFile.Name | |
Write-Host "Uploading file [$($LocalFile.FullName)] ..." | |
[Microsoft.SharePoint.Client.File]::SaveBinaryDirect($Web.Context, $fileUrl, $LocalFile.OpenRead(), $true) | |
Write-Host "File [$($LocalFile.FullName)] has been uploaded succesfully. Url: $fileUrl" | |
} | |
catch { | |
write-host "An error occured while uploading file [$($LocalFile.FullName)]" | |
} | |
} | |
function Upload-Files() | |
{ | |
Param( | |
[Parameter(Mandatory=$True)] | |
[String]$Url, | |
[Parameter(Mandatory=$True)] | |
[String]$UserName, | |
[Parameter(Mandatory=$False)] | |
[String]$Password, | |
[Parameter(Mandatory=$True)] | |
[String]$TargetListTitle, | |
[Parameter(Mandatory=$True)] | |
[String]$SourceFolderPath | |
) | |
if($Password) { | |
$SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force | |
} | |
else { | |
$SecurePassword = Read-Host -Prompt "Enter the password" -AsSecureString | |
} | |
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($Url) | |
$Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,$SecurePassword) | |
$Context.Credentials = $Credentials | |
$web = $Context.Web | |
$Context.Load($web) | |
$list = $web.Lists.GetByTitle($TargetListTitle); | |
$Context.Load($list.RootFolder) | |
$Context.ExecuteQuery() | |
Get-ChildItem $SourceFolderPath -Recurse | % { | |
if ($_.PSIsContainer -eq $True) { | |
$folderUrl = $_.FullName.Replace($SourceFolderPath,"").Replace("\","/") | |
if($folderUrl) { | |
Ensure-Folder -Web $web -ParentFolder $list.RootFolder -FolderUrl $folderUrl | |
} | |
} | |
else{ | |
$folderRelativeUrl = $list.RootFolder.ServerRelativeUrl + $_.DirectoryName.Replace($SourceFolderPath,"").Replace("\","/") | |
Upload-File -Web $web -FolderRelativeUrl $folderRelativeUrl -LocalFile $_ | |
} | |
} | |
} | |
#Usage | |
$Url = "https://contoso.sharepoint.com" | |
$UserName = "username@contoso.onmicrosoft.com" | |
$Password = "password" | |
$TargetListTitle = "Documents" #Target Library | |
$SourceFolderPath = "C:\Users\user\Upload" #Source Physical Path | |
#Upload files | |
Upload-Files -Url $Url -UserName $UserName -Password $Password -TargetListTitle $TargetListTitle -SourceFolderPath $SourceFolderPath |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment