How to Add a Workflow Lookup in a Sharepoint 2013 workflow for a list of email addresses

TMKramer 20 Reputation points
2024-03-25T18:50:40.47+00:00

I have a workflow that needs to email groups of individuals. I wanted to set the email command to lookup the list item (2-4 email addresses maintained in a SharePoint 2016 List) and populate the email To line with these email addresses.

I don't know the choices to make in the lookup to get it to work.

The List where the email addresses are is called Division Directors and Deputies for Routing

The List has two Columns one called Directorate Group that identify the 4 different groups of people. We can just call them group A, B, C and D. The other called Director and Deputy Emails which holds the actual email addresses.

This is the first box that pops up. User's image

I attempt to choose what I think makes sense. Which makes sense in my head until the value section, I'm thinking I want to add the group name here, for example Group A. But I can't figure out how to do that.

User's image

If I try adding it to the field manually, I get an error:

User's image

User's image

But if I try to do a lookup for the string builder, for Group A, I feel like I am just in a never-ending loop of lookups.

User's image

It literally just keeps going and going.

User's image

Yes, I'm sure I'm doing something wrong at some step, but I can't figure out where. Can anyone assist?

Should I scrap this and figure out a different way to pull in a group of emails?

Thanks!

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,783 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions
{count} votes

Accepted answer
  1. Haoyan Xue_MSFT 21,826 Reputation points Microsoft Vendor
    2024-03-26T02:13:15.32+00:00

    Hi @TMKramer ,

    I'm glad to hear you solve the problem, if you have any issue about SharePoint, you are welcome to raise a ticket in this forum.

    I would make a brief summary of this thread, You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!:

    Issue Symptom:

    Trying to manually add a group name to a field in a Sharepoint 2013 workflow gives an error:

    User's image

    Current status:

    The issue has been solved. Ignored the error/warning and just typed in the group name and hit ok. It worked!


    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful