Make an EnumList generate from a selected EnumLIst

[Tom_Stevens]

So I have an EnumLIst where I select multiple Employees emails from my employee data. The field is called [Task Assigned to]

Bob@theemail.com
Jane@theemail.com
Zoe@theemail.com
Steve@theemail.com
Hwrang@theemail.com

I pick, Bob & Jane from the list and It out puts… Bob@theemail.com, Jane@theemail.com

The next field [EMPLOYEE PHONE NUMBERS] then looks at who’s on the list and looks up their phone numbers from the employee data page and outputs an enumlist with their phone numbers based on the employee data page. The question is how do I do this?

I have found a couple of different ways but I’m having trouble translating it to my needs: This is the post that seems to do what I need.

Enumlist dependent on enumlist Questions

Hi all I need a way for an enumlist to be dependent on another enumlist. I have three tables. One for user data, one for projects and one for activities. The user data contains emails of employees (email type column) - Users[Email]. The project table has different projects with uniqueid’s and a “project team” enumlist, with valid_if Users[Email]. Now I would like a enumlist in my activities table that only show the employees on that specific project team, when assigning activities. How do I…

SPLIT(LOOKUP([_THISROW].[Project Key],Projects,Key,Project team)," , ")

Something like this would seem to be it but it’s not quite right.

SPLIT(LOOKUP([_THISROW].[Task Assigned to],“EMPLOYEE”, “companyemail”, “companyphone”) , ", ")

[Steve]

The following will generate a list of the phone numbers for the selected employees as identified by their email addresses:

SELECT(
  Employee[CompanyPhone],
  IN([CompanyEmail], [_THISROW].[Task Assigned to]),
  TRUE
)

Note, however, that the list of phone numbers is not guaranteed to be in the same order as the email addresses.

[Tom_Stevens · Accepted solution]

Steve:

SELECT(
  Employee[CompanyPhone],
  IN([CompanyEmail], [_THISROW].[Task Assigned to]),
  TRUE
)

Order doesn’t matter at all. Thanks I knew it was going to be something simple I just wasn’t sure where to start.

Thanks