时间戳

首页 > 解决方案 > Powershell 中的 SharePoint 命令列出自定义列

powershell - Powershell 中的 SharePoint 命令列出自定义列

问题描述

我在 SharePoint 中创建了几个额外的列：Obsolete as True/False and Review Date In Powershell 我可以运行以下命令：

Get-ChildItem -force | Select-Object Mode, Name, CreationTime | ft

如何在 list 命令中包含 Obsolete 和 Review Date 列作为对象？

如何使用类似的命令更新 Powershell 中的 Obsolete 和 Review Date 自定义列的值：

$(Get-Item xxx.jpg).lastaccesstime=$(Get-Date)

在此处输入图像描述 在此处输入图像描述 谢谢

标签： powershellsharepoint

解决方案

使用 PnPPowershell 读取 SharePoint 列表项的示例演示。

https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-pnp/sharepoint-pnp-cmdlets?view=sharepoint-ps

#region Variables 
$Username = "user@xxx.onmicrosoft.com" 
$Password = "Password" 
$siteURL = "https://xxx.sharepoint.com/sites/lee"
#endregion Variables

#region Credentials 
[SecureString]$SecurePass = ConvertTo-SecureString $Password -AsPlainText -Force 
[System.Management.Automation.PSCredential]$PSCredentials = New-Object System.Management.Automation.PSCredential($Username, $SecurePass) 
#endregion Credentials

Connect-PnPOnline -Url $siteURL -Credentials $PSCredentials

#(Get-PnPListItem -List MyList4 -Fields "Title","Obsolete","Review_x0020_Date").FieldValues| Format-Table
$items = Get-PnPListItem -List "MyList4" -Fields Title,Obsolete,Review_x0020_Date
$items | %{new-object PSObject -Property @{Title=$_["Title"];Obsolete=$_["Obsolete"];ReviewDate=$_["Review_x0020_Date"]}}| select Title,Obsolete,ReviewDate
Write-Host "-----------"

推荐阅读