cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mr_oli
New Member

Send mail if specific value in cell appear

Hello!

 

I am wondering is there a way to send mail IF in specified column located in Excel Online date inserted will begin in for example 2 days?

 

Example:

Table with employee name and contract valid to date.
Today we have 23.09.2021. If at least one contract valid to date is 25.09.2021 I should get email. It will be great if email in body will contain employee name

1 ACCEPTED SOLUTION

Accepted Solutions
AnthonyAmador
Microsoft
Microsoft

Hi @mr_oli 

 

I made this table to create an example 

 

AnthonyAmador_0-1632516726827.png

AnthonyAmador_1-1632516790513.png

 

This formula basically what it does is take today's date increase it by 2 days and give it the format, in my case I select the exact format of the dates in my excel table. 

formatDateTime(addDays(utcNow(), +2), 'dd-MM-yyyy')

 

Then I compare the dates with the variable that we initialize and if is equal we send the email, if you have email and name in the excel table you can add it in the email. 

 

AnthonyAmador_2-1632517002817.png

 

I ran it and I got two emails with the names of the dogs 🙂

 

AnthonyAmador_3-1632517353606.png

 

Hope this help you. 

Best Regards.

 

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

2 REPLIES 2
AnthonyAmador
Microsoft
Microsoft

Hi @mr_oli 

 

I made this table to create an example 

 

AnthonyAmador_0-1632516726827.png

AnthonyAmador_1-1632516790513.png

 

This formula basically what it does is take today's date increase it by 2 days and give it the format, in my case I select the exact format of the dates in my excel table. 

formatDateTime(addDays(utcNow(), +2), 'dd-MM-yyyy')

 

Then I compare the dates with the variable that we initialize and if is equal we send the email, if you have email and name in the excel table you can add it in the email. 

 

AnthonyAmador_2-1632517002817.png

 

I ran it and I got two emails with the names of the dogs 🙂

 

AnthonyAmador_3-1632517353606.png

 

Hope this help you. 

Best Regards.

 

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

Wow, its working! Thank you!

Could you please tell me is there any way to test formulas? Something like immediate window?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,156)