I have two custom lists on the SharePoint website and I would like to create a list which combines/joins the two lists. Is this possible and if so what are the best methods or third party tools for achieving this?

Regards, Sharmila

  • Are you actually trying to combine the lists? Or just trying to show them as joined in a view somewhere?
    – Kit Menke
    Apr 18, 2012 at 13:45
  • I need to join lists and i want to access the resulting data in a custom webpart
    – sharmila
    Apr 19, 2012 at 5:35

2 Answers 2

  1. You can export the lists in Excel sheets. Combine them and create another list using the combined excel sheet. This way will only allow you to combine data upto that particular point of time. i.e, its not dynamic.

  2. You can combine lists using a Data view web part creating a new linked resource. Refer this blog for details. And afterwards you can export this combined Data View web part using javascript. Find all the details here for exporting. Exporting from a Data View web part would be dynamic and real time.

Good Luck .

  • Thank you:) I have the linked datasource and now I need to access this datasource in a custom webpart
    – sharmila
    Apr 19, 2012 at 5:36

You can use SPSiteDataQuery to combine or join multiple lists created out of same list template.

It is beautifully explained in the following link: http://www.codeproject.com/Tips/401818/SharePoint-SPSiteDataQuery-with-Example


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.