Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Sublist within List
Power Apps - Power Apps Experimental Features
Suggested answer

Sublist within List

(0) ShareShare
ReportReport
Posted on by MW-25060705-0
I am creating an enquirer tracking system - a lot more basic than a big CRM. At the moment I have 2 Sharepoint Lists: one for enquirer tracking, the other as a communication log with each enquirer. I want to be able to click on the enquirer name and within the profile be able to click on something that enables me to see the communication log. Is there a way to link these 2 List in this way with Power Apps?
Screenshot 2025-0...
Screenshot 2025-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 2,540 on at
    Sublist within List
     
    Yes, you can absolutely link two SharePoint lists in Power Apps to mimic a lightweight CRM system.
     
    This is a common use case — having a "parent-child" relationship between records. 
     
    List 1: contains enquirer details.
     
    List 2: stores communication entries (email, call, etc.) with a lookup to an enquirer.
     
     
    Ensure your List 2 list includes a Lookup column to the List 1 list.
     
    Go to the List 2 list
     
    Add a column → choose "Lookup"
     
    Connect it to the List 1 list
     
    Set it to lookup the enquirer name or ID
     
    Power Fx
     
    Filter(
        List 2,
        Column.Id = ThisItem.ID
    )
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    ✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 770 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 494

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 399

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans