Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Iron Contributor
Apr 09, 2021
Solved

Sharepoint lists - Conditional formating, multiple lines column.

Hi,

 

Is it possible to format a columns in lists, based on a "multiple lines" eg if it it contains text, not empty.

 

The columns name is "Kommentarer"

 

Best regards

- Geir

 

 

 

Lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Apr 09, 2021

    Hogstad_Raadgivning yes this is possible and you can see this in the More... multiple lines of text column in the image below. If there is text then the background color is blue, but the background stays white if there is no text:

     

    Put the following JSON in the advanced mode screen when you format the column:

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "padding-left": "14px",
    "background-color": "=if(@currentField != '','#4f7b95','#fffffc')",
    "color": "white"
  }
}


    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

3 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Apr 09, 2021

    Hogstad_Raadgivning yes this is possible and you can see this in the More... multiple lines of text column in the image below. If there is text then the background color is blue, but the background stays white if there is no text:

     

    Put the following JSON in the advanced mode screen when you format the column:

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "padding-left": "14px",
    "background-color": "=if(@currentField != '','#4f7b95','#fffffc')",
    "color": "white"
  }
}


    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • jneely's avatar
      jneely
      Copper Contributor
      May 09, 2021

      RobElliottWhat about if you have "Append changes to existing text" turned on? My use case has the append option selected. I'd like to highlight my column if changes have been made, and no background if there are no changes (something like below). This would be a visual cue for users to quickly see if changes (or really comments as I'm using it as a call log) have been made. Thanks...

       

Resources