Is it possible to get email from person column in SharePoint calculated column?

Please write it, if it is possible.

  • What is the use case exactly? Can you explain your requirements in detail so that we can suggest workaround? Aug 2, 2023 at 7:50
  • Hi @Chandrika, Does my solution given below work for you? If yes, please Upvote(^) and accept it as an Answer (by clicking the "checkmark" button underneath the vote buttons) as it helped you & it will help others with similar question in future to find the correct answer easily, thanks! Aug 10, 2023 at 8:01

2 Answers 2


Unfortunately, No.

You cannot use person or group column values in SharePoint calculated columns.

It is a known behavior of SharePoint calculated columns.

You can find some workarounds like using Power automate flow or SharePoint JSON formatting to get email address from person or group column and show it in another column at: Get Email from user and enter into SharePoint list field


Are you trying to create a column to display the user's email address? If so, you can build a column of single-line text and format this column.

1.Create a single line text column and format this column. enter image description here

2.Switch to Advanced mode.

enter image description here

3.Please attention that "people" is the column name of Person column. Please replace your name: There is the JSON:

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

4.Here is the result.

enter image description here

  • This is an exact same solution provided in "link" given in my answer below :) Aug 10, 2023 at 8:00

Your Answer

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