Archiving the old list values into another list in SharePoint online?

Question

I have sharepoint list having the data from last 2 years in SharePoint online

I want to move the archive data of this sharepoint liist to some list in SharePoint online
How we can achieve this ?how many methods?
Is there any possibility to archive this data by using workflows?

Answer 1

As SharePoint Online is going to stop its support of SharePoint workflow, I will suggest you to use Microsoft Power Automate (Used to be called as Flow ) to do the work. An example is here: https://support.microsoft.com/en-us/help/4467880/how-to-copy-items-between-two-sharepoint-lists-by-using-flow

This flow will copy list items from source list to destination list, just like your requirements.

You can change the trigger from When an item is created or modified to Manually trigger a flow which may make it more handy.

There is a limitation about it, if you have columns enabling multi value, things will become a bit more complex as we need to handle them separately. Or, the flow will treat each value as one record. Usually we will need to use Rest Api to get the column values and store them in an array for creating items in the destination list.

For the detailed process, here are two examples for your reference:
https://www.c-sharpcorner.com/article/update-multi-values-people-picker-field-in-power-automatemicrosoft-flow/
https://powerusers.microsoft.com/t5/Building-Flows/How-to-patch-a-multi-person-field-from-one-SharePoint-list-to/td-p/283286?lightbox-message-images-284885=66049i17BD066A93BBBDA7