Invoke-PnPSiteTemplate - Error: The formula refers to a column that does not exist.

%3CLINGO-SUB%20id%3D%22lingo-sub-2330657%22%20slang%3D%22en-US%22%3EInvoke-PnPSiteTemplate%20-%20Error%3A%20The%20formula%20refers%20to%20a%20column%20that%20does%20not%20exist.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330657%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20my%20first%20post%20here%2C%20so%20please%20have%20mercy%20with%20me%20in%20case%20I%20forgot%20to%20write%20down%20important%20information%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20goal%20is%20to%20create%20a%20template%20from%20a%20SharePoint%20site%20and%20then%20apply%20it%20to%20a%20manually%20created%20SharePoint%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20way%20I%20created%20the%20SharePoint%20template%20(the%20template%20was%20successfully%20created).%20I%20tried%20it%20once%20with%20more%20and%20once%20fewer%20parameters%20to%20see%20if%20it%20makes%20a%20difference%20while%20applying%20the%20template.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EGet-PnPSiteTemplate%20-Out%20C%3A%5CSharePointTemplates%5CGermany-Urlaub.pnp%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeAllTermGroups%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeAllClientSidePages%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeHiddenLists%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeNativePublishingFiles%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeSearchConfiguration%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeSiteCollectionTermGroup%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeSiteGroups%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeTermGroupsSecurity%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EGet-PnPSiteTemplate%20-Out%20C%3A%5CSharePointTemplates%5CGermany-Urlaub.pnp%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeAllTermGroups%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeHiddenLists%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-IncludeSiteCollectionTermGroup%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E-PersistBrandingFiles%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20sued%20the%20following%20command%20to%20apply%20the%20template%20(obviously%20I%20switched%20to%20the%20manually%20created%20SharePoint%20site)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EInvoke-PnPSiteTemplate%20-Path%20C%3A%5CSharePointTemplates%5CGermany-Urlaub.pnp%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20I%20received%20the%20error%20I%20used%20%22Get-PnPException%22%20to%20get%20more%20details%20about%20the%20error.%20Prior%20to%20that%2C%20I%20tried%20to%20create%20a%20log%20file%20with%20the%20following%20command%20(for%20some%20kind%20of%20reason%20the%20log%20file%20is%20always%20empty)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESet-PnPTraceLog%20-On%20-LogFile%20C%3A%5CSharePointTemplates%5Clog.txt%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyways%20the%20extended%20error%20message%20with%26nbsp%3B%22Get-PnPException%22%20is%20the%20following%20one.%20I%20do%20not%20understand%20which%20column%20is%20meant.%20How%20can%20I%20find%20out%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tom_Falk_0-1620294910407.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278718iAB1A0CEFD13FFE6D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Tom_Falk_0-1620294910407.png%22%20alt%3D%22Tom_Falk_0-1620294910407.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPnP%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everyone,

 

this is my first post here, so please have mercy with me in case I forgot to write down important information ;)

 

So my goal is to create a template from a SharePoint site and then apply it to a manually created SharePoint site.

 

This is the way I created the SharePoint template (the template was successfully created). I tried it once with more and once fewer parameters to see if it makes a difference while applying the template.

 

Get-PnPSiteTemplate -Out C:\SharePointTemplates\Germany-Urlaub.pnp

-IncludeAllTermGroups

-IncludeAllClientSidePages

-IncludeHiddenLists

-IncludeNativePublishingFiles

-IncludeSearchConfiguration

-IncludeSiteCollectionTermGroup

-IncludeSiteGroups

-IncludeTermGroupsSecurity

 

Get-PnPSiteTemplate -Out C:\SharePointTemplates\Germany-Urlaub.pnp

-IncludeAllTermGroups

-IncludeHiddenLists

-IncludeSiteCollectionTermGroup

-PersistBrandingFiles

 

Then I sued the following command to apply the template (obviously I switched to the manually created SharePoint site)

 

Invoke-PnPSiteTemplate -Path C:\SharePointTemplates\Germany-Urlaub.pnp

 

After I received the error I used "Get-PnPException" to get more details about the error. Prior to that, I tried to create a log file with the following command (for some kind of reason the log file is always empty):

 

Set-PnPTraceLog -On -LogFile C:\SharePointTemplates\log.txt

 

Anyways the extended error message with "Get-PnPException" is the following one. I do not understand which column is meant. How can I find out?

 

Tom_Falk_0-1620294910407.png

 



 

 

 

0 Replies