I have 5 columns in a SharePoint list. In order to reduce the number of columns to one, I should have all other 4 fields to be added to one column using JSON.

when i try

"status" : "approved"
"maildate" : "09-09-2018"


It does not give me anything. the column will have no value in it.

Could you please help me with this.

  • What SharePoint version is this? – Jussi Palo Aug 29 '18 at 8:09
  • online site it is. – user78210 Aug 30 '18 at 7:39

If you're adding it programmatically, you will probably need to escape/encode the value. Also, the example you wrote is missing comma after "approved".

Otherwise, adding it to SharePoint single line text field works fine if done using browser.

  • No i am not doing using program. Just putting JSON in single line of text with comma after approved.But it does not work.can you please provide me an example. i have a sharepoint list having 5 column.Instaed of five i want to use one and put other 4 fields in json format as single line of text column.But it gives me blank column or sometime it just dn display the list at all. – user78210 2 mins ago – user78210 Aug 29 '18 at 6:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.