Forum Discussion

Stefudem's avatar
Stefudem
Copper Contributor
Oct 10, 2023

Re: Display email from a person column

ganeshsanap Thank you for this solution which works really well. I would like to know what other information can be retrieved this way? By replacing column.email. I would also like to retrieve the user's login in addition to their email address.

1 Reply

  • Stefudem 

     

    You can get following properties from person column using SharePoint JSON formatting. The people field object has the following properties (with example values): 

     

    {
      "id": "122",
      "title": "Kalya Tucker",
      "email": "email address removed for privacy reasons",
      "sip": "email address removed for privacy reasons",
      "picture": "https://contoso.sharepoint.com/kaylat_contoso_com_MThumb.jpg?t=63576928822",
      "department":"Human Resources",
      "jobTitle":"HR Manager"
    }

     


    Please consider giving a Like if my post helped you in any way.