Using JSON to set a character limit for MS365 sharepoint multi-line text column values

Question

Using JSON to set a character limit for MS365 sharepoint multi-line text column values

Thilina Tantirigama 116

I have not found the answer to this. Can you please advise if this is possible?

Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2022-05-25T09:46:54.74+00:00

Thanks for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

1 answer

Your answer

Yanli Jiang - MSFT 31,606 Reputation points Microsoft External Staff

2022-05-25T09:46:54.74+00:00

Thanks for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

Answer 1

Tong Zhang_MSFT 9,251

Hi @TantirigamaThilina-7057,

Per my research and testing, there is no JSON that can set character limits for multi-line text column values . However, you can use the following JSON to limit the number of characters displayed in the list:

{  
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
   "elmType": "div",  
   "txtContent": "=substring(@currentField, 0, 10) + ''"  
}

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.

Thilina Tantirigama 116 Reputation points

2022-05-27T10:05:50.827+00:00

Thanks @Tong Zhang_MSFT I suspected that might be the case, thanks for your input.
Tong Zhang_MSFT 9,251 Reputation points

2022-05-27T10:12:42.443+00:00

Hi @TantirigamaThilina-7057 ,

If the answer is helpful, you can click "Accept Answer" button .It can make it easier for other community member's to see the useful information when reading this thread.

Thanks for your understanding!
Wendy Li_MSFT 1,711 Reputation points Moderator

2022-05-30T01:16:28.747+00:00

@TantirigamaThilina-7057 Do you have other concerns about this thread? Please you have any doubts, please feel free to reply.
Besides, If the answer helps you, please remember to click the "Accept Answer" button to accept it, which will make others who may meet this similar issue find the correct answer quickly in the future. Thanks for your understanding. :)

Share via

Using JSON to set a character limit for MS365 sharepoint multi-line text column values

1 answer

Your answer