Forum Discussion
Merging SharePoint Lists
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)
- 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?
What columns do you want to bring from the two different lists?
ArefHalmstrand Thanks again for your great support. I would like to have something like below. Flow to create new list combining both list based in Unique ID. See the capture
