LazyAdmin

Tips from an other Admin

Copy Sharepoint list items to another list with Powershell and PnP

Please share this with your friends..

You can easily copy Sharepoint list items to another list with Powershell and PnP.

First connect to the source Sharepoint site. You can use one of mine connector scripts for it here at Technet. Or connect to Sharepoint with:

Get the list items

Now we need to retrieve the list items that we want to copy:

Copy the items to the destination list

Now it’s time to copy the data. First connect to the destination site (if the list is at another Sharepoint site)

A few important notes (that took me a few hours to figure out)

In Sharepoint, list columns can have a different internal name then you see when open Sharepoint. To get all the available list names, run the following cmdlet

If one of the columns in the list contains a hyperlink, than you can get the content from it with: