{"id":7119,"date":"2016-12-20T15:06:03","date_gmt":"2016-12-20T07:06:03","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=7119"},"modified":"2023-07-31T11:38:09","modified_gmt":"2023-07-31T03:38:09","slug":"sync-data-between-two-sharepoint-lists-using-boostsolutions-list-sync","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/sync-data-between-two-sharepoint-lists-using-boostsolutions-list-sync\/","title":{"rendered":"Sync data between two SharePoint lists using BoostSolutions List Sync"},"content":{"rendered":"<p>Sometimes, we may have such a scenario. There are several lists on SharePoint site, and they contain the same columns and values. It\u2019s time-consuming to keep the column same manually. We can configure a workflow or event handler to do it, also you can choose a tool to complete it, such as BoostSolutions List Sync. In this blog, I will introduce how to sync data between multiple SharePoint lists using this tool. There are three SharePoint lists, Project Summary list, Project A list and Project B list.<\/p>\n<p>Project A \u2013 This list contains the details for Project A, such Task Name, Status, Progress, Assigned To, % Complete, Descriptions and more. <a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7121\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-1.png\" alt=\"sharepoint-list-sync-1\" width=\"611\" height=\"352\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-1.png 611w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-1-300x172.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/p>\n<p>Project B \u2013 This list contains the same fields with Project A list.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7122\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-2.png\" alt=\"sharepoint-list-sync-2\" width=\"601\" height=\"425\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-2.png 601w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-2-300x212.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p>Project Summary \u2013 This list contains the summaries about Project A and Project B list, such as Task Title, Status, Progress, Percentage, these fields are same as Project A and Project B lists. And it contains other fields, such as Evaluation and Analysis. To enable Project Manager to track the tasks of these two projects in one view easily, now I want to sync the In Progress status tasks from Project A and Project B lists to Project Summary list.<\/p>\n<p>First of all, I create a profile in List Sync Main settings page. Select Project A list as the source list and select Project Summary list as target list.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7123\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-3.png\" alt=\"sharepoint-list-sync-3\" width=\"557\" height=\"482\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-3.png 557w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-3-300x259.png 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p>Under Source Site and List section, specify the condition as \u201c[Task Status] is equal to \u201cIn Progress\u201d\u201d, which means that only \u201cIn Progress\u201d tasks will be synced to the Project Summary list. Next, map the columns between these two lists as following.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7124\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-4.png\" alt=\"sharepoint-list-sync-4\" width=\"871\" height=\"235\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-4.png 871w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-4-300x80.png 300w\" sizes=\"(max-width: 871px) 100vw, 871px\" \/><\/a><\/p>\n<p>And then save the profile. Create the second profile, select the Project B as the source list and select Project Summary as the target list.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7125\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-5.png\" alt=\"sharepoint-list-sync-5\" width=\"558\" height=\"465\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-5.png 558w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-5-300x249.png 300w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>Configure other settings as same as first profile, and save the profile. Finally click <strong>Sync <\/strong><strong>Now<\/strong> command of each profile.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-6.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7126\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-6.png\" alt=\"sharepoint-list-sync-6\" width=\"260\" height=\"226\" \/><\/a><\/p>\n<p>Then, the In Progress tasks of Project A and Project B lists are synced to the Project Summary list as following.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-7.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7127\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-7.png\" alt=\"sharepoint-list-sync-7\" width=\"616\" height=\"387\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-7.png 616w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2016\/12\/SharePoint-List-Sync-7-300x188.png 300w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/a><\/p>\n<p>And now I can edit Evaluation and Analysis columns to fulfill the tasks information. \u00a0 To learn more features about BoostSolutions List Sync, please visit <a href=\"http:\/\/www.boostsolutions.com\/list-sync.html\">http:\/\/www.boostsolutions.com\/list-sync.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes, we may have such a scenario. There are several lists on SharePoint site, and they contain the same columns and values. It\u2019s time-consuming to keep the column same manually. We can configure a workflow or event handler to do it, also you can choose a tool to complete it, such as BoostSolutions List Sync. [&hellip;]<\/p>\n","protected":false},"author":69,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,347],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7119"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7119"}],"version-history":[{"count":6,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7119\/revisions"}],"predecessor-version":[{"id":9143,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7119\/revisions\/9143"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}