Mar 27 2024 10:09 AM - edited Mar 27 2024 10:13 AM
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.
Mar 27 2024 10:35 PM
Multiple lines of text column with enhanced rich text does not support SharePoint JSON formatting:
Microsoft Official Documentation: SharePoint 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.
Mar 28 2024 06:06 AM
Mar 28 2024 06:48 AM
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.
Mar 28 2024 06:51 AM
@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?
Mar 28 2024 10:51 PM
Solution
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.
Mar 28 2024 10:51 PM
Solution
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.