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%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%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%3CLINGO-SUB%20id%3D%22lingo-sub-2432455%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-2432455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F594170%22%20target%3D%22_blank%22%3E%40David-32%3C%2FA%3E%26nbsp%3BI'm%20also%20having%20problems%20using%20column%20formatting.%26nbsp%3B%20Have%20you%20found%20anything%20to%20help%20you%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

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

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.

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.

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...

best response confirmed by Mihir Yelamanchili (Frequent Contributor)
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...

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

@David-32 I'm also having problems using column formatting.  Have you found anything to help you?