Answered

Unique Emails Populating as a String and Not able to Send Email

(0) Share

Report

Posted on by theBrianL

I have a SP List that has a MngrEmail field and a UserEmail Field. Each week I want to send an email to the manager with all of the items in the list, which I have working by this flow below. The outputs are the unique emails that I got from a Compose statement that is a Union of the Manager email(Outputs,CurrentItem,Filterarray where item = Email). All of that works fine to send one email to the manager. The problem is I have another Compose also outside of the Apply to Each that gets the unique UserEmails. When I put that output('UniqueUserEmails') into the CC, it puts quotes around the email address and the email fails. What would be the best way to get the Unique UserEmails to CC all of them on the one email? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
If you want to get all the user emails from your array into a format that you can use in your email (semi-colon separated list of emails) you can use either a Join action, or a join expression as shown below.

join(YOUR_ARRAY_OF_EMAILS, ';')

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

Right now it's just one user email address and it errors out because the output of Compose is ["email.com"]. Trying to do the following: Get items/Unique emails/send email in For Each of Mngr Email block.

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

This is the error I'm getting. e 'inputs.parameters' of workflow operation 'Send_an_email_from_a_shared_mailbox_(V2)_3' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/Cc' is required to be of type 'String/email'. The source type/format 'Array' of the value '["someone@gmail.com"]' is not convertible to type/format 'String/email'.

And this is what gets populated in the CC field: ["someone@gmail.com"]

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

I ended up using an array variable for all of the user emails and then your join statement in the CC. I think it's working now. Thx

Was this reply helpful? Yes No