Forum Discussion

Rosie Horn's avatar
Rosie Horn
Copper Contributor
Jan 08, 2023
Solved

Update the field of all items in a Library using pnp Powershell

Hello,

I need to update a field of all the items in a Library to a new value.

I am using pnp Powershell and want to continue with pnp please.

My example for testing is below -  the result I get it "error"

$items = Get-PnPListItem -List "Documents" -Fields "Title"
Foreach ($item in $items)
{
try
{

(Set-PnPListItem -List "Documents" Identity $item.Id -Values @{"Title" = "NewTitle-Test"})
}

catch
{
Write-Host "error"
}
}

 

Many thanks

Rosie

admin
Document Library
powershell
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Jan 09, 2023

    Hi Rosie Horn 

     

    you were missing a "-" in front of the "identity" parameter.... This script works

    $items = Get-PnPListItem -List "Documents" -Fields "Title"
Foreach ($item in $items) {
    try {
       Set-PnPListItem -List "Documents" -Identity $item.Id -Values @{"Title" = "NewTitle-Test" }
    }
    catch {
        Write-Host "error"
    }
}

     

    Best Regards,
    Sven

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Jan 09, 2023

    Hi Rosie Horn 

     

    you were missing a "-" in front of the "identity" parameter.... This script works

    $items = Get-PnPListItem -List "Documents" -Fields "Title"
Foreach ($item in $items) {
    try {
       Set-PnPListItem -List "Documents" -Identity $item.Id -Values @{"Title" = "NewTitle-Test" }
    }
    catch {
        Write-Host "error"
    }
}

     

    Best Regards,
    Sven

Resources