I have a pair of fields, Project Manager Name and Project Manager Email. Project Manager Name is a people picker field allowing the user to select a PM by display name when they create or edit a project.
I want to create a list workflow to look up the email address of the user selected in the Project Manager field and populate the Email field with that address.
Currently I have the following workflow published:
Set PMMail to CurrentItem:ProjectManager
Where CurrentItem is Workflow lookup for user in Datasource: Current Item, Field: ProjectManager returning field as Email Address
The workflow contains no errors and publishes properly. It runs on item creation and completes but the Email field remains blank.
What am I doing wrong?