Forum Discussion

vjeshwar's avatar
vjeshwar
New Member
5 years ago
Solved

How do I merge multiple Sharepoint list into one list

Is there a way I can merge multiple sharepoint list into one common list wherein the updates that I do gets reflected everywhere,
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can append individual queries to do that, but if you have multiple lists with the same structure on different sites, you can create a table that has 3 columns - the tentant url, site name, and list name, and pass those into a custom column in which you invoke the function share in this article/video.  You can then expand that column of "Table"s to get your combined data.

    Get Data From SharePoint Lists … But Fast – Hoosier BI

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can append individual queries to do that, but if you have multiple lists with the same structure on different sites, you can create a table that has 3 columns - the tentant url, site name, and list name, and pass those into a custom column in which you invoke the function share in this article/video.  You can then expand that column of "Table"s to get your combined data.

Get Data From SharePoint Lists … But Fast – Hoosier BI

 

Pat