I have a list stores12,000 items. I need to create a process to check the expiry date on each item and send email if expired.
What is the most efficient way to do it? To use Nintex Site Workflow to call the workflow on each item to check the expiration date or to use Sharepoint Information Management Policies retention rule to check the expiration date on each item and call the workflow if expired.
Solved! Go to Solution.
@lcha I haven't really used Information Management Policies. If I was going to do a workflow I would have a workflow that runs on a schedule and queries the list for expiry dates in the next x amount of time and then does something based on that query.