I have a SharePoint online list where I have a People Picker field ("PeoplePickerColumn").

I want to create a new text column ("PeopleTextColumn") in the list that populates based on the "PeoplePickerColumn" value.

I'm fairly new to SharePoint and do not know JSON.

1 Answer 1


If you just want to show the data in text column in list view, you can use below JSON code:

   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "[$PeoplePickerColumn.title]"

Make sure you are using correct internal name of your People Picker field in txtContent. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Microsoft documentation: Use column formatting to customize SharePoint

If you want to store the actual value in text column, it is not possible with JSON formatting.

To populate the value in text column on list item creation/update, you have to call a power automate flow & perform update operation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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