{"id":5705,"date":"2013-07-02T22:00:38","date_gmt":"2013-07-02T14:00:38","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=5705"},"modified":"2023-07-31T11:38:52","modified_gmt":"2023-07-31T03:38:52","slug":"how-to-integrate-multiple-sharepoint-lists-into-one-list","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/how-to-integrate-multiple-sharepoint-lists-into-one-list\/","title":{"rendered":"How to integrate multiple SharePoint lists into one list"},"content":{"rendered":"<p>Having trouble integrating data from multiple SharePoint lists? <a href=\"http:\/\/www.boostsolutions.com\/data-connector.html\">SharePoint <b>Data Connector<\/b><\/a>, by BoostSolutions, will help you complete your tasks quickly and efficiently.<\/p>\n<p>The following scenario will help you to understand how Data Connector, as a lightweight out-of-the-box data transfer tool, combines data from multiple SharePoint lists.<\/p>\n<p>Assume that you have the following business requirements when using SharePoint:<\/p>\n<ul>\n<li><span style=\"line-height: 1.5;\">You have a list for the project team members, which contain all the projects information<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">A second list, for the finance, contains the budget and actual costs of the projects<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">You would like the data in the two lists to be integrated into one list, as a project overview, for your general manager<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">You want the data in the project overview list to be updated automatically by schedule<\/span><\/li>\n<\/ul>\n<p>Data Connector will fulfill your requirements and here is how it works.<\/p>\n<p><span style=\"line-height: 1.5;\">1. The following are the two lists you want to combine<\/span><\/p>\n<p>The <b>Project Info<\/b> list:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5721\" alt=\"integrate-multiple-sharepoint-lists1\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists1.png\" width=\"616\" height=\"316\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists1.png 616w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists1-300x153.png 300w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><\/p>\n<p>The <b>Project Cost<\/b> list:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5729\" alt=\"integrate-multiple-sharepoint-lists2\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists2.png\" width=\"515\" height=\"209\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists2.png 515w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists2-300x121.png 300w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>2. You need to create an empty list named <b>Project Overview<\/b>. This list will be used to receive data from the above mentioned two lists. The column name and type in this list should be the same with the other two lists<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5730\" alt=\"integrate-multiple-sharepoint-lists3\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists3.png\" width=\"792\" height=\"129\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists3.png 792w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists3-300x48.png 300w\" sizes=\"(max-width: 792px) 100vw, 792px\" \/><\/p>\n<p>3. In the <b>Project Overview<\/b> list, click the <b>List<\/b> tab on the Ribbon and then click <b>List Settings<\/b><br \/>\n4. In the List Settings page, click the <b>Data Connector Settings<\/b> under the General Settings section<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5731\" alt=\"integrate-multiple-sharepoint-lists4\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists4.png\" width=\"361\" height=\"266\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists4.png 361w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists4-300x221.png 300w\" sizes=\"(max-width: 361px) 100vw, 361px\" \/><\/p>\n<p>5. We will need to create two jobs on the Data Connector Job Center page<\/p>\n<p>One job is used to connect data from the <b>Project Info<\/b> list and the other is used to connect data from the <b>Project Cost<\/b> list.<\/p>\n<p>6. Click <b>Create Job<\/b> on the Data Connector Job Center page<br \/>\n7. In the <b>General Settings<\/b> tab:<\/p>\n<ul>\n<li><span style=\"line-height: 1.5;\">Type the name that you want for the job in the Job Name section<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5732\" alt=\"integrate-multiple-sharepoint-lists5\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists5.png\" width=\"452\" height=\"49\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists5.png 452w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists5-300x32.png 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/span><\/li>\n<li><span style=\"line-height: 1.5;\">In the Direction section, select<\/span><b style=\"line-height: 1.5;\"> From external data to list<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5733\" alt=\"integrate-multiple-sharepoint-lists6\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists6.png\" width=\"454\" height=\"55\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists6.png 454w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists6-300x36.png 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><\/b><span style=\"line-height: 1.5;\"><br \/>\n<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">In the List section, the <\/span><b style=\"line-height: 1.5;\">Project Overview<\/b><span style=\"line-height: 1.5;\"> list has been selected by default<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5734\" alt=\"integrate-multiple-sharepoint-lists7\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists7.png\" width=\"545\" height=\"71\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists7.png 545w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists7-300x39.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/span><\/li>\n<li><span style=\"line-height: 1.5;\">Since the Project Info list is in the same SharePoint site collection, select <\/span><b style=\"line-height: 1.5;\">SharePoint 2010<\/b><span style=\"line-height: 1.5;\"> as the External Data Type<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">Enter the URL of the <\/span><b style=\"line-height: 1.5;\">Project Info<\/b><span style=\"line-height: 1.5;\"> list<\/span><\/li>\n<li><span style=\"line-height: 1.5;\">Enter the name and password of the user who has Contribute permission to the Project Info list. And then click connect<\/span><b style=\"line-height: 1.5;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-5735 aligncenter\" alt=\"integrate-multiple-sharepoint-lists8\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists8.png\" width=\"403\" height=\"171\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists8.png 403w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists8-300x127.png 300w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/b><\/li>\n<li><span style=\"line-height: 1.5;\">By default, the columns with the same name and type will be automatically mapped. And you can specify the <\/span><b style=\"line-height: 1.5;\">Project Number<\/b><span style=\"line-height: 1.5;\"> as the key column to uniquely identify items<\/span><span style=\"line-height: 1.5;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-5736 aligncenter\" alt=\"integrate-multiple-sharepoint-lists9\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists9.png\" width=\"423\" height=\"242\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists9.png 423w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists9-300x171.png 300w\" sizes=\"(max-width: 423px) 100vw, 423px\" \/><\/span><\/li>\n<li><span style=\"line-height: 1.5;\">Then specify the <\/span><b style=\"line-height: 1.5;\">Run Options<img decoding=\"async\" loading=\"lazy\" class=\"wp-image-5722 aligncenter\" alt=\"integrate-multiple-sharepoint-lists10\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists10.png\" width=\"380\" height=\"233\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists10.png 380w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists10-300x183.png 300w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists10-194x120.png 194w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/b><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>8. In the <b>Schedule<\/b> Tab,<\/p>\n<p>In order to ensure the job updates automatically, you should enable background update, and set the <b>Schedule<\/b> as every day at 9:00 AM.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5723\" alt=\"integrate-multiple-sharepoint-lists11\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists11.png\" width=\"535\" height=\"294\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists11.png 535w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists11-300x164.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/p>\n<p>9. In the <b>Notification<\/b> tab, select Send Notification email when an error occurs and enable logging to monitor the running process of the job<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5724\" alt=\"integrate-multiple-sharepoint-lists12\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists12.png\" width=\"433\" height=\"187\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists12.png 433w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists12-300x129.png 300w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/p>\n<p>10. Click Save on the top or bottom of the page, and you will return to the Data Connector Job Center page<br \/>\n11. Create another job named <b>Project Cost to Overview<\/b> in the same way<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5725\" alt=\"integrate-multiple-sharepoint-lists13\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists13.png\" width=\"437\" height=\"381\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists13.png 437w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists13-300x261.png 300w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/p>\n<p>12. Then, run the two jobs in the Data Connector Job Center page by clicking <b>Run<\/b><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5726\" alt=\"integrate-multiple-sharepoint-lists14\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists14.png\" width=\"842\" height=\"308\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists14.png 842w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists14-300x109.png 300w\" sizes=\"(max-width: 842px) 100vw, 842px\" \/><\/p>\n<p>13. After running the two jobs, enter the Project Overview list, and you will find the list that you want. The two lists have been successfully integrated into one<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-5728\" alt=\"integrate-multiple-sharepoint-lists16\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists16.png\" width=\"900\" height=\"316\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists16.png 900w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2013\/07\/integrate-multiple-sharepoint-lists16-300x105.png 300w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Having trouble integrating data from multiple SharePoint lists? SharePoint Data Connector, by BoostSolutions, will help you complete your tasks quickly and efficiently. The following scenario will help you to understand how Data Connector, as a lightweight out-of-the-box data transfer tool, combines data from multiple SharePoint lists. Assume that you have the following business requirements when [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,461,460,480],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/5705"}],"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\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=5705"}],"version-history":[{"count":25,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/5705\/revisions"}],"predecessor-version":[{"id":5744,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/5705\/revisions\/5744"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=5705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=5705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=5705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}