0

Based on this great solution, I am looking for JSON column formatting to copy a multi-person field (people picker), displayed as email

  1. into a text field
  2. displayed as raw text email format
  3. comma separated, and
  4. no hyperlink.

Example:

People Picker/Email Display: [email protected]; [email protected]

Copy to Single Line Text Field: [email protected],[email protected]

Thank you!

2
  • Thanks for editing to make this clearer, Ganesh.
    – ChasEpes
    Oct 25, 2023 at 13:27
  • You're welcome! Check solution given below and let me know if it works for you. Oct 25, 2023 at 13:30

1 Answer 1

1

Use SharePoint column formatting JSON like below:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=join([$PersonColumn.email], ', ')"
}

Where PersonColumn is internal name of your SharePoint list multiple selection people picker column. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?.

Output:

enter image description here

5
  • This is great. It displays on the aspx page but I'm curious why the new column's text does not export to Excel. Any idea?
    – ChasEpes
    Oct 25, 2023 at 13:37
  • 1
    SharePoint JSON formatting only customizes the display of columns/views. It does not actually "store/save" the values in column. If you want to store/save the emails in column, you can try using Power automate flow to update email column values on item creation/update. Oct 25, 2023 at 13:38
  • You can update column values using JSON as well but issue is you have to manually click the JSON button to update column values. Column values cannot be automatically updated using JSON formatting - This is a known behavior of SharePoint JSON formatting. Oct 25, 2023 at 13:40
  • 1
    OK, good to know. Thank you again!
    – ChasEpes
    Oct 25, 2023 at 13:41
  • You're welcome! Oct 25, 2023 at 13:43

Your Answer

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

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