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

(1) Share

Report

Posted on by Prem4253

652

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Prem4253 652 on at

Like (1)

Report

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.

Was this reply helpful? Yes No