I am using SharePoint 2013 Online and I need to get the email address using the name of the person.

A single text field had the user name in it and using that, I need to retrieve the email address of the person using a WORKFLOW

Is that possible OOTB?


What I'm trying to do is, send email to the person listed in the text field (Name format: Lastname, Firstname). It works for single person. But if there are more than one person, the workflow fails. Is there any alternative to achieve this?


1 Answer 1


In the workflow designer you can set variables by querying the User Profiles as the data source. This needs the Account Name to search on.

To do this: 1. Choose Action "Set Workflow Variable".

  1. Create Workflow Variable "Email".

  2. Click fx on Value. Set Data Source as User Profiles. The rest you should be able to work out.

WF Variable set through User Profile

  • How to query user profile as data source? You have any links?
    – Keerthi
    Nov 16, 2015 at 16:37
  • See Improved answer, this is from my knowledge as opposed to links I have followed.
    – Jacob
    Nov 16, 2015 at 16:41
  • Since you can only find the user profile by account name, even if you can parse your single text field into a user name (e.g. find the comma and use the first initial of the first name and the whole last time), this won't work for multiple users in one text field.
    – Erin L
    Nov 16, 2015 at 18:03
  • @ErinL Good point, user added this as an edit to the question in between writing my answer and refreshing the page!
    – Jacob
    Nov 18, 2015 at 10:13

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.