Forum Discussion
Merging SharePoint Lists
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?
ArefHalmstrand 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?
- 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 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.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)- 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?
