How to send emails based on excel row

(1) Share

Report

Posted on 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!!!

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

trice602 16,016 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
trice602 16,016 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DMan 10 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
DMan 10 on at

Like (1)

Report
Copy link

Link copied!

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."

Was this reply helpful? Yes No
trice602 16,016 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No