Forum Discussion

Femke11's avatar
Femke11
Copper Contributor
Jun 13, 2023
Solved

Automatically fill a single text column in Lists by the value of a Person Field column

Hi,   Having trouble with this:   - I have a Person Field column in lists where I fill in an emailaddress - I want to fill a single text column with the emailaddress (to use in flows etc)   Ho...
  • ganeshsanap's avatar
    Jun 13, 2023

    Femke11 If you just want to show the email address in the list view, you can easily do it using JSON formatting like: 

     

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

     

    Where PersonGroupCol is internal name of person or group field. You can get the internal name of your person or group column by following this article: How to find the Internal name of columns in SharePoint Online?

     

    You can read more information about this approach in my answer given at: Get Email from user and enter into SharePoint list field 


    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources