Storing json value in multiline text column

%3CLINGO-SUB%20id%3D%22lingo-sub-172024%22%20slang%3D%22en-US%22%3EStoring%20json%20value%20in%20multiline%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172024%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20disadvantages%20in%20storing%20json%20string%20in%20a%20multiline%20text%20in%20SharePoint%20lists%3F%20Any%20restrictions%20we%20need%20to%20consider%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-172024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172061%22%20slang%3D%22en-US%22%3ERe%3A%20Storing%20json%20value%20in%20multiline%20text%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172061%22%20slang%3D%22en-US%22%3E%3CP%3EI%20guess%20your%20only%20restriction%20is%20the%20maximum%20length%20of%20the%20text%20you%20can%20store%20in%20multi-line%20text%20field.%26nbsp%3B%3CSPAN%3EA%26nbsp%3B%3C%2FSPAN%3EMultiple%20lines%20of%20text%3CSPAN%3E%26nbsp%3Bcolumn%20in%20SharePoint%20Online%20can%20store%20up%20to%2063%2C999%20characters%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flist-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flist-and-library-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20SharePoint%26nbsp%3Bon-premises%20different%20limits%20apply%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787(v%3Doffice.16).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fcc262787(v%3Doffice.16).aspx%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Is there any disadvantages in storing json string in a multiline text in SharePoint lists? Any restrictions we need to consider?

1 Reply
Highlighted

I guess your only restriction is the maximum length of the text you can store in multi-line text field. Multiple lines of text column in SharePoint Online can store up to 63,999 characters:

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

 

For SharePoint on-premises different limits apply:

https://technet.microsoft.com/en-us/library/cc262787(v=office.16).aspx