In my app, I currently have an Enum column wh...

expressions
(Ethan Hildebrand) #1

In my app, I currently have an Enum column where I select a contact person from a list. Then, I have a secondary Email column where I pull in the user’s email address with the following expression…

=ANY(SELECT(ProtocolContacts[Email], AND([_THISROW].[CONTACT] = [Name], [_THISROW].[PROTOCOL NUMBER] = [Protocol ID])))

I would like to change the column type for the contact person from Enum to Enumlist, so that I could select multiple contact people. What expression can I use in the secondary column to produce a list of email addresses?

I feel like this should be possible with a combination of If() and In() expressions, perhaps with concatenate(). Thanks in advance

(Simon Robinson) #2

Remove the ANY will generate a list

Swap from using the = to using IN(…)