I am creating items in a SharePoint list through a Excel VBA macro.
The macro takes a large document, breaks it apart into 15,000 work items and creates a SharePoint list item for each of the 15,000.
I want to use Nintex workflow to check the number of items in a list.
As the macro is adding items, when the list reaches 4,500 items, can Nintex workflow move the 4,500 items to another list while and the macro continues to populate the original list until it reaches 4,500 items, and so on.
I am trying to avoid the 5,000 item throttling limit in SharePoint.
Thank you for the help.