Forum Discussion

Brass Contributor

Jan 29, 2018

Solved

Sharepoint Conditional Formatting

Hi All, I am trying to find Json code for SharePoint online 365 columns in a custom list: If columnX = "no" make the column bold TIA, Joe

developer

sharepoint 365

Joe Fischer
Jan 31, 2018
Hi Nigel,

Yes a small bit of Json in the column formatting does the trick :)

Below is an example, @faustocapellanjr sent me...

Thanks again for your help.

Joe

{
   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
   "txtContent": "@currentField",
   "elmType": "div",
   "style": {
       "font-weight": {
           "operator": "?",
           "operands": [
               {
                   "operator": "==",
                   "operands": [
                       "@currentField",
                       "No"
                   ]
               },
               "bold",
               ""
           ]
       }
   }
}

Joe Fischer

Brass Contributor

Jan 29, 2018

Thanks Nigel,

I will look into that. I didnt expect it to be so complex. I figured I could just add some Json Code in the coumn Formatting in the column settings.

Thanks again,

Joe

Nigel Witherdin

Iron Contributor

Jan 31, 2018

It might be possible to do something with the Column Formatting (Ive never really used it) but the Field Customizer is probably the best way to customize the rendering of any field, and be confident that it will work in Modern SharePoint pages

Joe Fischer
Brass Contributor
Jan 31, 2018
Hi Nigel,

Yes a small bit of Json in the column formatting does the trick :)

Below is an example, @faustocapellanjr sent me...

Thanks again for your help.

Joe

{
   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
   "txtContent": "@currentField",
   "elmType": "div",
   "style": {
       "font-weight": {
           "operator": "?",
           "operands": [
               {
                   "operator": "==",
                   "operands": [
                       "@currentField",
                       "No"
                   ]
               },
               "bold",
               ""
           ]
       }
   }
}
- Nigel Witherdin
  Iron Contributor
  Jan 31, 2018
  nice one! Will have to look into what you can do with column formatting a little more
  - Nigel Witherdin
    Iron Contributor
    Jan 31, 2018
    Good write up on this topic here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting