none
How to email a list of people from a lookup

    Question

  • I have a 2 lists.

        • Tickets
        • Categories

        Tickets has a lookup to Categories.  Categories has a Tier 1 field that lists multiple people.  What I want to do is create a workflow to send an email to the people in Tier 1.

        I've found this article, but I'm stuck on the last step, I don't quite understand what the poster means.

        https://app.powerbi.com/groups/5d617e8e-0ac5-4fa2-9857-d27ec6e5ec7c/dashboards/5f27e190-d4af-4a85-9089-8b7c6e729077 

        Here's what his post says.

        You can use the Send an Email action to do this. When editing the action details use the directory control to open up the Select Users dialog. In that dialog double click the "Workflow Lookup for a User..." selection. Set the

        • 'Data source' as the list with the email address
        • 'Field from source' as the email address column
      • 'Field' as the column from the second list that you will contain the value you search for (ex: emplid)
    • 'Value' as the value to look for the entry in the email list (ex: Current Item: emplid) <= I don't understand this part.

    That should send the email to whatever email address corresponds to the unique value you searched for.

    Any help is greatly appreciated!!

    Friday, February 10, 2017 4:56 PM

All replies

  • Hi,

    This would help you

    https://social.technet.microsoft.com/Forums/office/en-US/3d42a448-37d6-439f-8062-fd44f80ea688/how-to-send-emails-to-multiple-users-from-a-single-people-picker-lookup-field-using-sharepoint?forum=sharepointdevelopment

    http://jenkinsblogs.com/2015/04/30/how-to-send-emails-to-multiple-users-from-lookup-list-people-picker-field-using-sharepoint-designer-workflow/


    Please remember to click Mark as Answer on the answer if it helps you

    Friday, February 10, 2017 7:31 PM