[BUG] Get-PnPListItem fails on large lists using UniqueId

[rohit404404]

Discussed in #2685

^{Originally posted by HeKr09 December 6, 2022}

Reporting an Issue or Missing Feature

I try to scan SitePages for specific images and documents. Therefor I check the WebParts for example for an image WebPart.
Within the PropertiesJson I retrieve a uniqueId which seems to be the uniqueId of the image used.
So I tried to get the list item with Get-PnPListItem and the uniqueId which fails on large lists because the code seems to use a query to get the item. This means I run into the problem several people did have.
Is there any other way?

Expected behavior

I expected that the uniqueId would be easier to find than using a query.

Actual behavior

Get-PnPListItem : The attempted operation is prohibited because it exceeds the list view threshold.
At line:1 char:158
+ ... son.listId; Get-PnPListItem -List $list -UniqueId $json.uniqueId -Fie ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Get-PnPListItem], PSInvalidOperationException
    + FullyQualifiedErrorId : InvalidOperation,PnP.PowerShell.Commands.Lists.GetListItem

Steps to reproduce behavior

 $page.Controls | Where-Object Title -eq "Image" | ForEach-Object { $json = $_.PropertiesJson | ConvertFrom-Json; $list = Get-PnPList -Identity $json.listId; Get-PnPListItem -List $list -UniqueId $json.uniqueId; }

What is the version of the Cmdlet module you are running?

1.12.0

Which operating system/environment are you running PnP PowerShell on?

• Windows
• Linux
• MacOS
• Azure Cloud Shell
• Azure Functions
• Other : please specify