For the workflow to send email, I construct the expression to dynamically build the email list for distribute from custom user table. This exprssions are set for “To” as well as “CC”.
Based on that, there is a case the same email address are listed up both in TO and CC sections. Appsheet workflow will send email twice to the same email address, which I wish to avoid.
All in all, in case we have duplicate email address across, TO, CC sections, or respectively, then Appsheet only fire email once to the duplicated email address.