Sharepoint MSList JSON

Question

I use Sharepoint MS list and have a Formula in the Validation Setting : =IF(Progress="Completed",IF(ISBLANK(Resolution),FALSE,TRUE),TRUE) with a user message as : RESOLUTION IS MANDATORY WHEN PROGRESS IS SET TO COMPLETED

It works great with a suingle line of text but users have aked for mutiple line of text and now it does not wiork. I read that it will not work with multiple lines of text but need JSON. How can I use JSON to make this work with Mutilple lines of text

Answer 1

Hi @Mills, Alan,

Yes, Mutiple line of text column is not supported in list validation formula. As per my knowledge, it also doesn't work even applying JSON formatting. For example, in this thread: SharePoint Online - Multiline Text column not appearing for List validation, users still can save invalid items (in your scenario, RESOLUTION is blank when PROGRESS Is set to completed). It just used "Required Info" to highlight the blank filed but the invalid item is still saved. Essentially, this cannot be used as an alternative to list validation, because items that violate the list validation formula cannot be saved to the list at all.

If you can accept this alternative, you can apply below JSON formatting code to the Resolution column.

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "=if([$Progress] == 'Completed' && [$Resolution] == '', 'RESOLUTION IS MANDATORY WHEN PROGRESS IS SET TO COMPLETED', @currentField)",    
   "style": {
      "color": "=if([$Progress] == 'Completed' && [$Resolution] == '', 'red', '')"
   }
}

---

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.