'How to get item ID of the last modified item in the SharePoint online list using pnp powershell?
I am able to get the date of the last modified item in the list using the script below:
$SiteURL="https://abc.sharepoint.com/sites/sitename"
$ListName="Documents"
Connect-PnPOnline -Url $SiteURL -Credentials (Get Credentials)
(Get-PnPList -Identity $ListName).LastItemUserModifiedDate
Please help me with getting the Item ID of the above last modified item.
Solution 1:[1]
Order by Modified field with desc order and get the first item of the returned items collection:
$SiteURL= "https://Tenant.sharepoint.com/"
$ListName = "Documents"
#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -UseWebLogin
#Define Query to Filter
$Query= "<View Scope='RecursiveAll'>
<Query>
<Where><Eq><FieldRef Name='FSObjType' /><Value Type='Integer'>1</Value></Eq></Where>
<OrderBy><FieldRef Name='Modified' Ascending='FALSE' /></OrderBy>
</Query>
</View>"
$ListItems = Get-PnPListItem -List $ListName -Query $Query
Write-host "Last Modified Item Id:"$ListItems[0].Id
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Jerry |