I want to create custom Person or Group type of field which is mapped to User profile.when we add user name to that field then auto fill other columns like first Name,Last Name,Email,Work phone.

enter image description here

In above image he is create simple text field.click here


2 Answers 2


You can achieve this requirement by using the workflow. create a workflow and fetch the Person or Group type column value for the current item and read the values from the workflow like email,Lastname( User profile).etc.. and updated the other columns created for storing the user details

please check the below link from sharepoint stackexchange Extract the department from a Person/Group field and this link for approach from designer workflow Making the Most of the Person List Field

  • thanks,but I want this functionality on List New page & Edit form.this is not possible using workflow..... Mar 24, 2017 at 8:53
  • you can use the people picker event to auto populate other fields.
    – Sunil Sahu
    Mar 24, 2017 at 9:44
  • please refer this link it may help you sharepoint.stackexchange.com/questions/103682/…
    – TARUN
    Mar 24, 2017 at 9:49
  • for this I don't have permission to write jquery. Mar 24, 2017 at 11:38

My company has created a product that is designed specifically to address needs like this. The problem we faced was that the purpose of custom field definitions is to define how data is stored, rather than where it comes from or how it is entered. FieldTypeDefinitions can create some real problems in your environment (if it ever gets corrupted it will break access to ALL columns in your environment, for example). Resolving issues require reboots and IISRESETs during production hours. It's a messy technology to solve the problem you're looking to solve.

What we've done instead is create a couple things we refer to as Transcriptions and Expressions: Transcriptions are different types of formula that you can use for applying custom values (like user profile properties) to existing field types, and Expressions are little bits of script that you can apply to specific fields. So (for example), you might apply an Expression on your 'Favorite Color' column that automatically sets the value to a user profile property through the User Profile Transcription.

enter image description here

Notice that we are applying the above script (using the {User.Email} Transcription) to the "Single line of text" column below:

enter image description here

So when we open our form, the default value is the Email address from our User Profile property:

enter image description here

This is all essentially handled through the use of custom forms, with custom field iterators. When you launch your NewForm.aspx, our control gets loaded instead of Microsoft's, and we use it to add these extra features at runtime.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.