SOLVED

Multi line text columns do not support JSON coding

Copper Contributor

Can someone verify this statement I found on the internet is accurate as of today? I would love for this to be out of date and someone can tell me how to create JSON formatting for a multi line text field that's set to Rich Text so it doesn't show up like the attached jpg.

 
 

Rich text fields return their values with HTML. List Formatting automatically escapes values meaning that these types of fields will include HTML in their text values and that HTML will not be used as part of the page. It is not recommended to use rich text fields with List Formatting.

6 Replies

@kellyhickman14096 

 

Multiple lines of text column with enhanced rich text does not support SharePoint JSON formatting: 

ganeshsanap_0-1711604044658.pngMicrosoft Official DocumentationSharePoint JSON formatting - supported column types 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap Thank you, yes I saw that, I was inquiring about Rich Text. Is that also not supported or is there an opportunity for formatting on that column type?

@kellyhickman14096 

 

You will be able to apply the JSON formatting to the column. But if you have HTML content in the column value, there is no direct way supported by JSON formatting to show the content well formatted.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap Just to clarify, I have a paragraph expression fed from a PowerAutomate flow, so that sends html to the column, correct? This is why I get a mess like in the jpg I attached to this post?

best response confirmed by kellyhickman14096 (Copper Contributor)
Solution

@kellyhickman14096 

 

Yes, the column value shown in image you attached is HTML. 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by kellyhickman14096 (Copper Contributor)
Solution

@kellyhickman14096 

 

Yes, the column value shown in image you attached is HTML. 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

View solution in original post