In this article, I have explained the steps to send emails for list of people given in the excel worksheet using Power Automate Flow.
Get the excel worksheet ready:
Please verify whether the excel worksheet is in proper format without any unwanted junk characters in it. Also, select the range of cells and create it as table. You can refer the table in flow, that will make your job easy by fetching the data from excel worksheet.
To create table from the range of cells in worksheet, first select the range of cells as shown below. Then click on the “Insert” menu, in which there is an Icon named Table, click on that to convert the range of cells to table.
Creating a Flow to read the worksheet and send email to List of People:
Now, we need to create a new scheduled workflow as shown below:
Go to “Power Automate” from your Office 365 home page.
After landing in Power Automate app, click on “My flows” and “+ New flow”. List of flow types will be displayed. From that select “Scheduled cloud flow”.
Setting time interval to trigger the flow.
Here in this example, I have scheduled this workflow to trigger monthly once, but there are options to trigger Monthly, Weekly, Daily and Hourly also (frequency).
Next thing is to add the “Initialize variable” action. If you want to use the variable, you need to Initialize variable first and then you can set value to variable using “Set Variable” action. Later the variable can be used in any part of the flow.
Click on the “+ New step” button to add new condition or action.
You can select the “Type” of the variable and name it as “varEmailAddresses”.
Click “+ Next step” to add new action for reading the excel worksheet and configure it.
Select “List rows present in a table” option to map the table in the Excel from Flow.
Add new step for reading each row from the excel worksheet and send email to the list of users.
Now add the “Set Variable” action and assign email address got from the excel worksheet fields.
To send email we need to add the action “Send an email (V2)”.
Set the values for “To” address using the “varEmailAddresses”, Subject and Body for the email. You can also use the “Cc” and “Bcc” fields while configuring the “Send email”.
Output: Finally we got the email from the “Schedule cloud flow”, using the email addresses from excel worksheet.