question

nileshkodulkar-3248 avatar image
0 Votes"
nileshkodulkar-3248 asked ChelseaWu-MSFT commented

Archieve/Sync SharePoint List to another list

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.




office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ChelseaWu-MSFT avatar image
0 Votes"
ChelseaWu-MSFT answered ChelseaWu-MSFT commented

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.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

Thanks for your response.

Syncing of source list schema/columns with destination list has to be handled independently?

0 Votes 0 ·

If you mean permission inheritance then yes, it needs separate handling from list contents.
Permissions will not be carried by default when contents are copied or moved.

0 Votes 0 ·

I was referring to the below scenario:
1. column in source list is deleted
2. new column is source list is added

Destination list will not have these changes.



0 Votes 0 ·
Show more comments