SahrePoint Online - Multiline Text column not appearing for List validation

Question

I have a Multiline column called "Comments" (Rich Text), I'm trying to create a validation rule whereby if a prior column has a certain selected value then this comments column must be filled in. However I noted that the column does not appear on the list of available columns to have a formula added too. Is there a limitation which prohibits Rich Text multi Line columns from being added to a validation rule in SharePoint online?

Answer 1

Hi @Gavin Smith,

Thank you for posting in this community.

As you can see, SharePoint Online does not support validation rules on Multiple lines of text column at this time.

But we can implement this validation using JSON formatting. You can try this method to see if it solves your problem.

1.Open column formatting.

2.Copy the following JSON code. Please use [$ColumnName] to replace your column name. And you can replace the prompt. Click Save when you are done.

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"attributes": {
"class": "=if([$priorcolumn] == '', '',if([$Comments]=='','sp-field-severity--severeWarning ms-fontColor-neutralSecondary',''))"
 },
"children": [
 {
"elmType": "span",
"style": {
"display": "inline-block",
"padding": "0 4px"
 },
"attributes": {
"iconName": "=if([$priorcolumn] == '', '',if([$Comments]=='','Warning',''))"
 }
 },
 {
"elmType": "span",
"txtContent": "=if([$priorcolumn] == '', '',if([$Comments]=='','Required Info',@currentField))"
 }
 ]
}

3.Here is my test result.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.