Merging SharePoint Lists

[2BTV1630]

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

[#2]

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?

[#3]

@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? 

[#4]

@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)

[#5]

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

[#6]

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?

[#7]

@2BTV1630 

What columns do you want to bring from the two different lists?

[#8]

@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

[#9]

Anytime! 🙂

Just for my understanding, why does the data need to be stored in two separate lists from the beginning? What is the reason that you do not have a list with all the columns, but with three different views? Allowing users to only see alternative A, B or both?

[#10]

@ArefHalmstrand They are for separate functions and has separate columns other than those IDs. One is main and others are subs. The main thing is I need to have grouped based on unique IDs as it will be easier for uses to identify the number of subs associated with the man.

[#11]

Ok! I will see what is quickest to do, either we book a MS Teams meeting and I show you how to set up the Power Automate solution. Or, I create a video and share it with you when it is done.