We need to fetch data from one SharePoint list and then update those fields data into another SharePoint list using PnP PowerShell. Can anyone please guide or share PnP script for us? Thanks in advance.

Note: We are using SharePoint Online

1 Answer 1

$Username='[email protected]'
$Password = '************'

#region Credentials
[SecureString]$SecurePass = ConvertTo-SecureString $Password -AsPlainText -Force
[System.Management.Automation.PSCredential]$PSCredentials = New-Object System.Management.Automation.PSCredential($Username, $SecurePass)
#endregion Credentials

#connect to hubsite
Connect-PnPOnline -Url 'https://Tenant.sharepoint.com/sites/SitrName' -Credentials $PSCredentials
$OlistItems = Get-PnPListItem -List 'OldList'
foreach($item in $OlistItems) {
        #Create object
  $itemVal = @{
    'Title' = $item['Title']
  Add-PnPListItem -List 'NewList' -Values $itemVal -ContentType "Item"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.