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.
Solved! Go to 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')
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')
@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.
User | Count |
---|---|
96 | |
40 | |
25 | |
22 | |
16 |
User | Count |
---|---|
129 | |
51 | |
48 | |
35 | |
24 |