SOLVED

SharePoint 2019, column formatting not working

%3CLINGO-SUB%20id%3D%22lingo-sub-253902%22%20slang%3D%22en-US%22%3ESharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253902%22%20slang%3D%22en-US%22%3E%3CP%3EEnvironment%3A%20SharePoint%202019.%3C%2FP%3E%3CP%3EI%20am%20trying%20with%20column%20formatting.%20It%20is%20working%20fine%20with%20Online.%20Same%20code%20is%20not%20working%20in%20SP2019.%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20be%20office%20fabric%20is%20not%20loading%20as%20expected%20in%20SP2019.%20Is%20there%20any%20option%20to%20make%20it%20enable%20%3F%3C%2FP%3E%3CP%3EWhen%20i%20see%20in%20console%2C%20it%20is%20giving%20following%20errors%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20764px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F50055i98CE15F4DF871E41%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22sp2019.PNG%22%20title%3D%22sp2019.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-253902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EColumn%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-260254%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-260254%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMeanwhile%20please%20find%20an%20example%20of%20Syntax%20supported%20for%20conditional%20formatting%20used%20for%20SP2019%20here%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20class%3D%22linkified%22%20title%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%22%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-260250%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-260250%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMeanwhile%20please%20find%20an%20example%20of%20Syntax%20used%20for%20conditional%20formatting%20used%20for%20SP2019%20here%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20class%3D%22linkified%22%20title%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%22%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2Fnumber-conditional-formatAST.json%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254177%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254177%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mihir%20and%20Juan%2C%26nbsp%3BUpdate%3A%20%22Excel%20styled%E2%80%9D%20syntax%20is%20not%20supported%20for%20conditional%20formatting%20in%20on%20premises.%20We%20will%20have%20a%20documentation%20published%20on%20this%20soon%20for%20SP2019%20and%20will%20have%20more%20details%20about%20conditional%20formatting%20for%20SP2019%20in%20the%20article.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254046%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254046%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Juan%2C%20Thanks%20for%20bringing%20this%20upto%20us.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMihir%2C%20This%20is%20a%20known%20issue%20which%20we%20are%20working%20on.%20Hopefully%20this%20should%20be%20fixed%20in%20RTM%20or%20an%20upcoming%20patch%20post%20RTM.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253936%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253936%22%20slang%3D%22en-US%22%3EI%20will%20share%20this%20thread%20with%20the%20Team%20so%20they%20can%20ask%20you%20for%20more%20details%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1252490%22%20slang%3D%22fr-FR%22%3ERe%3A%20SharePoint%202019%2C%20column%20formatting%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1252490%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F135780%22%20target%3D%22_blank%22%3E%40Jithin%20Joseph%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3EI'm%20struggling%20to%20make%20column%20formatting%20working%20on%20SharePoint%202019.%3C%2FP%3E%3CP%3EIs%20there%20any%20update%20regrading%20the%20documentation%20you%20mention%20in%20your%20post%3F%3C%2FP%3E%3CP%3EThanks%20and%20looks%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Environment: SharePoint 2019.

I am trying with column formatting. It is working fine with Online. Same code is not working in SP2019. 

May be office fabric is not loading as expected in SP2019. Is there any option to make it enable ?

When i see in console, it is giving following errors:

sp2019.PNG

6 Replies
Highlighted
I will share this thread with the Team so they can ask you for more details
Highlighted

Hi Juan, Thanks for bringing this upto us. 

Mihir, This is a known issue which we are working on. Hopefully this should be fixed in RTM or an upcoming patch post RTM.

Highlighted

Hi Mihir and Juan, Update: "Excel styled” syntax is not supported for conditional formatting in on premises. We will have a documentation published on this soon for SP2019 and will have more details about conditional formatting for SP2019 in the article.

Highlighted

Hi All,

 

Meanwhile please find an example of Syntax used for conditional formatting used for SP2019 here:

 

https://github.com/SharePoint/sp-dev-list-formatting/blob/master/column-samples/number-conditional-f...

Highlighted
Solution

 

Meanwhile please find an example of Syntax supported for conditional formatting used for SP2019 here:

 

https://github.com/SharePoint/sp-dev-list-formatting/blob/master/column-samples/number-conditional-f...

Highlighted

Hi @Jithin Joseph ,

I'm struggling to make column formatting working on SharePoint 2019.

Is there any update regrading the documentation you mentionned in your post?

Thanks and regards

David