Forum Discussion
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,
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
2 Replies
- mahoneypat
Microsoft Employee
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
- Greg_Deckler
Community Champion
vjeshwar An Append query?
