Forum Discussion
Merging SharePoint Lists
I am trying to merge 2 SharePoint lists together. May I please ask for an idea to combine?
- 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?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?
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)
