In Site Design how to associate metadata term with site column?

%3CLINGO-SUB%20id%3D%22lingo-sub-242331%22%20slang%3D%22en-US%22%3EIn%20Site%20Design%20how%20to%20associate%20metadata%20term%20with%20site%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242331%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20%3CSTRONG%3Esite%20design%20%3C%2FSTRONG%3E%7B%3CA%20title%3D%22Schema%20documentation%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fsite-design-json-schema%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESchema%20documentation%3C%2FA%3E%7D%20to%20create%20new%20sites.%20Expecting%26nbsp%3Bnew%20sites%20created%20from%20site%20design%20will%20have%20site%20columns%2C%20Content%20types%20and%20Lists.%20I%20able%20to%20provision%20column%2C%20content%20type%20and%20list%20but%20facing%20issue%20with%20site%20column%20type%20%22%3CSTRONG%3ETaxonomyFieldTypeMulti%3C%2FSTRONG%3E%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20associate%20column%20with%20existing%20Term%20in%20my%20tenant.%20In%20On%20premise%20we%20can%20do%20this%20association%20on%20feature%20activation%20but%20in%20office%20365%20we%20have%20limitations.%20Please%20suggest%20code%20or%20alternative.%26nbsp%3B%3C%2FP%3E%3CP%3Ecode%20is%20as%20below%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1st%20Attempt%20%5Btried%20PnP%20site%20template%20style%5D--%3C%2FP%3E%3CP%3E%3CEM%3E%7B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22verb%22%3A%20%22createSiteColumnXml%22%2C%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22schemaXml%22%3A%20%22%3CFIELD%20id%3D%22%5C%26quot%3B%7B4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652%7D%5C%26quot%3B%22%20staticname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20name%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20displayname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20type%3D%22%5C%26quot%3BTaxonomyFieldTypeMulti%5C%26quot%3B%22%20group%3D%22%5C%26quot%3BMygrp%5C%26quot%3B%22%3E%3CTAXONOMYGROUP%20id%3D%22%5C%26quot%3Ba8674c62-e812-4e23-88fc-a449958e53ea%5C%26quot%3B%22%3ECars%3C%2FTAXONOMYGROUP%3E%3CTERMSET%20id%3D%22%5C%26quot%3Bd92adc9e-eba7-4734-ac56-ae82483bf1c0%5C%26quot%3B%22%3EEngine%3C%2FTERMSET%3E%3C%2FFIELD%3E%22%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%7D%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2nd%20Attempt%20--%3C%2FP%3E%3CP%3E%3CEM%3E%7B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22verb%22%3A%20%22createSiteColumnXml%22%2C%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22schemaXml%22%3A%20%22%3CFIELD%20id%3D%22%5C%26quot%3B%7B4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652%7D%5C%26quot%3B%22%20showfield%3D%22%5C%26quot%3BTerm1033%5C%26quot%3B%22%20staticname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20name%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20displayname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20type%3D%22%5C%26quot%3BTaxonomyFieldType%5C%26quot%3B%22%20group%3D%22%5C%26quot%3BMygrp%5C%26quot%3B%22%3E%3C%2FFIELD%3E%22%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%7D%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3rd%20Attempt%20--%3C%2FP%3E%3CP%3E%3CEM%3E%7B%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22verb%22%3A%20%22createSiteColumnXml%22%2C%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%22schemaXml%22%3A%20%22%3CFIELD%20id%3D%22%5C%26quot%3B%7B4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652%7D%5C%26quot%3B%22%20showfield%3D%22%5C%26quot%3BEngine1033%5C%26quot%3B%22%20staticname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20name%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20displayname%3D%22%5C%26quot%3BEngine%5C%26quot%3B%22%20type%3D%22%5C%26quot%3BTaxonomyFieldType%5C%26quot%3B%22%20group%3D%22%5C%26quot%3BMygrp%5C%26quot%3B%22%3E%3C%2FFIELD%3E%22%3C%2FEM%3E%3CBR%20%2F%3E%3CEM%3E%7D%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BTerms%20are%20below%20%3A%26nbsp%3B%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44871i29C5E092AC04AED5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22TenantTerm.png%22%20title%3D%22TenantTerm.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReference%20%3A%26nbsp%3B%3CA%20title%3D%22MetaData%20column%20association%20on%20termset%20in%20tenant%20in%20site%20design%20schema.%22%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-docs%2Fissues%2F2470%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%232470%20on%20Github%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-242331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482529%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Site%20Design%20how%20to%20associate%20metadata%20term%20with%20site%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482529%22%20slang%3D%22en-US%22%3E%3CP%3EI%20managed%20to%20add%20a%20site%20column%20using%20the%20script%20below%3A%20-%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%7B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22actions%22%3A%20%5B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7B%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22verb%22%3A%20%22createSiteColumnXml%22%2C%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22schemaXml%22%3A%20%22%3CFIELD%20type%3D%22%5C%26quot%3BNote%5C%26quot%3B%22%20displayname%3D%22%5C%26quot%3B%7BFieldName%7D_0%5C%26quot%3B%22%20staticname%3D%22%5C%26quot%3B%7BStaticName%7D%5C%26quot%3B%22%20sourceid%3D%22%5C%26quot%3Bhttp%3A%5C%2F%5C%2Fschemas.microsoft.com%5C%2Fsharepoint%5C%2Fv3%5C%26quot%3B%22%20name%3D%22%5C%26quot%3B%7BStaticName%7D%5C%26quot%3B%22%20id%3D%22%5C%26quot%3BXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX%5C%26quot%3B%22%20showinviewforms%3D%22%5C%26quot%3BFALSE%5C%26quot%3B%22%20required%3D%22%5C%26quot%3BFALSE%5C%26quot%3B%22%20hidden%3D%22%5C%26quot%3BTRUE%5C%26quot%3B%22%20cantogglehidden%3D%22%5C%26quot%3BTRUE%5C%26quot%3B%22%3E%3C%2FFIELD%3E%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7D%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7B%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22verb%22%3A%20%22createSiteColumnXml%22%2C%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22schemaXml%22%3A%20%22%3CFIELD%20type%3D%22%5C%26quot%3BTaxonomyFieldType%5C%26quot%3B%22%20name%3D%22%5C%26quot%3B%7BFieldname%7D%5C%26quot%3B%22%20sourceid%3D%22%5C%26quot%3Bhttp%3A%5C%2F%5C%2Fschemas.microsoft.com%5C%2Fsharepoint%5C%2Fv3%5C%26quot%3B%22%20staticname%3D%22%5C%26quot%3B%7BFieldName%7D%5C%26quot%3B%22%20displayname%3D%22%5C%26quot%3BArticleType%5C%26quot%3B%22%20group%3D%22%5C%26quot%3BCustom%22%20columns%3D%22%22%3E%20%3CDEFAULT%3E%3C%2FDEFAULT%3E%20%3CCUSTOMIZATION%3E%20%3CARRAYOFPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3ESspId%3C%2FNAME%3E%20%3CVALUE%20q1%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q1%3Astring%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3BYYYYYYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3EGroupId%3C%2FNAME%3E%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3ETermSetId%3C%2FNAME%3E%20%3CVALUE%20q2%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q2%3Astring%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3BZZZZZZZZ-ZZZZ-ZZZZ-ZZZZ-ZZZZZZZZZZZZ%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3ETextField%3C%2FNAME%3E%20%3CVALUE%20q6%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q6%3Astring%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3B00000000-0000-0000-0000-000000000000%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3EAnchorId%3C%2FNAME%3E%20%3CVALUE%20q3%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q3%3Astring%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3B00000000-0000-0000-0000-000000000000%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%3CNAME%3ETextField%3C%2FNAME%3E%3CVALUE%20q6%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q6%3Astring%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3BXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX%3C%2FA%3E%3C%2FVALUE%3E%3C%2FPROPERTY%3E%26gt%3B%20%3CPROPERTY%3E%20%3CNAME%3EIsPathRendered%3C%2FNAME%3E%20%3CVALUE%20q7%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q7%3Aboolean%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3Bfalse%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3EIsKeyword%3C%2FNAME%3E%20%3CVALUE%20q8%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q8%3Aboolean%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3Bfalse%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3CPROPERTY%3E%20%3CNAME%3EOpen%3C%2FNAME%3E%20%3CVALUE%20q5%3D%22%5C%26quot%3B%26lt%3BA%22%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%22%3E%3CA%20href%3D%22http%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%5C%3C%2FA%3E%22%20p4%3Atype%3D%5C%22q5%3Aboolean%5C%22%20xmlns%3Ap4%3D%5C%22%3CA%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema-instance%5C%22%26gt%3Bfalse%3C%2FA%3E%3C%2FVALUE%3E%26gt%3B%20%3C%2FPROPERTY%3E%20%3C%2FARRAYOFPROPERTY%3E%20%3C%2FCUSTOMIZATION%3E%20%3C%2FFIELD%3E%22%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7D%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7D%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3EThe%20XXXX%20-%20GUID%20was%20for%20the%20new%20field%20and%20the%20YYYY%20and%20ZZZZ%20guids%20need%20to%20come%20from%20the%20term%20store.%20However%2C%20it%20was%26nbsp%3Bultimately%20a%20waste%20of%20time%20because%20the%20search%20didn't%20work%20against%20the%20new%20fields%20that%20I%20created%20so%20ended%20up%20using%20using%20the%20PnP%20script%20below%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CP%3EConnect-PnPOnline%20%22https%3A%2F%2F%7Btennancy%7D.sharepoint.com%2Fsites%2F%7Bsitename%7D%22%20-UseWebLogin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd-PnPTaxonomyField%20-DisplayName%20%22ArticleType%22%20-InternalName%20%22%7Bfieldname%7D%22%20-TermSetPath%20%22%7Btermset%7D%7C%7Bterms%7D%22%26nbsp%3B%26nbsp%3B%20-Group%20%22Custom%20Columns%22%20-MultiValue%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd-pnpfield%26nbsp%3B%20-field%20ArticleType%20-List%20SitePages%3C%2FP%3E%3CBR%20%2F%3EI'm%20still%20waiting%20for%20this%20functionality%20to%20be%20added%20to%20site%20designs%20-%20something%20that%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5937%22%20target%3D%22_blank%22%3E%40Sean%20Squires%3C%2FA%3E%26nbsp%3Bsuggested%20would%20be%20coming%20on%20twitter%20-%20so%20that%20I%20can%20do%20it%20properly%20with%20site%20designs.%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

