how to send emails individually from a bulk list

[Anonymous]

Hello Power AutoBots,

I'm Very new to Power Automate and i wanted to create a flow:

1. I have a list of email ID's | I have a .CSV with email id's | I can add multiple emails in the input area 

2. from those mass list of emails 

I need help in Creating a flow where i can send emails individually even from any of the above scenario from option 1. 

Thanks in Advance

Regards,

Dhage 

[Anonymous]

1. tart by signing in to Power Automate and clicking on the "Create" button in the left-hand navigation bar. Choose "Instant-from blank" to create a new flow from scratch.

2. Select "Manually trigger a flow" as the trigger for your flow. This will allow you to manually initiate the flow each time you want to send an email.

3. Add a new "Get items" action from the list of available connectors. Choose the SharePoint connector (or the connector that corresponds to the platform where your contact information is stored) and select the list or library where your contact information is stored.

4. Configure the "Get items" action to filter the list of contacts, if necessary. For example, you may only want to send emails to contacts with a certain job title or in a certain department.

5. Add a new "Apply to each" action and select the output from the previous step as the input. This will allow you to loop through each item in the list and apply the same actions to each one.

6. Within the "Apply to each" action, add a new "Send an email" action. Choose the email connector that you want to use (such as Outlook or Gmail) and enter the email addresses of your recipients in the "To" field.

7. You can also add a subject and body for the email, either by hardcoding the values or by pulling them from the contact list using dynamic content. For example, you might want to include the recipient's name or job title in the subject or body of the email.

8. Save and run the flow. When you trigger it manually, the flow will loop through each item in your contact list and send an email to the corresponding email address.

these are the steps i'm trying to follow but unable to understand 

[Heartholme]

Hi @Anonymous,

If I understood you correctly, this is where the issue lies: 

You need to put the email adresses from your SP list here. 

This will iterate through each line in your list and send an individual email to each person. 

Let me know how this goes! 

{ 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

[Anonymous]

@Heartholme 
yes i have tried removing the email id & Initializing variable as email and enter input when flow triggers 

still didn't help me understand. 

[Heartholme]

@Anonymous 

In your list you have one row for each email right? In this case you should only reference the mailID in your "Send an email action":

This will in turn put the send an email into an "Apply to each". The apply to each will go through each email in the list and send an mail to the mail for every row. 

Let me know how it goes. 

Br 

HH

[Anonymous]

Thanks @Heartholme  ill  try this way 

[Anonymous]

but by this, the flow is only send the email that are in the list,

my senario is if there are multiple emails entered and i have to send the same message individually without sending the other emails as cc or as to be shown sent in group then what way i can create a flow?

below is an example of an application i have created in PowerApps where i have entered email id's but when I clicked submit then i can send the mail individually

i hope now you have a clear picture of my required flow.


Thanks HH in advance. 😊

[Heartholme · Accepted solution]

@Anonymous 

Ah, ok. Now I have a clear understanding of the issue. So, you want your email in an array from your registration in each row, this is achived like this: 

In your second compose you want this expression: 

split(outputs('compose'),';')

In the filter array you put Compose 2 in the "From", then as an expression put item() in left side of filter array, which should be "Not equal to" and leave the last field blank. 

Then add an apply to each and reference the filter array as dynamic content: 

This should do the trick! 

Br

HH

[Heartholme]

 @Anonymous Did it work? 😊

[Anonymous]

I was just about to get back to you,

Yes that worked like magik and marked it as solution.

Thank you so much @Heartholme 

You are a saviour 

[Heartholme]

Perfect! Glad to hear 😄

Br

HH

[Anonymous]

now as i checked my flow it working great, now i'm receiving an error while connecting to power app for new applicant screen 

@Heartholme 

[Heartholme]

Try this: 

[Anonymous]

this i have updated and got that as shown below

that's the flow that i have created

my entire PowerApp and Flow in once screen now i need to connect that flow ?

[Heartholme]

Seems to be working correct now? 

If you have a flow that's failed a run it will show a error, but it should still work. 

If it works now, you're all good. 

BR

HH

[Anonymous]

@Heartholme  i Understood now 
i have created in from powerapps and now the flow is working amazing 

[Anonymous]

@Heartholme I trying to find a solution to this 
external user flow adding to sharepoint



for the continuation to above flow this is what im trying 
am in the right direction ??

Thanks in Advance
br,
Dhage