Select list from Enumlist

[SKETCHwade]

I am trying to create a list of user email addresses from a list of user [ID].

The list is called [Preferred Candidates] and the Candidates table has [Email] and [ID] inside.

I have tried:

Select(
Candidates[Email],
CONTAINS([Preferred Candidates], Candidates[ID])
)

and

SELECT(Candidates[Email],
CONTAINS(SPLIT([Preferred Candidates]," , "),Candidates[ID])
)

But no luck. The more I read this through the more it feels like it should work.
Theres no way I can see that I can setup a helper column either because it would have the same formula. 😓

[Suvrutt_Gurjar · Accepted solution]

Assuming [Preferred Candidates] is in the same table "Candidates" and [Preferred Candidates] enumlist is available in each and every row of the Candidates table, you could try an expression of 

SELECT(Candidates[Email],
IN([ID], [Preferred Candidates]
))

Such SELECT() expressions can be sync expensive, especially if used in a virtual column. As such, you may want to share more details about implementation so that the community could suggest any better option, if so available.

r 

[SKETCHwade]

That worked thank you!

It will actually run inside a scheduled bot so the expense of it is not a big concern.