How to send emails based on excel row

Like (1) Share

Report

Posted on 1 Nov 2023 18:13:37 by DMan

Hello,

I could use help (first time user) understanding how to do the flowing:

I have an excel file of employees with their name, department and start date.

column 1 is employee status

column 2 is employee name

column 3 is employee department

column 4 is employee start date

column 5 is employee job title

When I execute the flow, I want it to look into the excel sheet and for any employee who is listed as NEW in column 1, it sends 6 emails via MS Outlook to various managers informing various manager of the new employee. The emails have canned text, but also need to “fill in the blank” with some or all of the data in columns 1-5.

any help or examples of something similar would be appreciated!!!

All responses (5)

Answers (0)

trice602 13,911 Super User 2025 Season 1 on 01 Nov 2023 at 21:01:24

Like (0)

Report

Re: How to send emails based on excel row

Hi @DMan ,

In the new editor you first need to select the location and additional information where your Excel file is located, shown below. Next, click on "new connection" (if needed) and create a connection to your OneDrive for Business and the excel table directly.
DMan 10 on 01 Nov 2023 at 20:12:25

Like (1)

Report

Re: How to send emails based on excel row

My second question is, how to I resolve this error "You have a broken connection for 'List rows present in a table'. Please fix connection . Alternately, you can select another valid connection or create a new connection from connections tab in the action pane."
DMan 10 on 01 Nov 2023 at 20:11:18

Like (1)

Report

Re: How to send emails based on excel row
trice602 13,911 Super User 2025 Season 1 on 01 Nov 2023 at 19:17:25

Like (0)

Report

Re: How to send emails based on excel row

Hi @DMan ,

Here's more of the flow. As you see below, there's 6 individual email actions so you can have 6 different emails with 6 different email templates of canned messages.

This is setup with a manual trigger but could run on a schedule once a day, week, or monthly and send out emails for new employee additions.
trice602 13,911 Super User 2025 Season 1 on 01 Nov 2023 at 18:34:57

Like (0)

Report

Re: How to send emails based on excel row

Hi @DMan ,

Here's some framework to help you get started. Here I have a table of data as described above.

In my list rows action, I have a filter on NEW and my dates are in ISO format.

Next I have a Send email V2 action. This automatically wraps in an apply to each because there may be more than one email and in this example, I would have 6 different email actions, one for each template (assuming they are different). I only added two here but you get the point.