Merge two SharePoint list to create a master collection

(0) Share

Report

Posted on by Vidanaw

179

Hi All,

I have two SharePoint online lists as follows

List1- Name, Description, Color

List2- Capability, Domain, Name <----all these columns are look up columns link to different SPO lists

I want to merge List 1 and List 2 based on the Name columns. List1 and LIst 2 relationship is 1:M.

I want a master collection as follows

Name, Description, Color,Capability, Domain

Can soem one please help me on this.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Vidanaw
Can you please give some sample data from each table. Then can you please show an example of the expected result table with a few rows?

Was this reply helpful? Yes No
Vidanaw 179 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney please see below
List1- Data comm, description 1, red
Collab365, descriptions 2, yellow
List 2- Security, Cloud, Data comm
Backup, Cloud, Data comm
Design, UI, Collab365
Lookup list 1- (client name list)
Data comm
Collab365
ASK
Look up list2- (capability)
Design
Security
Backup
App
Look up list 3-(domain)
Cloud
UI
CISCo

Master collection-
Data comm, description 1, red ,Security, Cloud
Data comm, description 1, red ,Backup, Cloud
Collab365, descriptions 2, yellow,Design,UI

Both list contain more than 3000 items, so need to avoid delegation issue.

Thanks.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Vidanaw
Here's a simple example you can study on 'how to join tables with a 1:M relationship' within a collection. My example does not use lookup columns since they are not recommended for building Power Apps. You may wish to convert you SharePoint lists to simple text or number columns instead of lookups as well.

Example - Join Tables With A 1:M Relationship
https://matthewdevaney.com/powerapps-collections-cookbook/join-all-columns-from-another-collection/

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No