AnsweredAssumed Answered

Delete All Items from a List

Question asked by mxolen on Nov 22, 2017
Latest reply on Dec 11, 2017 by mmatsako

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.

Outcomes