Merging SharePoint Lists

Question

I am trying to merge 2 SharePoint lists together. May I please ask for an idea to combine?

rob_elliott · Answer

2BTV1630&nbsp;You can't have a view that combines 2 lists so you would need to create another list and using a flow in Power Automate populate that new list with the relevant data from the 2 columns using get items actions and probably filter queries depending on what items you want to bring back from each list.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

arefhalmstrand · Answer

Hello,In what way are you trying to merge them together ? Is it only the objects? What data would you like to transfer from one list, to the other?

2btv1630 · Answer

ArefHalmstrand&nbsp;I have 2 SharePoint lists running parallelly, both have multiple columns with common ID and few other columns. I am trying to create a view based on columns and group them based on the ID in the new view that I am trying to create. Do you think it's possible even using power automate?&nbsp;

arefhalmstrand · Answer

I would almost recommend looking into Power BI or SPFx to create a sustainable solution for combining data relations and group them by column.

2btv1630 · Answer

Thank you. Create a new list is a really good solution for me. Is there any guide for me to create flow to create new list?

Forum Discussion

Merging SharePoint Lists

10 Replies

Resources