send reminder email with table content based on excel table

[Leighmer]

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.

 

 

[v-qiaqi-msft · Accepted solution]

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:

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')

[Leighmer]

@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.