I’m building an app which can compile Emails to the participants of different meetings. I have the following tables in my data structure (among others):
- Meeting Categories
In my Meeting Categories I define the name of the meeting and which employees attend the meeting.
A Meeting is an instance of a meeting category. For example, a sale meeting (meeting category) is held every month (meeting).
I have built an action of the type ‘External: Start an Email’ for a record of the meeting table. In the ‘To’ field I have composed the expression
‘SELECT(Employee[Email],[Meeting Category]=[_Thisrow].[Meeting Category],TRUE)’
This should ensure that only the employees which are added to the meeting category of this meeting are getting an email. However, I get an error saying:
The expression is valid but its result type ‘List’ is not one of the expected types: Email
Can anyone help me with this? Is it impossible to compile a list in this field? Should I use another expression? Or is it possible to use an expression to change my LIST into a STRING, with a seperator ‘;’? This would solve this problem as well, as this is the separator Outlook uses.
Tx in advance!