SharePoint Online：使用 PowerShell 将附件从列表复制到文档库

要求：将所有附件从 SharePoint Online 列表复制到文档库。

如何从 SharePoint Online 列表复制附件？

您想要将附件从列表复制到 SharePoint Online 中的文档库吗？如果是这样，这个方便的指南将向您展示如何操作！只需几个简单的步骤，您就可以轻松地在列表和库之间移动文件。您可以使用此方法从一个列表项或同时从列表的所有项复制多个附件。

以下是从 SharePoint Online 列表复制所有附件的技巧：SharePoint 通过根据名为“附件”的文件夹下的项目 ID 为每个列表项创建子文件夹来存储列表项附件。

1. 将“附件”附加到您的列表 URL。例如。如果您的列表 URL 为：https://tenant.sharepoint.com/lists/project，则 URL 为：https://tenant.sharepoint.com/lists/project/attachments
2. 将您在上一步中构建的 URL 映射为网络驱动器。转到 Windows 资源管理器 >> 右键单击“此电脑”（或“我的电脑”）>> 选择“映射网络驱动器”>> 输入 URL 并完成该向导。

3. 这将在文件资源管理器视图中打开附件列表，您可以在其中查看和复制列表中的附件。

   

您还可以使用 SharePoint Designer 导航到“附件”文件夹并复制任何列表的附件。

SharePoint Online：使用 PowerShell 将附件复制到文档库

让我们将列表项中的所有附件复制到文档库：

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

#Set Parameters
$SiteURL= "https://crescent.sharepoint.com/sites/marketing"
$ListName= "Projects"
$ListItemID = 1
$DocumentLibraryURL = "/Sites/Marketing/Project Documents/" #Relative URL - Must end with /

#Setup Credentials to connect
$Cred = Get-Credential

#Setup the context
$Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)

#Get the List Item
$List = $Ctx.Web.Lists.GetByTitle($ListName)
$ListItem = $List.GetItemByID($ListItemID)
$Attachments = $ListItem.AttachmentFiles
$Ctx.Load($Attachments)
$Ctx.ExecuteQuery()
    
#Get All attachments from the List Item
Write-host "Total Attachments Found:"$Attachments.count
ForEach($Attachment in $Attachments)
{
    #Get attachment from List Item
    $File = $Ctx.Web.GetFileByServerRelativeUrl($Attachment.ServerRelativeUrl)
    $Ctx.Load($file)
    $Ctx.ExecuteQuery()

    #Copy attachment to Document Library
    $File.CopyTo($DocumentLibraryURL+$File.Name, $True)
    $Ctx.ExecuteQuery()
    Write-host "Attachment Copied:"$File.name
}

此 PowerShell 脚本将项目 ID 为“1”的列表项中的所有附件复制到同一站点上的现有文档库“Project Documents”。

PowerShell 从 SharePoint Online 中的所有列表项复制附件

让我们将给定列表项的所有附件复制到文档库。

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

