PnP PowerShell Check if items exists in List

Question

Hi All,&nbsp;I have the following script that checks to see if a Site exists in a SPO list and either updates or adds the item to the list.&nbsp;For some reason it never updates the list items... It just keeps adding new list item entries?&nbsp;I am using the Site.URL as my unique ID&nbsp;&nbsp;&nbsp; &nbsp; # Add or update item in the list&nbsp; &nbsp; $listItem = Get-PnPListItem -List $ListName -Query "&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='URL' Type='Text'/&gt;&lt;Value Type='Text'&gt;${site.Url}&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;"&nbsp;&nbsp; &nbsp; if ($null -ne $listItem) {&nbsp; &nbsp; &nbsp; &nbsp; # Update item&nbsp; &nbsp; &nbsp; &nbsp; Set-PnPListItem -List $ListName -Identity $listItem.Id -Values $itemValue&nbsp; &nbsp; &nbsp; &nbsp; Write-Host "Updated site: $Title" -ForegroundColor Yellow&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; # Add item&nbsp; &nbsp; &nbsp; &nbsp; Add-PnPListItem -List $ListName -Values $itemValue&nbsp; &nbsp; &nbsp; &nbsp; Write-Host "Added site: $Title" -ForegroundColor Green&nbsp; &nbsp; }}

nicolaskheirallah · Answer

AHun78&nbsp;&nbsp;This should do the trick for you I understood correctly, modify "Name='Title'" to the field you have the SITE.url in&nbsp;# Connect to the SharePoint Online site
Connect-PnPOnline -Url "https://yoursite.sharepoint.com/" -Interactive

# Get the list object
$list = Get-PnPList -Identity "yourList"

# Check if an item with the same title exists in the list 
$existingItem = Get-PnPListItem -List $list -Query "&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='Title' /&gt;&lt;Value Type='Text'&gt;$($item.Title)&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;"

# If the item exists, update the other fields
    if ($existingItem) {
        Set-PnPListItem -List $list -Identity $existingItem.Id -Values $item
        Write-Host "Updated item with title $($item.Title)"
    }
    # If the item does not exist, create a new item
    else {
        Add-PnPListItem -List $list -Values $item
        Write-Host "Created new item with title $($item.Title)"
    }&nbsp;

ahun78 · Answer

&nbsp;Thanks for the reply... 🙂&nbsp;I tried doing that but it doesn't resolve the issue... The item always get's created as a new item rather than updating existing item# Connect to Microsoft 365
Connect-PnPOnline -Url "https://&lt;tenant&gt;.sharepoint.com" -Interactive
# Get all sites
$sites = Get-PnPTenantSite -Template "GROUP#0"

$SiteDirectoryURL = “https://&lt;tenant&gt;.sharepoint.com/sites/SPOSiteProvisioning”
Connect-PnPOnline -Url $SiteDirectoryURL -Interactive

$ListName = “Site Directory” # Site Directory list name

foreach ($site in $sites) {
    # Connect to the site
    $siteConnect = Connect-PnPOnline -Url $site.Url -Interactive -ReturnConnection

# Get the root web with "created" property
    $Web = Get-PnPWeb -Includes Created -Connection $siteConnect

# Get site details
    if ($site.Template -like "GROUP*") {
        # Get Group Owners
        $GroupOwners = (Get-PnPMicrosoft365GroupOwners -Identity $site.GroupId.Guid -Connection $siteConnect | Select-Object -ExpandProperty Email) -join "; "
    } else {
        $GroupOwners = $site.Owner
    }

# Prepare item values
    $itemValue = @{
        "GUID" = $site.GroupId;
        "Title" = $site.Title;
        "URL" = $site.Url;
        "SiteDescription" = $site.Description;
        "SiteTemplate" = $site.Template;
        "SiteOwner" = $GroupOwners;
        "PrivacySetting" = $site.Visibility; # Privacy setting
        "ExternalSharing" = $site.SharingCapability; # External sharing capability
        "CreatedOn" = $web.Created.ToString("dd/MM/yyyy HH:mm:ss") # Site creation date
    }

# Check if an item with the same URL exists in the list
$listItem = Get-PnPListItem -List $ListName -Query "&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='URL' /&gt;&lt;Value Type='Text'&gt;${site.Url}&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;"

# If the item exists, update the other fields
if ($listItem) {
    Set-PnPListItem -List $ListName -Identity $listItem -Values $itemValue
    Write-Host "Updated item with title: $($itemValue.Title)" -ForegroundColor Yellow
}
# If the item does not exist, create a new item
else {
    Add-PnPListItem -List $ListName -Values $itemValue
    Write-Host "Created new item with title: $($itemValue.Title)" -ForegroundColor Green
}

}&nbsp;

nicolaskheirallah · Answer

What value to do you get one $listItem?Because it sounds like it's not matching at all, so that's why. Is the URL field a Single line of text field or URL field?

Forum Discussion

PnP PowerShell Check if items exists in List

Share

Resources