SharePoint: How to autopopulate email address based on Person column
We had a use case of an InfoPath form with two person or group columns among other details. The list owner wanted to get the email address auto-populated in corresponding columns not on the form. I created two new person or group columns but changed the "Show field" to "Work email" as shown below:
Then I created a SharePoint Designer workflow to set field in current item to the value of the corresponding person or group field from the InfoPath form.
I set the workflow to start on submission. It worked just fine.
Comments