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!

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

1 Answer 1

Reset to default
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

Improve this answer
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? Commented 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. Commented 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. Commented Oct 25, 2023 at 13:40
  • 1
    OK, good to know. Thank you again! Commented Oct 25, 2023 at 13:41
  • You're welcome! Commented Oct 25, 2023 at 13:43

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.