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