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.