I have a SharePoint 2007 list, I want to Auto-populate the Email id based on the Account Name(Person/Group type column).

Eg: if the persons account name is provided in the Account name column then his/her email id should get auto-populated in the Email id column of the same List.

Please provide a calculated formula for the same.

1 Answer 1


It's no supported to achieve it using Calculated column by default.

I suggest you use designer workflow. You can set the Email ID column value based on Account name column value in designer workflow.

  • Can you please provide code for fetching the Email from the people picker Using Sharepoint Designer.
    – Sarvesh
    Dec 27, 2017 at 10:43

Your Answer

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

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