Workflow to archive list items to another list on the same site

Hi,

this shouldn't be too hard actually. Just create a site-workflow like this:

At first you have to calculate the date from which on items should be archived and store this in a variable (vArchiveDate)

Then query the list to get all items, whose end-date is less than the archive date.

Finally you loop over the list of IDs create a copy of the item and then delete the item.

Instead of deleting every item individually you could also use the "delete multiple items" action, which uses the same filter-setting as the query-list-action:

Thank you for the quick and extremely helpful answer! 

As I am still a bit confused, I have a follow up question. 

How should I setup "for each" function? That is:

Target collection? 

Store result in? 

Index? 

I assumed that for the query I should create a new workflow variable (vColArchivelds). Hopefully this is correct!

Thank you again :-)

Bests,

Paavo

Hi,

here you go:

and just in case:

The Index of the loop-action is not needed in this case, so you can just leave that empy.

Please remember to mark my reply as helpful/correct - if appropriate.

Awesome! Thank you :-)

don't forget to mark the answer as correct!

Excellent!  

When I run this the newly created items on the archive list start the workflows from the original list. Is there are way to prevent that?

Thank you so much!!! your post saved me and my time. Great post. :)

I know it is 1 1/2 year ago the solution was posted but I hope someone can help me.

I have a similar question and tried this solution but when I copy from List A to List B item 2 and 3 is overwritten with data from item 1...

I have a Task list (List A) which is connected to a Project list. In List A I have several look-up columns to the Project list. One of them is Project status. I want the workflow to go through List A once a month and copy/move all tasks with Project status "Closed" to my Archive list (List B) and then delete the task from List A. I have followed the above steps and started at "Query list". But as I wrote all items get the same data.

That seems odd. Sounds like you're looping but you are not updating the current-item-id. You should check the "Store current result" of the for-each action as well as the copy-item action. Both have to use the same variable.

Thank you for the answer. Now it works! I had put in the wrong variable in copy-item action...

I really hope you can assist me, could you show how to archive and delete the item in another library in sharepoint 2019. I have a library with more than 1000 items and needs to be archive. Many thanks