{"id":6475,"date":"2021-03-19T10:08:16","date_gmt":"2021-03-19T10:08:16","guid":{"rendered":"https:\/\/www.softreetechnology.com\/?p=6475"},"modified":"2021-03-19T10:08:16","modified_gmt":"2021-03-19T10:08:16","slug":"save-a-list-as-template-in-sharepoint-online-using-powershell","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/","title":{"rendered":"Save a list as template in SharePoint online using PowerShell"},"content":{"rendered":"\n

Introduction-<\/strong><\/strong><\/p>\n\n\n\n

In SharePoint, the list templates provide re-usability of columns without recreating it on every single site. For e.g. I have created a custom list which name is Project <\/strong>, in a SharePoint site collection with all relevant columns, Now I want this list structure in other site collections, without recreating the list on every single site.<\/p>\n\n\n\n

Steps to save a list or library as template:<\/strong><\/p>\n\n\n\n

Step-1<\/strong><\/p>\n\n\n\n

Go to a SharePoint list, then navigate to list settings present under the list tab on the ribbon and then click on list Settings.<\/p>\n\n\n\n

Step-2<\/strong><\/p>\n\n\n\n

Click on save list as Template<\/strong> under Permissions and Management group.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step-3<\/strong><\/p>\n\n\n\n

Provide template File name <\/strong>and Template name<\/strong>. If you want to include the content,<\/strong> then select the check box, Click Ok<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step-4<\/strong><\/p>\n\n\n\n

Click OK on the success page.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How to download the list template –<\/strong><\/p>\n\n\n\n

Step1- <\/strong>Go to site setting,<\/strong> Click on List Templates <\/strong>under web Designers and Gallery.<\/p>\n\n\n\n

Step2- <\/strong>Select your List Template <\/strong>and Click to download a copy <\/strong>in the Files tab.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also save the list template to your site by using powershell script-<\/strong><\/p>\n\n\n\n

 try{<\/p>\n\n\n\n

    Add-Type -Path “..\\Microsoft.SharePoint.Client.dll”<\/p>\n\n\n\n

    Add-Type -Path “..\\Microsoft.SharePoint.Client.Runtime.dll”<\/p>\n\n\n\n

    $SiteUrl = Read-Host “Enter the SiteUrl”<\/p>\n\n\n\n

    $UserName=Read-Host “Enter the username”<\/p>\n\n\n\n

    $Password =Read-Host -AsSecureString Password<\/p>\n\n\n\n

    $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n\n\n\n

    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,$Password)<\/p>\n\n\n\n

    $ctx.Credentials = $credentials<\/p>\n\n\n\n

    $Web=$Ctx.Web<\/p>\n\n\n\n

    $site=$Ctx.Site<\/p>\n\n\n\n

    $ctx.Load($web)<\/p>\n\n\n\n

    $ctx.Load($site)<\/p>\n\n\n\n

    $ctx.ExecuteQuery()<\/p>\n\n\n\n

    $ListName=Read-Host “Enter the List Name”<\/p>\n\n\n\n

    $list = $Ctx.Web.lists.GetByTitle($ListName)<\/p>\n\n\n\n

    $FileName=Read-Host “Enter the File Name”<\/p>\n\n\n\n

    $TemplateName=Read-Host “Enter the Template Name”<\/p>\n\n\n\n

    $list.SaveAsTemplate($FileName, $TemplateName, “list template description”, $true)<\/p>\n\n\n\n

    $ctx.ExecuteQuery()<\/p>\n\n\n\n

    Write-Host -ForegroundColor Green “Successfully save the list Template.”<\/p>\n\n\n\n

     sleep 10<\/p>\n\n\n\n

 }<\/p>\n\n\n\n

    catch<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        Write-Host -ForegroundColor Red ‘Error ‘,’:’$Error[0].ToString();<\/p>\n\n\n\n

        sleep 10<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

Follow below screenshot and enter the values to the parameters accordingly. Then you can get a successful message.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How to upload list template to another site <\/strong>–<\/strong><\/p>\n\n\n\n

Step1- <\/strong>Go to site setting,<\/strong> Click on List Templates <\/strong>under web Designers and Gallery.<\/p>\n\n\n\n

Step2- <\/strong>Click on Upload Document <\/strong>on the Files tab then browses your file i.e. Demo. Stop<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Step3- Save <\/strong>the list template.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Step4- <\/strong>Go to Site contents<\/strong>, Click on New<\/strong> then select App<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step5- <\/strong>Select your template.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step6- <\/strong>Provide a list Name<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step7- <\/strong>Now your list added to the site successfully.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also add the list template to your site by using PowerShell script-<\/strong><\/p>\n\n\n\n

 try{<\/p>\n\n\n\n

    Add-Type -Path “..\\Microsoft.SharePoint.Client.dll”<\/p>\n\n\n\n

    Add-Type -Path “..\\Microsoft.SharePoint.Client.Runtime.dll”<\/p>\n\n\n\n

    $SiteUrl = Read-Host “Enter the SiteUrl”<\/p>\n\n\n\n

    $UserName=Read-Host “Enter the username”<\/p>\n\n\n\n

    $Password =Read-Host -AsSecureString Password<\/p>\n\n\n\n

    $ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<\/p>\n\n\n\n

    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,$Password)<\/p>\n\n\n\n

    $ctx.Credentials = $credentials<\/p>\n\n\n\n

    $Web=$ctx.Web<\/p>\n\n\n\n

    $site=$ctx.Site<\/p>\n\n\n\n

    $ctx.Load($web)<\/p>\n\n\n\n

    $ctx.Load($site)<\/p>\n\n\n\n

    $ctx.ExecuteQuery()<\/p>\n\n\n\n

    $Template =$site.GetCustomListTemplates($Web)<\/p>\n\n\n\n

    $Lists = $ctx.Web.Lists<\/p>\n\n\n\n

    $ctx.Load($Lists)<\/p>\n\n\n\n

    $ctx.Load($Template)<\/p>\n\n\n\n

    $ctx.ExecuteQuery()<\/p>\n\n\n\n

    $TemplateName=Read-Host “Enter the Template Name”<\/p>\n\n\n\n

    $ListName=Read-Host “Enter the List Name”<\/p>\n\n\n\n

    $ListTemplate = $Template | where { $_.Name -eq $TemplateName }<\/p>\n\n\n\n

    $List = $Lists | where {$_.Title -eq $ListName}<\/p>\n\n\n\n

    If($List -eq $Null)<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        $ListCreation = New-Object Microsoft.SharePoint.Client.ListCreationInformation<\/p>\n\n\n\n

        $ListCreation.Title = $ListName<\/p>\n\n\n\n

        $ListCreation.ListTemplate = $ListTemplate<\/p>\n\n\n\n

        $List = $Lists.Add($ListCreation)<\/p>\n\n\n\n

        $ctx.ExecuteQuery()<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

    Write-Host -ForegroundColor Green “Successfully Add the list.”<\/p>\n\n\n\n

     sleep 10<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

    catch<\/p>\n\n\n\n

    {<\/p>\n\n\n\n

        Write-Host -ForegroundColor Red ‘Error ‘,’:’$Error[0].ToString();<\/p>\n\n\n\n

        sleep 10<\/p>\n\n\n\n

    }<\/p>\n\n\n\n

Follow below screenshot and enter the values to the parameters accordingly. Then you can get a successful message.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Key Words:<\/span><\/strong><\/p>\n\n\n\n

-Create and save a list as template in SharePoint online using PowerShell
-Create and add the template in SharePoint site using pnp PowerShell.
-How to create and add list template in SharePoint online using PowerShell?
-Create list template and add the list template to another site using PowerShell.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction- In SharePoint, the list templates provide re-usability of columns without recreating it on every single site. For e.g. I have created a custom list which name is Project , in a SharePoint site collection with all relevant columns, Now I want this list structure in other site collections, without recreating the list on every single site. Steps to save […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[221],"tags":[],"class_list":["post-6475","post","type-post","status-publish","format-standard","hentry","category-powershell"],"yoast_head":"\nSave a list as template in SharePoint online using PowerShell - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Save a list as template in SharePoint online using PowerShell - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"Introduction- In SharePoint, the list templates provide re-usability of columns without recreating it on every single site. For e.g. I have created a custom list which name is Project , in a SharePoint site collection with all relevant columns, Now I want this list structure in other site collections, without recreating the list on every single site. Steps to save […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-19T10:08:16+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Save a list as template in SharePoint online using PowerShell - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Save a list as template in SharePoint online using PowerShell - Softree Technology","og_description":"Introduction- In SharePoint, the list templates provide re-usability of columns without recreating it on every single site. For e.g. I have created a custom list which name is Project , in a SharePoint site collection with all relevant columns, Now I want this list structure in other site collections, without recreating the list on every single site. Steps to save […]","og_url":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/","og_site_name":"Softree Technology","article_published_time":"2021-03-19T10:08:16+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Save a list as template in SharePoint online using PowerShell","datePublished":"2021-03-19T10:08:16+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/"},"wordCount":862,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/03\/son1.png","articleSection":["PowerShell"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/","url":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/","name":"Save a list as template in SharePoint online using PowerShell - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/03\/son1.png","datePublished":"2021-03-19T10:08:16+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#primaryimage","url":"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/03\/son1.png","contentUrl":"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2021\/03\/son1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/powershell\/save-a-list-as-template-in-sharepoint-online-using-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Save a list as template in SharePoint online using PowerShell"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=6475"}],"version-history":[{"count":0,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/6475\/revisions"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=6475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=6475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=6475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}