Reminder email based on due date in excel

[athota]

Hello,

I am new to power automate, i am trying to create a flow which will send a reminder email to my team member on a specific due date. I am from India and my time zone is "(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi", my reminder due date in excel is in date-month-year (dd-MMM-yyyy) format. An email has to be sent for the task on the reminder date mentioned. I have not added email id in the table as it is not dynamic. Can any one please help me build the flow.

Thanks

[dimitrisval]

Hi Krish1729,

Take a look at the link below how to Automatically Email Reminders from Excel with Power Automate

https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

Regards

Dimitris

[krish1729]

Hello @dimitrisval 

Thank you for sharing the link.

Thanks,

Krishna

[StephanieS]

Removed because my question changed. See other reply. 

[StephanieS]

Hello, 

I am trying to build a flow based off of this one that will send an email out to a responsible member of my team when a chemical for which they are responsible in the lab is nearing it's expiration that will remind them to reorder it. 

This is the test spreadsheet I am working off of to set it up:

The flow that I have set up is working but it is sending me 12 emails that all say the 2 chemicals are due for reorder. Since there are 2 rows in my spreadsheet I am assuming I am getting an email for each row that it is checking. I believe this is happening because when I go to add the "Send an email" step, it automatically converts it to an "Apply to each" step when I select the Responsible Person Email dynamic content. 

Is there a way to have it not send an email for each row and only for the rows that are due?

Thanks in advance for any help. 

[ckteo]

hi @v-LilyW-msft 
Based on your suggestion, is worked!

But i would like to received the email when due date only, is it possible?

Currently, because of recurrence flow it will trigger everyday. But the email will continue send daily even though dont have due date.

Thanks in advance. 

best regards, 

CK Teo

[Anonymous]

Hello,

I tried using the select function but the Apply to each function keep auto populated. how to prevent this?

[Anonymous]

Hello,

My Select function will always auto populate the Apply to each function. any way to prevent this?

[Anonymous]

Hi @v-LilyW-msft ,

will the email be sent on days that doesn't have tasks with reminder due date? 

[Kiran4]

Getting error,

[PALQD]

what should i do if some of the task doesn't have due date

[Big_Boy]

I want to create an email reminder where it will remind me 1 month before the products end date but I want the email only to be send if there is a reminder date...let's say no product end date on March, I don't want the email to still send on March

[Big_Boy]

hi, let's say I have a different reminder date for each task...and it is monthly recurrence etc. 1/8,1/9...if there's no reminder date triggered in that particular month...how do I make it so that it does not send email...I'm stuck with using condition

[Big_Boy]

already found the solution? If you do, mind sharing it?

[Big_Boy]

If you already found the solution, mind sharing it?