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.
