Hello Team,
### INTRODUCTION ###
- We have a custom table called "u_distribution_lists"
- In this custom table, we have a field called "Users to inform"
- The type of the field is "List" and is referenced to "sys_user" table
- The field can contain one or multiple values
- We use this custom table in some catalogue items
### DESCRIPTION ###
We have designed a very simple flow that interacts with the catalogue items mentioned above, but we are stuck because we can't get what we want out of this flow. The two things we can't figure it out are:
Action Send Email
- Populate the field "CC" with all values in the field "Users to inform"
- List the value of the field "Users to inform" in the body of the email
### FLOW DETAILS ###
In our first iteration of the flow, the action "Send Email" looks liks this.
We faced two problems:
- Field "CC": Although the "dot-walked" fiels called 1-->distribution_list-->Users to inform contains all the values of the referenced list (tested wiht a "Log" action, we can see both values), the field "CC" picks up only the first value of the list
- Field "Body": The "dot-walked" fiels called 1-->distribution_list-->Users shows both values, but the SysID and not the email address
In our second iteration of the flow, we tried to work around the SysID issue using two actions:
- Look up the "[sys_user] Records
- For Each Item on the Look up Recors action
By doing this we can get the email address, but we can use it only within the "For Each" loop, namely we can send out the email properly to each user, but not in bulk to all users.
### QUESTIONS ###
Although with the second iteration we can get the email address, I don't think this is the right approach. We think we should stick with the first iteration of the flow, but script something in both the "CC" and "Body" field rather than "dot-walk" the 1-->distribution_list-->Users to inform.
We don't have script knowledge. Do you have any suggestion?
Thank you.
Best regards.
