I am working on a workflow that is giving me trouble. My intent is to start the workflow by deleting all the items in a list and then repopulate the entire list with new up to date data.
For the sake of argument let's assume the list contains 8,000 rows.
To delete all items I am...
1) Query List - All ID's in the list assigned to a Collection variable
2) For Each - For each ID in the Collection variable assign an ID to a variable
2a) Delete Item - Delete the ID that was assigned to the variable in step 2
3) Additional steps to re-populate the data.
Does anyone have any experience trying to delete all items from a list on a schedule? I know the Delete Item will delete a whole row if you delete the ID for that row. I have tested that. I can even do 100 at a time without a if I loop through a specific list of sequential ID's using a loop. That obviously won't work as the ID's change as the list would get updated.
Logically I think my thought process is correct for how this should work but I must be missing something. Does anyone have any ideas? Is it possible that deleting more than 100 items is a restriction? Any thoughts? I can share my workflow if that would help.
Are you using on prem version of Nintex? If so, did you know there was a "delete multiple items" action that does everything you described for you (as far as deleting items goes).
In theory it's possible but because there are so many items it seems easier to just delete all the items and then repopulate the list with the most up to date info.
I've used it in the past to delete more than 100 items, but I'm sure the performance can vary on a number of things. The whole delete/recreate method is pretty process intensive and time consuming. When lists became much larger we've even turned to third party tools (such as layer2) to manage the list items in such a way, where it made more sense than having the workflow itself do it. 100 items isn't all that much in the context of a list so you should be fine... although do consider alternative methods if you feel the list will grow.