How to Link Two Lists and Create a Combined View in SharePoint 2013

SharePoint is a web-based collaborative platform that integrates with Microsoft office. It speedup the business processes along with ensuring the security. In following is an illustration of how it simplifies day to day business.

In the following, I describe how to show content from two lists in the same view.

Lists names are “SharePoint 1” and “SharePoint 2”.
SharePoint 1 list is a custom list with Title column:
sharePoint-1

SharePoint 2 list has same columns as SharePoint 1 List:
sharePoint-2

Open the SharePoint Designer 2013 and Open the site where you have created the lists.
sharePoint-3

Click on “Data Sources” in left and then click on “Linked Data Source”
sharePoint-4

Then click on Configure Linked Source…
sharePoint-5

Select our lists in the Wizard and click next.
sharePoint-6

Chose the “Merge” option, so we can sort and filter the content as one long list:
sharePoint-7

Our data source is created.
sharePoint-8

After that create a new “Web Part Page”. I already created and named demo.aspx.
sharePoint-9

Edit the page in designer
sharePoint-10

Then click on “Insert” tab in the ribbon, and selected Data View button. You will find “Linked Data Source” in dropdown list under “Linked Source”.
sharePoint-11

Click “Add/Remove Columns” on top:
sharePoint-12

You can add or remove columns here. Removed “Modified” column:
sharePoint-13

Search the “row view” in code for Data View web part. “Row view” contains XSLT that is used to display items:
sharePoint-14

changed:

to:
Added “disable-output-escaping “to above. Setting “disable-output-escaping” to “yes” make the column to render as HTML and not as text.

Then click on “Sort & Group” in the ribbon. It is for sorting on a columns or columns. I sorted the view by Title column:
sharePoint-15

Then click on “Web Part” in the ribbon and select “To Site Gallery”:
sharePoint-16

Data View with two lists as data source is saved as web part on the site now. Now open the page. The web part looks like this:
sharePoint-17

Related Posts

Comments (2)

How would you have the Title column link back to the edit form in a popup?

When i click “Data view” it display “Empty data view” but i created a data source connection
can you give the reply where is the problem i can’t understand the situation

Leave a comment