我在SharePoint中创建了两个额外的列:过时为True/False和在Powershell中查看日期我可以运行以下命令:
Get-ChildItem -force | Select-Object Mode, Name, CreationTime | ft如何将过时和查看日期列作为对象包含在list命令中?
如何还可以使用类似的命令更新Powershell中的过时和审查日期自定义列的值:
$(Get-Item xxx.jpg).lastaccesstime=$(Get-Date)


谢谢
发布于 2020-06-16 12:11:07
使用PnPPowershell读取SharePoint列表项的示例演示。
#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 "-----------"https://stackoverflow.com/questions/62360082
复制相似问题