cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VikasNagaraj
Helper V
Helper V

Help with Sending email.

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 ?

 

VikasNagaraj_0-1661500626134.png

 

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 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Heartholme
Super User
Super User

@VikasNagaraj 

 

100% Understandable that you're a bit confused. 

 

Return the flow to this state: 

 

Heartholme_0-1661508767726.png

 

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

View solution in original post

18 REPLIES 18
StretchFredrik
Super User
Super User

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
Super User
Super User

@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

@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
Super User
Super User

@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). 

@Heartholme 

Here are the compose outputs 

VikasNagaraj_0-1661502846040.png

Screen shot of flow.

VikasNagaraj_1-1661502903273.png

Select: 

item()?['Email']
 
Compose: 
union(body('Select'),body('Select'))
 
Compose:
join(outputs('Compose'), ';')

 

StretchFredrik
Super User
Super User

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

 

split(stringvariable, ';')
Heartholme
Super User
Super User

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
Helper V
Helper V

@Heartholme @StretchFredrik 

So instead of join i use 

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

What will be the select ouput from previous step?

VikasNagaraj_0-1661503496181.png

 

Heartholme
Super User
Super User

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

Heartholme
Super User
Super User

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

@Heartholme 

Came up with this error 

VikasNagaraj_0-1661505591417.png

 

Heartholme
Super User
Super User

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'

}

 

Heartholme_0-1661506513738.png

 

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. 

 

Heartholme_1-1661506602941.png

 

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

 

@Heartholme 

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

{

'email'

},

{

'email2'

}

Heartholme
Super User
Super User

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. 

Heartholme_0-1661507474276.png

 

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

 

 

@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 ?

 

VikasNagaraj_1-1661507970603.png

 

 

Heartholme
Super User
Super User

@VikasNagaraj 

 

100% Understandable that you're a bit confused. 

 

Return the flow to this state: 

 

Heartholme_0-1661508767726.png

 

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
Helper V
Helper V

@Heartholme 

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

 

@StretchFredrik 

Thanks for your inputs and time as well.

Heartholme
Super User
Super User

@VikasNagaraj 

 

No worries, glad to help!

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,957)