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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,130)