It will be super convenient if you can sync list between SharePoint sites. After you finish reading this post, you will know how to sync lists by using Power Automate and MultCloud. If you are not familiar with SharePoint Online lists, you can learn from the introduction of it in this post. Also, some reasons for why SharePoint users sync lists between sites are shown for you.
Since I'm still learning SharePoint, is it possible to connect or sync two lists that are located in separate SharePoint Online sites?
- Question from SharePoint Stack Exchange
I am managing 2 Sharepoint Lists: the first one is called List 1 and the second one – List 2. In this second list, there are columns that are found in the first list and I would like them to be synced automatically. This means that if an item is deleted from List 1, it should be deleted from List 2. Also, if an item is created in List 1 or modified, then those items or modifications should also appear in List 2. This list further includes some other columns which are not available in List 1 as well.
- Question from Learn Microsoft
This post will give you 2 ways to make SharePoint sync lists between sites. One is using MultCloud Cloud Sync. It is a way that can automatically sync lists between different sites or accounts. Besides, it gives you multiple sync modes like Cumulative Sync, Full Backup Sync, etc. which can satisfy your various requirements. Another is using Power Automate. It is a Microsoft file migration tool by which you can create a workflow to sync the lists.
A SharePoint list is one of the SharePoint features. It is used to collect different kinds of content like contacts, tasks, and issues, and display them in rows and columns. The rows represent individual items in the lists, while the columns define the information that you want to store. After you create a SharePoint list, you can share it with your team members or others who have access permission.
SharePoint lists are of great use because they provide different templates that you can choose from, such as an Issue tracker, Event itinerary, and Asset manager. You can also create a new template by uploading a CSV or designing your own. SharePoint lists can be also customized with various features such as validation rules, default values, calculated columns, and workflows. You can make full use of these features to optimize business processes and improve data quality.
You must have a basic impression of SharePoint lists from the first section and this section will list 5 reasons why some users make SharePoint Online lists sync between sites.
As you can see, syncing SharePoint lists between sites can benefit you a lot. It is much helpful in consolidating data, advancing team collaboration, automating workflows, making reports, and recovering data. So how to sync SharePoint lists between sites? The next parts will give you the answer.
The former part illustrates 5 fortes of SharePoint syncing lists between sites, and this part will introduce the easiest way to you, which is syncing through MultCloud.
To SharePoint sync lists between sites, you can use MultCloud Cloud Sync which is the best SharePoint sync tool. It will instantly sync every change to the destination account if you use the Real-Time Sync. Moreover, if you want the sync process to go both ways (changes in A sync to B while changes in B sync to A), the Two-way Sync mode can meet your needs well. Since MultCloud not only supports SharePoint Online but also other clouds like Google Drive, Dropbox, OneDrive, iCloud Drive, pCloud, and OneDrive for Business, you can also apply this way to other syncing tasks.
Step 1: Open MultCloud and get a new MultCloud account by clicking the button “Get started for free”.
Step 2: Add different SharePoint Online accounts to MultCloud by clicking “Add Cloud” and the SharePoint Online icon. Here you have to log in to your accounts in the pop-up windows.
Step 3: Click Cloud Sync in the left sidebar and select the lists that you want to sync. Also, you have to choose another account or folder to receive the lists. After the selection, you can open "Options" to choose a sync mode if you need it and then tap the “Sync Now” button to run the task.
Notes:
There is another way for you to sync lists between different SharePoint sites which is using Power Automate. Power Automate is designed by Microsoft, aiming to create automated workflows and tasks between various applications and services. This way can be much more complex than the first one because this way has more steps.
Step 1: Enter the Microsoft 365 website and log in to your account. Then find Power Automate in the sidebar and open it.
Step 2: Navigate the “My Flows” page and create a new flow by clicking “Create”.
Step 3: Click “Automated cloud flow”. Then you have to give a name for the task and choose “SharePoint-When an item is created or modified.”
Step 4: Select the one source SharePoint site and list to configure the SharePoint connector.
Step 5: Add a “Get items” action from the SharePoint connector to retrieve the data from the source list.
Step 6: Repeat Step 4.
Step 7: Add the “Create item” or “Update item” action from the SharePoint connector to create or update an item in the target list.
Step 8: Select the target SharePoint site and list to configure the “Create item” or “Update item” action. Then map the fields between the source and target lists. Finally, save and test the workflow, and the task is established.
This post first introduces SharePoint lists to you and provides 5 reasons why some users want SharePoint to sync lists between different sites. Then it tells you 2 solutions on how does SharePoint sync lists between sites. One way is syncing via MultCloud. The other one is syncing via Power Automate whose steps are more difficult than the first one.
Except for syncing SharePoint lists between different sites, MultCloud can be also used to sync other clouds, such as syncing iCloud Photos with Google Photos. If you have the need, it is a good choice to try MultCloud.