SOLVED

Best Method to Port a SP List to a New M365 Tenant?

%3CLINGO-SUB%20id%3D%22lingo-sub-1679532%22%20slang%3D%22en-US%22%3EBest%20Method%20to%20Port%20a%20SP%20List%20to%20a%20New%20M365%20Tenant%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679532%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20best%20method%20to%20port%20a%20SP%20list%20from%20one%20tenant%20to%20another%3F%26nbsp%3B%20Some%20of%20my%20lists%20are%20used%20as%20data%20sources%20for%20Power%20Apps%20so%20I%20need%20a%20quick%20method%20for%20porting%20these%20lists%20from%20one%20tenant%20to%20another.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1679806%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20Method%20to%20Port%20a%20SP%20List%20to%20a%20New%20M365%20Tenant%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679806%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246794%22%20target%3D%22_blank%22%3E%40cgtrman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20SharePoint%20PnP%20PowerShell%20(%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%3C%2FA%3E%3A(%3C%2Fimg%3E%3C%2FP%3E%3COL%3E%3CLI%3EConnect%20to%20your%20source%20tenant%20site%3A%26nbsp%3BConnect-PnPOnline%20-Url%20%3CA%20href%3D%22https%3A%2F%2Fsource.sharepoint.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsource.sharepoint.com%3C%2FA%3E%20-Credentials%20(Get-Credential)%3C%2FLI%3E%3CLI%3EExtract%20the%20list%20as%20a%20template%3A%20Get-PnPProvisioningTemplate%20-Out%20template.pnp%20-ListsToExtract%20%22Title%20of%20List%22%3C%2FLI%3E%3CLI%3EConnect%20to%20your%20target%20tenant%20site%3A%26nbsp%3BConnect-PnPOnline%20-Url%20%3CA%20href%3D%22https%3A%2F%2Ftarget.sharepoint.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftarget.sharepoint.com%3C%2FA%3E%20-Credentials%20(Get-Credential)%3C%2FLI%3E%3CLI%3EApply%20the%20extracted%20template%3A%20Apply-PnPProvisioningTemplate%20-Path%20template.xml%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Contributor

What is the best method to port a SP list from one tenant to another?  Some of my lists are used as data sources for Power Apps so I need a quick method for porting these lists from one tenant to another. 

3 Replies
best response confirmed by cgtrman (Contributor)
Solution

@cgtrman 

 

Use SharePoint PnP PowerShell (https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp)

  1. Connect to your source tenant site: Connect-PnPOnline -Url https://source.sharepoint.com -Credentials (Get-Credential)
  2. Extract the list as a template: Get-PnPProvisioningTemplate -Out template.xml -ListsToExtract "Title of List"
  3. Connect to your target tenant site: Connect-PnPOnline -Url https://target.sharepoint.com -Credentials (Get-Credential)
  4. Apply the extracted template: Apply-PnPProvisioningTemplate -Path template.xml

@Maggan Wåhlin Thank you for your quick response.  Unfortunately, I able to access site in PS but I get the following error: "Access denied. You do not have permission to perform this action or access this resource."  Looks like I will require someone with admin privileges. Thanks for the code, though! 

Sorry, forgot to mention:

You first need to connect to the tenant:

Connect-SPOService -Url https://tenant-admin.sharepoint.com

You will need SharePoint Online Admin rights.