Function Copy-ListAttachments()
{
    Param
    (
        [Parameter(Mandatory=$true)] [string] $SiteURL,
        [Parameter(Mandatory=$true)] [string] $ListName,
        [Parameter(Mandatory=$true)] [string] $DocumentLibraryName
    )
    
    Try {
        #Setup Credentials to connect
        $Cred = Get-Credential

        #Setup the context
        $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
        $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)

        #Get the Document Library 
        $DocumentLibrary = $Ctx.Web.Lists.GetByTitle($DocumentLibraryName)
        $Ctx.Load($DocumentLibrary.RootFolder)
        $Ctx.Load($DocumentLibrary.RootFolder.Folders)
        $Ctx.ExecuteQuery()

        #Get all List Items with attachments
        $Query = New-Object Microsoft.SharePoint.Client.CamlQuery
        $Query.ViewXml = "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='Attachments' /><Value Type='Boolean'>1</Value></Eq></Where></Query></View>"
        $List = $Ctx.Web.Lists.GetByTitle($ListName)
        $ListItems = $List.GetItems($Query)
        $Ctx.Load($ListItems)
        $Ctx.ExecuteQuery()
        
        #Iterate through each list item
        ForEach($ListItem in $ListItems)
        {
            #Get All attachments from the List Item
            $Attachments = $ListItem.AttachmentFiles
            $Ctx.Load($Attachments)
            $Ctx.ExecuteQuery()

            #Create New Folder for each List Item
            $Folders = $DocumentLibrary.RootFolder.Folders | Select -ExpandProperty Name
            If($Folder -notcontains $ListItem.Id)
            {
                $Folder = $DocumentLibrary.RootFolder.Folders.Add($ListItem.Id)
                $Ctx.ExecuteQuery()
            }

            ForEach($Attachment in $Attachments)
            {
                #Get attachment from List Item
                $File = $Ctx.Web.GetFileByServerRelativeUrl($Attachment.ServerRelativeUrl)
                $Ctx.Load($file)
                $Ctx.ExecuteQuery()

                #Copy attachment to Document Library
                $TargetFileURL = $DocumentLibrary.RootFolder.ServerRelativeUrl+"/"+$ListItem.Id+"/"+$File.Name
                $File.CopyTo($TargetFileURL, $True)
                $Ctx.ExecuteQuery()
                Write-host "Attachment Copied:"$TargetFileURL
            }
        }
    }
    Catch {
        write-host -f Red "Error Copying List Attachments!" $_.Exception.Message
    } 
}

#Call the function to copy attachments
Copy-ListAttachments -SiteURL "https://crescent.sharepoint.com/sites/marketing" -ListName "Projects" -DocumentLibraryName "Project Documents"

PnP PowerShell 将列表项附件复制到文档库

以下是将附件从列表复制到文档库的 PnP PowerShell 方法：

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/marketing"
$ListName = "Projects"
$ListItemID = "1"
$DocumentLibraryURL = "/Sites/Marketing/ProjectDocuments"

#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

#Get the List Item
$ListItem = Get-PnPListItem -List $ListName -Id $ListItemID

#Get All Attachments of the List Item
$Attachments = Get-PnPProperty -ClientObject $ListItem -Property "AttachmentFiles"

#Copy Attachment File to Document Library 
$Attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl -TargetUrl "$DocumentLibraryURL/$($_.FileName)" -OverwriteIfAlreadyExists:$True -Force}

使用 PnP PowerShell 将列表附件复制到文档库

将所有附件按文件夹复制到文档库怎么样？让我们在文档库中为每个列表项（基于列表项 ID）和附件创建文件夹。

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/marketing"
$ListName = "Projects"
$DocumentLibraryName = "Project Documents"

#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

#Get All List Items with Attachments
$SPQuery = "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='Attachments' /><Value Type='Boolean'>1</Value></Eq></Where></Query></View>"
$ListItems = Get-PnPListItem -List $ListName -Query $SPQuery

#Get the Web and Document Library
$Web = Get-PnPWeb
$DocumentLibrary = Get-PnPList $DocumentLibraryName -Includes RootFolder

ForEach($ListItem in $ListItems)
{
    #Get All Attachments of the List Item
    $Attachments = Get-PnPProperty -ClientObject $ListItem -Property "AttachmentFiles"

    #Create Folder for List Item Attachments in the document library
    $FolderURL = "$($DocumentLibrary.RootFolder.ServerRelativeUrl)/$($ListItem.ID)"
    $FolderSiteRelativeURL = $FolderURL.Replace($Web.ServerRelativeUrl,[string]::Empty)
    $Folder = Resolve-PnPFolder -SiteRelativePath $FolderSiteRelativeURL

    #Copy Attachment File to Document Library 
    $Attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl -TargetUrl "$FolderURL/$($_.FileName)" -OverwriteIfAlreadyExists:$True -Force}
}

这是将附件复制到另一个列表的另一篇文章：SharePoint Online：将附件从一个列表复制到另一个列表

总之，通过使用本教程中概述的方法，您可以轻松有效地将附件从列表传输到文档库，以利用 SharePoint Online 提供的功能，例如版本控制、搜索和检索以及协作。通过自动化该过程，您可以节省时间和资源，并确保正确存储和维护附件。