Archieve/Sync SharePoint List to another list

Question

Hello,

I am looking to archive sharepoint list data to another list and open for all the options i.e. CSOM/Power Automate/Logic Apps .
Below is my list configurations:

1. Has unique permissions enabled
2. List item count ~1000
3. Does not have site column
4. Schema is dynamic i.e. columns are added/removed at regular interval

Expectation is that archived list should be in sync in terms of schema with minimum manual intervention.

Answer 1

Here are a few options:

1. If you want to keep the list data synced dynamically, consider building a Flow referring to this article: How to use Flow to copy items between two data sources.
   But of course the item permissions are not carried over, and here is another reference to change the inheritance on request: How to manage permissions on a SharePoint List Item using Microsoft Flow – changing Item permissions.
2. Use PowerShell to copy list data regularly.
   You can refer to the article here for sample scripts: SharePoint Online: Copy List Items from One List to Another using PowerShell.
   For automation need: SharePoint Online: How to Schedule a PowerShell Script using Azure Automation?

*Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. *

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
**Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **