I have an equipment list that is accessed in drop down lists in a number of nintex forms. To keep this list up to date, I query an equipment table in a sql database. I bring back about 3,000 equipment items from the DB, and I only want to update the sharepoint list with DB items that don't already exist in the sharepoint list.
So I loop through the DB list and for each DB item I then loop through the sharepoint list items which also contains about 3,000 items.
The workflow status always says Failed on Start (retrying). And never seems to update the list.
Is there a way to update such a large list this way?