Answered

Send Email Based on Dates from Multiple Columns

(0) Share

Report

Posted on by KMacias

I'm a novice to Power Automate. I have an Excel spreadsheet with due dates listed in 3 columns. 7 days before those those dates, I'd like an email sent to a manager. I figured out how to make this work by looking at just one column, but can't manage to get it to work by looking at all 3 columns.

Employee Name

Manager Email

Date 1

Date 2

Date 3

So, if it's 7 days before date 1 OR date 2 OR date 3, I'd like an email triggered to send to the manager listed in Manager Email. Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Redders 546 on at

Like (0)

Report
Copy link

Link copied!

Hi @KMacias,

It is useful to add screenshots of your flow to see what you have created so far, here is a link that shows you
How to write a good forum post

Although, if you have created 1 flow that works when looking at 1 date, can you create 2 other individual flows that look at the other 2 dates? Is it important to only have it included in 1 flow?

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @KMacias

Could you please tell me:
Do you want to send an email when today's date equals the date in any of the three columns minus 7?
First you need to place the data in Excel in a table.
You can set the trigger to fire once a day.
You can use condition to check if the date matches.
I made a test for your reference:
1.
2.
3.

4.

Best Regards,
Levi

Was this reply helpful? Yes No
KMacias 2 on at

Like (0)

Report
Copy link

Link copied!

I was following the steps from this site: https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

I went with your suggestion and just created two additional branches with the same workflows and it worked! There is a chance the same manager could get 3 separate emails because this sends separate emails per date column, but I think I can live with that. Thank you!

Was this reply helpful? Yes No