PowerShell上传文件到SharePoint子目录下

poctopus 2021-04-21 PM 5543℃ 0条

今天客户有一个需求，需要每天定时产生的报表文件上传SharePoint服务器上，网上找了资料，可以上传到相应的根目录下，就是不能上传到子目录下，测试了很多方法都不行，最后在下班的路上通过手机找到了相关资料，进行了一顿修改后，成功将文件放置到客户SharePoint的指定目录下。
原文连接（[英文](https://stackoverflow.com/questions/38397084/trying-to-upload-files-to-subfolder-in-sharepoint-online-via-powershell "英文")）

如果Windows服务器上没有安装过Sharepoint，那就需要安装一个[SharePoint Server 2016 Client Components SDK](https://www.microsoft.com/en-us/download/details.aspx?id=51679 "SharePoint Server 2016 Client Components SDK")，安装之后需要确定两个DLL文件的对应位置，在执行PowerShell脚本的时需要用到的，具体可以参考我脚本。

```csharp
#Add references to SharePoint client assemblies and authenticate to Office 365 site – required for CSOM
#Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
#Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SharePoint.Client\v4.0_16.0.0.0__71e9bce111e9429c\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SharePoint.Client.Runtime\v4.0_16.0.0.0__71e9bce111e9429c\Microsoft.SharePoint.Client.Runtime.dll"

#Specify tenant admin and site URL
$User = "jzh@one.com"
$SiteURL = "https://one.sharepoint.com/sites/Partners/"
$Folder = "D:\username\test\"
$DocLibName = "Documents"
$FolderName = "Analytics"
$Password = "P@ssword"  | ConvertTo-SecureString -AsPlainText -Force

#Bind to site collection
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($User,$Password)
$Context.Credentials = $Creds

#Retrieve list
$List = $Context.Web.Lists.GetByTitle($DocLibName)
$Context.Load($List.RootFolder)
$Context.ExecuteQuery()

#Retrieve folder
$FolderToBindTo = $List.RootFolder.Folders
$Context.Load($FolderToBindTo)
$Context.ExecuteQuery()
$FolderToUpload = $FolderToBindTo | Where {$_.Name -eq $FolderName}

#Upload file(s)
Foreach ($File in (dir $Folder -File))
{
    $FileCreationInfo = New-Object Microsoft.SharePoint.Client.FileCreationInformation
    $FileCreationInfo.Overwrite = $true
    $FileCreationInfo.Content = [System.IO.File]::ReadAllBytes($File.FullName)
    $FileCreationInfo.URL = $List.RootFolder.ServerRelativeUrl + "/" + $FolderName + "/" + $File.Name
    $UploadFile = $List.RootFolder.Files.Add($FileCreationInfo)
    $Context.Load($UploadFile)
    $Context.ExecuteQuery()
}
```

标签: PowerShell, Sharepoint, Subfolder, upload, 上传文件, 子目录

非特殊说明，本博所有文章均为博主原创。

如若转载，请注明出处：https://www.aladown.com/archives/PowerShell%E4%B8%8A%E4%BC%A0%E6%96%87%E4%BB%B6%E5%88%B0SharePoint%E5%AD%90%E7%9B%AE%E5%BD%95%E4%B8%8B.html

上一篇 Windows系统下的免费SFTP服务器软件

下一篇 RDP 优化操作微软远程桌面开启显卡加速、60FPS、USB设备重定向

评论已关闭

一	二	三	四	五	六	日
◄ ►
				1 1	2	3
4	5	6 1	7	8 1	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

PowerShell上传文件到SharePoint子目录下

评论已关闭

日历

栏目分类

标签云

PowerShell上传文件到SharePoint子目录下

评论已关闭

日历

 栏目分类

标签云

日历

栏目分类

标签云