Forum Discussion
Jack Hindley
Nov 18, 2017Copper Contributor
Trigger email based on columns of a list
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...
Deleted
Nov 27, 2017how large is the list? I would just setup a flow on the list, that has reoccurring runtime, that get's the list items, then does a for each loop on them, looking for x = y, then send e-mail. Shouldn't be too overly difficult. Now if the list is or can be over 5000 entries being returned into your 'get list items' action it gets more difficult, but you can filter to the ones needing to be sent the e-mail so hopefully that will never be more than 5000 and it should be fairly straight forward.
You may have already figured this out since it's a few weeks old now, i had it marked in my e-mail and just getting around to it after vaca!
You may have already figured this out since it's a few weeks old now, i had it marked in my e-mail and just getting around to it after vaca!
Jack Hindley
Nov 28, 2017Copper Contributor
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.