Forum Discussion

AmithKumar's avatar
AmithKumar
Copper Contributor
Sep 18, 2020

Wanted to create a List with team details from the user related information available in MS 365

HI I am developing a site for my team using SharePoint Online (MS 365) and in which a Team Details List needed to be created which will show various details about a team member and most of the requir...
Lists
SharePoint Online
nullorempty's avatar
nullorempty
Copper Contributor
Sep 18, 2020

AmithKumar 
Have you looked into creating a Flow to populate the other fields?  It should be fairly simple, but you'll want to watch out for creating an update loop.

AmithKumar's avatar
AmithKumar
Copper Contributor
Sep 18, 2020

nulloremptyI know i can use Flow which is much easier but Power Automation is yet to enable for us...but can't wait to create this list until then. 

  • nullorempty's avatar
    nullorempty
    Copper Contributor
    Sep 18, 2020

    AmithKumar 
    Add a text field to your list, then set the JSON formatting as follows:

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

     

    I created a list, then added a People/Group column titled person.
    After that, I created a text column titled personEmail and set the JSON formatting to what's displayed above.

    NOTE
    This is for displaying values only and the items will not appear in the edit menu and will not be available to copy/paste.

Resources