Hello,

 

I am using site design {Schema documentation} to create new sites. Expecting new sites created from site design will have site columns, Content types and Lists. I able to provision column, content type and list but facing issue with site column type "TaxonomyFieldTypeMulti".

 

I would like to associate column with existing Term in my tenant. In On premise we can do this association on feature activation but in office 365 we have limitations. Please suggest code or alternative. 

code is as below :

 

1st Attempt [tried PnP site template style]--

{
"verb": "createSiteColumnXml",
"schemaXml": "<Field ID=\"{4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652}\" StaticName=\"Engine\" Name=\"Engine\" DisplayName=\"Engine\" Type=\"TaxonomyFieldTypeMulti\" Group=\"Mygrp\"><TaxonomyGroup ID=\"a8674c62-e812-4e23-88fc-a449958e53ea\">Cars</TaxonomyGroup><TermSet ID=\"d92adc9e-eba7-4734-ac56-ae82483bf1c0\">Engine</TermSet></Field>"
}

 

2nd Attempt --

{
"verb": "createSiteColumnXml",
"schemaXml": "<Field ID=\"{4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652}\" ShowField=\"Term1033\" StaticName=\"Engine\" Name=\"Engine\" DisplayName=\"Engine\" Type=\"TaxonomyFieldType\" Group=\"Mygrp\"></Field>"
}

 

3rd Attempt --

{
"verb": "createSiteColumnXml",
"schemaXml": "<Field ID=\"{4EDAD5E3-AAAB-48AA-8F7B-2A70ECA14652}\" ShowField=\"Engine1033\" StaticName=\"Engine\" Name=\"Engine\" DisplayName=\"Engine\" Type=\"TaxonomyFieldType\" Group=\"Mygrp\"></Field>"
}

 

 Terms are below : 

 

TenantTerm.png

 

Reference : #2470 on Github 

 

1 Reply
Highlighted

I managed to add a site column using the script below: - 

{
"actions": [
{
"verb": "createSiteColumnXml",
"schemaXml": "<Field Type=\"Note\" DisplayName=\"{FieldName}_0\" StaticName=\"{StaticName}\" SourceID=\"http:\/\/schemas.microsoft.com\/sharepoint\/v3\" Name=\"{StaticName}\" ID=\"XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX\" ShowInViewForms=\"FALSE\" Required=\"FALSE\" Hidden=\"TRUE\" CanToggleHidden=\"TRUE\" />"
},
{
"verb": "createSiteColumnXml",
"schemaXml": "<Field Type=\"TaxonomyFieldType\" Name=\"{Fieldname}\" SourceID=\"http:\/\/schemas.microsoft.com\/sharepoint\/v3\" StaticName=\"{FieldName}\" DisplayName=\"ArticleType\" Group=\"Custom Columns\" ShowField=\"Term1033\" Required=\"FALSE\" EnforceUniqueValues=\"FALSE\" Mult=\"TRUE\"> <Default></Default> <Customization> <ArrayOfProperty> <Property> <Name>SspId</Name> <Value xmlns:q1=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q1:string\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">YYYYYYYY-YYYY-YYYY-YYYY-YYYYYYYYYYYY</Value> </Property> <Property> <Name>GroupId</Name> </Property> <Property> <Name>TermSetId</Name> <Value xmlns:q2=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q2:string\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">ZZZZZZZZ-ZZZZ-ZZZZ-ZZZZ-ZZZZZZZZZZZZ</Value> </Property> <Property> <Name>TextField</Name> <Value xmlns:q6=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q6:string\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">00000000-0000-0000-0000-000000000000</Value> </Property> <Property> <Name>AnchorId</Name> <Value xmlns:q3=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q3:string\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">00000000-0000-0000-0000-000000000000</Value> </Property> <Property><Name>TextField</Name><Value xmlns:q6=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q6:string\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX</Value></Property> <Property> <Name>IsPathRendered</Name> <Value xmlns:q7=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q7:boolean\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">false</Value> </Property> <Property> <Name>IsKeyword</Name> <Value xmlns:q8=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q8:boolean\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">false</Value> </Property> <Property> <Name>Open</Name> <Value xmlns:q5=\"http://www.w3.org/2001/XMLSchema\" p4:type=\"q5:boolean\" xmlns:p4=\"http://www.w3.org/2001/XMLSchema-instance\">false</Value> </Property> </ArrayOfProperty> </Customization> </Field>"
}
}
The XXXX - GUID was for the new field and the YYYY and ZZZZ guids need to come from the term store. However, it was ultimately a waste of time because the search didn't work against the new fields that I created so ended up using using the PnP script below 

Connect-PnPOnline "https://{tennancy}.sharepoint.com/sites/{sitename}" -UseWebLogin

 

Add-PnPTaxonomyField -DisplayName "ArticleType" -InternalName "{fieldname}" -TermSetPath "{termset}|{terms}"   -Group "Custom Columns" -MultiValue

 

Add-pnpfield  -field ArticleType -List SitePages


I'm still waiting for this functionality to be added to site designs - something that @Sean Squires suggested would be coming on twitter - so that I can do it properly with site designs.