Nov 18 2017 04:12 AM
Folks,
I really need some help here and I have seen how useful these messageboards are. I need to send an email to everyone in a SharePoint list who was [LastTrained] 11 months ago to warn them that they need to renew. [LastTrained] is the name of the column in my SharePoint list and it has dates in dd-mm-yyyy format. I have been into SharePoint Designer and MS Flow but I am not versed in any code.
If it's of any use, I am currently looking into a Flow that triggers on a schedule every two days that emails the list per a filter of adddays, [LastTrained], 335 but the filter is the part I am having trouble with. Open to any Office 365 solutions though.
A point in the right direction would be helpful.
Jack
Nov 27 2017 02:31 PM
Nov 28 2017 01:37 AM
Yes, thank you Christopher. I figured something out. It's running on 2,500 list items at the moment to trigger a workflow on all items where the condition is 335 days since [LastTrained]. This feels in efficient but it hasn't thrown any problems.