SharePoint Online：使用 PowerShell 将人员或组（人员选择器）列添加到列表

要求：在 SharePoint Online 列表中创建个人或组列。

如何将人员或组列添加到 SharePoint Online 中的列表？

SharePoint Online 中的“个人或组”列用于获取用户或组值。该字段可以配置为接受来自身份验证提供程序（例如 Active Directory）的任何值，也可以限制为从特定 SharePoint 组获取个人。可以通过姓名或电子邮件地址找到用户。它还会在您键入时从可用值中自动填充适当的匹配名称。请按照以下步骤将人员选择器列添加到列表中。

1. 浏览到 SharePoint Online 网站并导航到要添加“人员”或“组”列的目标列表。
2. 在“列表”选项卡下，单击功能区中的“创建列”按钮。

3. 为新列提供名称，将类型指定为“个人或组”

   

4. 向下滚动，填写其他可选值，例如必填列、唯一、允许多个值等，然后单击“确定”在 SharePoint Online 列表中创建人员或组字段。

PowerShell 创建要在 SharePoint Online 中列出的人员或组列：

以下是如何使用 PowerShell 以编程方式在 SharePoint 列表中添加人员或组字段：

#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"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Taxonomy.dll"

#Custom function to add column to list
Function Add-PersonOrGroupColumnToList()
{ 
    param
    (
        [Parameter(Mandatory=$true)] [string] $SiteURL,
        [Parameter(Mandatory=$true)] [string] $ListName,
        [Parameter(Mandatory=$true)] [string] $Name,
        [Parameter(Mandatory=$true)] [string] $DisplayName,
        [Parameter(Mandatory=$false)] [string] $Description=[string]::Empty,
        [Parameter(Mandatory=$false)] [string] $IsRequired = "FALSE",
        [Parameter(Mandatory=$false)] [string] $EnforceUniqueValues = "FALSE",
        [Parameter(Mandatory=$false)] [string] $SelectionMode="PeopleOnly"
    )

    #Generate new GUID for Field ID
    $FieldID = New-Guid

    Try {
        $Cred= Get-Credential
        $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

        #Setup the context
        $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
        $Ctx.Credentials = $Credentials
        
        #Get the List
        $List = $Ctx.Web.Lists.GetByTitle($ListName)
        $Ctx.Load($List)
        $Ctx.ExecuteQuery()

        #Check if the column exists in list already
        $Fields = $List.Fields
        $Ctx.Load($Fields)
        $Ctx.executeQuery()
        $NewField = $Fields | where { ($_.Internalname -eq $Name) -or ($_.Title -eq $DisplayName) }
        if($NewField -ne $NULL)  
        {
            Write-host "Column $Name already exists in the List!" -f Yellow
        }
        else
        {
            #Create Column in the list
            $FieldSchema = "<Field Type='User' ID='{$FieldID}' DisplayName='$DisplayName' Name='$Name' Description='$Description' Required='$IsRequired' EnforceUniqueValues='$EnforceUniqueValues' ShowField='ImnName' List='UserInfo' UserSelectionMode='$SelectionMode' />"
            $NewField = $List.Fields.AddFieldAsXml($FieldSchema,$True,[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldInternalNameHint)
            $Ctx.ExecuteQuery()    

            Write-host "New Column Added to the List Successfully!" -ForegroundColor Green  
        }
    }
    Catch {
        write-host -f Red "Error Adding Column to List!" $_.Exception.Message
    }
} 

#Set parameter values
$SiteURL="https://crescent.sharepoint.com"
$ListName="Projects"
$Name="ProjectMembers"
$DisplayName="Project Members"
$Description="Enter the Project Team Members"
$SelectionMode="PeopleOnly" #Or PeopleAndGroups

#Call the function to add column to list
Add-PersonOrGroupColumnToList -SiteURL $SiteURL -ListName $ListName -Name $Name -DisplayName $DisplayName -Description $Description -SelectionMode $SelectionMode 

如何从 CSV 文件向列表批量添加多列？

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/london" 
$ListName = "Desk Allocation"
$CSVFilePath = "C:\Temp\columns.csv"

Try {
    #Connect to PnP Online
    Connect-PnPOnline -Url $SiteUrl -Interactive

    #Get Data from CSV
    $ListColumns = Import-Csv $CSVFilePath

    ForEach($Column in $ListColumns)
    {
        Add-PnPField -List $ListName -Type User -InternalName $Column.Name -DisplayName $Column.Name -AddToDefaultView
        Write-Host "Added Column '$($Column.Name)' to the List!"
    }
} 
Catch {
    Write-Host "Error:"$_.Exception.Message
 }

如何添加多个值人员选择器字段？
要添加具有“允许多项选择”的人员选取器字段，请使用此字段架构：

$FieldSchema = "<Field Type='UserMulti' ID='{$FieldID}' DisplayName='$DisplayName' Name='$Name' Description='$Description' Required='$IsRequired' EnforceUniqueValues='$EnforceUniqueValues' ShowField='ImnName' List='UserInfo' UserSelectionMode='$SelectionMode' Mult='TRUE' />"

PnP PowerShell 将人员或组列添加到 SharePoint Online 列表

#Config Variables
$SiteURL = "https://Crescent.sharepoint.com/sites/marketing"
$ListName= "Projects"

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

#Define XML Schema for User Field
$FieldXML= "<Field Type='User' Name='ProjectManager' ID='$([GUID]::NewGuid())' DisplayName='Project Manager' Required ='FALSE' UserSelectionMode='PeopleOnly'></Field>"

#Add User Field to list
Add-PnPFieldFromXml -FieldXml $FieldXML -List $ListName

同样，您还可以从 XML 架构添加多人或组列。

$FieldXML= "<Field Type='UserMulti' Name='TeamMembers' ID='$([GUID]::NewGuid())' DisplayName='Team Members' Required ='FALSE' UserSelectionMode='PeopleAndGroups' Mult='TRUE' ></Field>"