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

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

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