Help with Sending email.

[VikasNagaraj]

Hi,

I have 2 questions here.

1. I have a flow which is connected to excel sheet, it filters out the date which is exceeding more than 42 days and sends emails based on the project they are assigned to. Everythig works fine but when sending email the output of the filter is put into 'To' field of sendemailV2, which shows all the email address in 'To' field, which is a GDPR issue. 

Is there any way we can send emails to indivual users and they cant see other users email address, Or BCC is the only option here ?

2. Since it is a large data set, outlook is sending emails to 300 recipients at once, is this the limit for outlook or does this depend on the type of license we have?

Thank you.

@abm

@Expiscornovus 

@tom_riha 

[StretchFredrik]

If you put the email adresses into "To" everyone will see eachothers, id say BCC is ur best bet to keep this somewhat private.

Or you can loop all users and send them one email each, or 1 email with all recipients in the same domain.

[Heartholme]

@VikasNagaraj 

1. You should have your emails split up into an array, with one email per index and then use apply to each to send to one receipt at a time. Other than this, BCC is your best option to work around this. So put your email for example in the to field and then the compose in BCC. 

2. Yes, send email is limited to 300 emails per 60 seconds. 

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme

[VikasNagaraj]

@Heartholme @StretchFredrik 

Thanks for your reply, how do i achieve this split up into array and apply to each? could you please help me with this thank you.

[Heartholme]

@VikasNagaraj 

It depends on how your compose/emails are structured. 

Please share an example of your compose, with let's say 2-3 emails (of course just anonymize the emails). 

[VikasNagaraj]

@Heartholme 

Here are the compose outputs 

Screen shot of flow.

Select: 

item()?['Email']

Compose: 

union(body('Select'),body('Select'))

Compose:

join(outputs('Compose'), ';')

[StretchFredrik]

You can try making it into an array with the following:

split(stringvariable, ';')

[Heartholme]

Use this expression in a compose: 

split(outputs('compose_2'),';')

Then put this in an apply to each, and the compose (current item dynamic content) in the 'to' field in send an email within the apply to each. 

[VikasNagaraj]

@Heartholme @StretchFredrik 

So instead of join i use 

split(outputs('Compose'), ';') in the last compose.

What will be the select ouput from previous step?

[Heartholme]

The compose you put split(outputs('Compose'), ';') in. 

[Heartholme]

@VikasNagaraj After that select current item as dynamic content in the 'to' field of send an email within the apply to each. 

[VikasNagaraj]

@Heartholme 

Came up with this error 

[Heartholme]

Ah, then you already have your emails in a Array format. So you can probably use this action in the email, if your output is like this

{

'email'

},

{

'email2'

}

I would advise you to just use the split on the compose_2 action, just to see how your output should be, and test the flow successfully. 

Then it will be a lot easier for you to apply this on your other compose steps since you remove the duplicates etc there. 

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme

 

[VikasNagaraj]

@Heartholme 

I am sorry it just went over my head, where exactly should i use this 

{

'email'

},

{

'email2'

}

[Heartholme]

That is just an example array, how you want your output to look, so you can use it in an Apply to each, but you can nevermind that for now. 

I misunderstood your flow, though Compose2 was an earlier action, but this is the final action you should use the expression on. This will split it like you need it, so that it comes in the correct array format. 

So use split(outputs('compose_2'),';') in a compose 😊

[VikasNagaraj]

@Heartholme 

I am sorry i think i confused you a lot here. 

Filter array 2: First it filters the project from data set,

Select: then selects the email

Compose: Union combines all the email address to array.

Compose2: should split the outputs from compose. Am i right ? 

Now where excatly should i use the split function here? in compose 2 right ?

[Heartholme · Accepted solution]

@VikasNagaraj 

100% Understandable that you're a bit confused. 

Return the flow to this state: 

Then make a new compose, with the following expression:

split(outputs('compose_2'),';')

then use the new compose in an apply to each, and use the current item (dynamic content) from this apply to each, in the to in send an email. 

Hopefully I was able to clear this up. 

Br

Heartholme

[VikasNagaraj]

@Heartholme 

It perfectly worked, thank you very much for your time and response. 🙂

@StretchFredrik 

Thanks for your inputs and time as well.

[Heartholme]

@VikasNagaraj 

No worries, glad to help!