Skip to main content

Update SPO List Items in batch using PnP PowerShell

Updating SharePoint List Items using PnP-PowerShell


$SiteURL="https://saiprasadp.sharepoint.com/sites/TestClassic"
$ListName= "Test List"
$SPQuery = "<View><Query><Where><Eq><FieldRef Name='Urgency'/><Value Type='text'>High2</Value></Eq></Where></Query></View>"

#Connect to PNP Online
Connect-PnPOnline -Url $SiteURL -UseWeblogin

#sharepoint online pnp powershell get list items
$ListItems = Get-PnPListItem -List $ListName -Query $SPQuery

#Update items in batch
$batch = New-PnPBatch
foreach($ListItem in $ListItems)
{
    Write-Host "ID:" $ListItem["ID"]
    Set-PnPListItem -List $ListName -Identity $ListItem["ID"] -Values @{"Title"="Updated Title1"} -UpdateType UpdateOverwriteVersion -Batch $batch
}
Invoke-PnPBatch -Batch $batch

Comments

Post a Comment

Popular posts from this blog

Dynamics 365 services

 Dynamics 365 Services Dynamics 365 Field Service app you can generate work orders with required products and services to be delivered. Also, it allows you to keep track of supplies (serviceable assets) and their inventory in locations like warehouses, field service vehicles, etc. You can schedule resources on work orders based on their availability and skillset and manage their mobile workforce. Dynamics 365 Customer Service  allows taking support requests from their clients via phone call, email, web, social media, and capture using a case form. You can also keep track of contracts for each client using entitlements. These entitlements can be based on the number of hours or number of cases. Entitlements, along with Service Level Agreements (SLAs), ensure timely service delivery and improves customer satisfaction level. Dynamics 365 Marketing you can define a customer journey that helps in developing and nurturing leads through a personalized experience. With the rich editor,...
Post a Comment
Read more

How to Use Batch to call SharePoint Rest API in PnP-JS

Using Batch in PnP-JS import { sp } from "@pnp/sp/presets/all"; import { dateAdd } from "@pnp/common"; const batch = sp.web.createBatch(); var ListsArr = ["Admin_Test", "Test_attch","TestCopy"] ListsArr.forEach((list)=>{ sp.web.getList(`sites/MyTeamSite/Lists/${list}`).items.inBatch(batch).usingCaching({ expiration: dateAdd(new Date(), "minute", 2), key: `cache_${list}`, storeName: "local" }).get() .then(items1 => { console.log(items1); }); }) // this line executes actual HTTP request to $batch endpoint batch.execute() .then(data => { // at this point all requests will be completed console.log('done'); });
Post a Comment
Read more