You should be able to get the items by adding a CAML query to the Get-PnPListItem cmdlet.
To query by date ranges with this: caml-query-search-between-two-date-ranges-sharepoint
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm using PNP Module to get my OneDrive file and folder total items count. The below script is working fine but I'm just wondering if there is a way to get only a certain date range file and folder count.
For example, I just want an item total count between CreatedDate 03/03/2011 to CreatedDate 08/31/2022 instead of everything.
Any help or suggestion would be really appreciated.
$SiteURL = ""
$ListName = "Documents"
Connect-PnPOnline $SiteURL -Credentials $credential
#Get the list
$List = Get-PnPList -Identity $ListName | Select Title, ItemCount
$global:counter = 0
$FolderItems = Get-PnPListItem -List $ListName -PageSize 500 -Fields "FileLeafRef", "Created","Modified", "SMTotalFileStreamSize","FileRef","File_x0020_Type" -ScriptBlock { Param($items) $global:counter += $items.Count; Write-Progress -PercentComplete `
($global:Counter / ($List.ItemCount) * 100) -Activity "Getting Items from List:" -Status "Processing Items $global:Counter to $($List.ItemCount)"; } | Where { $_.FileSystemObjectType -eq "folder" }
$FolderItems.Count
You should be able to get the items by adding a CAML query to the Get-PnPListItem cmdlet.
To query by date ranges with this: caml-query-search-between-two-date-ranges-sharepoint
Hi @Aase Nomad
I do agree with RichMatheisen-8856's answer. You can add a camlquery when Get-PnPListItem
. Please refer to following script
$Query =
"<Where>
<And>
<Geq>
<FieldRef Name='Created' />
<Value Type='DateTime'>2011-03-03T12:00:00Z</Value>
</Geq>
<Leq>
<FieldRef Name='Created' />
<Value Type='DateTime'>2022-08-31T12:00:00Z</Value>
</Leq>
</And>
</Where>";
$FolderItems = Get-PnPListItem -List $ListName -Query $Query
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Aase Nomad
Is there any error message? Could you share more details for us to reproduce the error?
Hi @Aase Nomad
Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.
Have a nice day!
Thanks,
Raytheon Xie