How to Increase Number of Characters for a SharePoint Column beyond 255.

Question

I created a table in SharePoint and 1 column holds email addresses. How can I increase the # of characters that that field holds beyond 255 characters?

Answer 1

Hi @Primrose,Jacqueline (HHSC),

Thank you for posting in this community.

SharePoint column size limit for a single line of text is 255 characters and cannot be increased beyond that. If you need to store more data, you can use a multiple lines of text column type. The maximum number of characters for a multiple lines of text column is 350.

1.Create a multiple lines of text column.

2.In the column options, select “Format column.”

3.Select “Advanced mode”.

4.Insert the code. Don't forget to save when you're done.

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "=@currentField",
"attributes": {
"target": "_blank",
"href": "=@currentField"
 }
}

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.

Answer 2

You will need to switch from a Single Line of Text to a Multiple Line of Text which defaults to 63,999 Character Limit.

https://support.microsoft.com/en-us/office/list-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7