If Today's date send email to people mentioned in Email Address column

(1) Share

Report

Posted on by Prem4253

369

Hello,

I've a SharePoint list with dates mentioning when that specific person will need to travel to customer. (excluding weekends)

For e.g. I have created a SharePoint list with Person Name, their Email Address and the dates when they need to travel.

Person Name	Date	Email
A	8/24/2023	A@123.com
B	8/25/2023	B@123.com
C	8/28/2023	C@123.com
D	8/29/2023	D@123.com

Flow to check if today's date is Aug 24, 2023, send an email to A person.

Tomorrow it will check Today's date i.e. Aug 25, 2023 and should send an email to B person.

Apart from above, is it possible, if a specific person is on leave i.e. if Person C is leave on Aug 28, skip Person C and send email to Person D (If not, ignore this and please advise for the above highlighted in green)

Thanks

All responses (2)

Answers (1)

Prem4253 369 on at

Like (1)

Report

Re: If Today's date send email to people mentioned in Email Address column

Hi @trice602 ,
I created a flow as instructed by you above. For today's date I applied my email id, and was able to get the email into my inbox.

I'm assuming that this flow will not run on Weekends, as I have excluded Weekend dates into my SharePoint list.

Thank you! for providing the solution.
Verified answer

trice602 13,768 Super User 2025 Season 1 on at

Like (0)

Report

Re: If Today's date send email to people mentioned in Email Address column

Hi @Prem4253 ,

Here's a quick flow to implement; does not include the PTO part but could be implemented and I will think about how.

In this example, this could run once a day at 5 AM. It will get all items with today's date and then email the appropriate person with any details you want to include.

The filter looks like this:

If this was helpful, please mark as a solution to help others find it quickly. Using this framework you can build onto it to meet your other requirements.