I am trying to build a flow that will send an email to people if they are within 30 days of a training expiring and continue to send an email weekly until the date taken is updated. I have a SharePoint list with date training was taken and a calculated column that is 11 months after that date. I can t seem to get the emails to work. if I use "greater than or equal to" TODAY, I will get a email of every entry. I have tried several different ways to enter the conditions and either get all results or none. I cant seem to only get the email for entries that are after the due date. I ended up using another calculated field to get the number of days between today and the calculated date and only return positive numbers. Then I can get only the people needing to take the training, but that field only updates if the line is edited and saved. In my head this flow or one very similar should work. FYI I send the email to myself and the person needing the training.
Solved! Go to Solution.
Please look below:
Adding Through Expression:
I ended up removing all the format language and went back to a simple condition. Using the expression pane did the trick my flow now looks like this. Only using the utcNow() formula.
User | Count |
---|---|
87 | |
43 | |
21 | |
18 | |
16 |
User | Count |
---|---|
132 | |
47 | |
42 | |
36 | |
28 |