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.
@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)
Look up list2- (capability)
Look up list 3-(domain)
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.
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
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."
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.