cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Leighmer
Frequent Visitor

send reminder email with table content based on excel table

Hi,

I have tried multiple ways to do this same thing with no avail.

 

Can someone please help me create a flow that will send a reminder email based on a table in an excel file. Specifically, I want and email sent 2 weeks and 2 days before the class date if there is missing information in a column. 

 

In trying to find a way to do it, I have made the class date and the missing information a part of the documents properties to is shows in the columns in Sharepoint. I'm not sure if that is helpful.

 

The excel file is a template with 8 worksheets. The table needed is on the last worksheet and  name will always be the same. The file will always be located in the same folder in Sharepoint.

excel template.png

sp columns.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Leighmer,

Do you want to send email when today is 2 weeks and 2 days before than the class date?

 

Here is a simple demo, please check as below:

vqiaqimsft_0-1656053370310.png

Enter the following two formulas within the condition tab

empty(items('Apply_to_each')?['Studentname'])
bool('True')

Then, add a group to create an "or" condition for the date comparison, you should make these two conditions have or relationship:

addDays('1899-12-30',int(item()['StartDate']),'yyyy-MM-dd')
addDays(utcNow(),-14,'yyyy-MM-dd')
addDays('1899-12-30',int(item()['StartDate']),'yyyy-MM-dd')
addDays(utcNow(),-2,'yyyy-MM-dd')
Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi @Leighmer,

Do you want to send email when today is 2 weeks and 2 days before than the class date?

 

Here is a simple demo, please check as below:

vqiaqimsft_0-1656053370310.png

Enter the following two formulas within the condition tab

empty(items('Apply_to_each')?['Studentname'])
bool('True')

Then, add a group to create an "or" condition for the date comparison, you should make these two conditions have or relationship:

addDays('1899-12-30',int(item()['StartDate']),'yyyy-MM-dd')
addDays(utcNow(),-14,'yyyy-MM-dd')
addDays('1899-12-30',int(item()['StartDate']),'yyyy-MM-dd')
addDays(utcNow(),-2,'yyyy-MM-dd')
Best Regards,
Qi

@v-qiaqi-msft Thank you for answering, I will try this. Will this work for any file in that folder? The tables will be named the same in everyone but the file name may differ.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,004)