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

Popular posts from this blog

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'); });

ALM in Power Platform

ALM in Power Platform $SecurePassword = ConvertTo-SecureString 'pw123' -AsPlainText -Force $creds = New-Object System.Management.Automation.PSCredential ('name@email.com', $SecurePassword) $Connection = Get-CrmConnection -OnLineType OAuth -OrganizationName 'orgname' -DeploymentRegion 'Oceania' -Credential $creds $EnvVariableId is the GUID of the environment variable function Update-EnvVariable ( [Guid] $EnvVariableId, [Microsoft.Xrm.Tooling.Connector.CrmServiceClient] $Connection ) { $updateFields = @{ } $updateFields.Add("value", $Value) Set-CrmRecord -conn $Connection -Fields $updateFields -Id $EnvVariableId -EntityLogicalName "environmentvariablevalue" } Update-EnvVariable - $EnvVariableId -$Connection

Get Oauth token in Power Automate

 Get Oauth token in Power Automate