
Announcements
Currently I can send an email to a collection of users, but now I need to send it to two lists and I don't know how
I have two collections, which are mailing lists, that are in different places.
I need to merge these two collections into one to send the email.
How would I put these collections together
Collection1:
ClearCollect(
UserFromEmailList;
Filter(
TBL_EMAIL_USER;
USER_EMAIL.Value = dropDownOperadoraAcc_1.Selected.Value
).E_MAIL
);;Collection2:
ClearCollect(
UserFromMangerList;
Filter(
TBL_EMAIL_MANAGER;
MANAGER_EMAIL.Value = dropDownOperadoraAcc_1.Selected.Value
).E_MAIL
);;Email Code:
Office365Outlook.SendEmailV2(Concat(UserFromEmailList;E_MAIL&";")"Fields";....);
Hi @JasonCastro ,
Try this
With(
{
wUser:
Filter(
TBL_EMAIL_USER;
USER_EMAIL.Value = dropDownOperadoraAcc_1.Selected.Value
).E_MAIL;
wManager:
Filter(
TBL_EMAIL_MANAGER;
MANAGER_EMAIL.Value = dropDownOperadoraAcc_1.Selected.Value
).E_MAIL
},
ClearCollect(
colMailTo;
wUser;
wManager
)
);
Office365Outlook.SendEmailV2(
Concat(
colMailTo;
E_MAIL;
";"
)
"Fields";....
);
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps