How to get item ID of the last modified item in the SharePoint online list using pnp powershell?

Question

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.

Is there any updates ? Did the PowerShell script work for you ? — Jerry, Jul 17 '20 at 09:01

score 0 · Accepted Answer · answered Jul 16 '20 at 09:44

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

Hi sk5991, Glad to hear your update, then you can accept this reply as answer :) — Jerry, Jul 19 '20 at 02:04

How to get item ID of the last modified item in the SharePoint online list using pnp powershell?

1 Answers1