web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Parent/Child relationship
Power Apps
Unanswered

Parent/Child relationship

(0) ShareShare
ReportReport
Posted on by tcantrell75 20

I have 2 data sources, 1 is the parent form (PCard)(screen1) the 2nd is the child form (CodingInfo) (screen2).

Screen1 I have my pcard form, and in that form I have a gallery connected to my child data source (CodingInfo).

 

First question.  When the parent form is new, I want my gallery to be a blank slate, it will only populate when I add child items.  How can I do this?

when the form is edit or view mode, I'd like my form to display the items entered for that id for the parent and child.  (I hope that makes sense)

Second question.  How do I relate the parent ID (OOB sharepoint ID) to the child ID (OOB sharepoint ID)?

 

Please let me know if I can provide any other information.

 

Thanks!

Categories:
Building Power Apps
I have the same question (0)
  • DavidZoon Profile Picture
    DavidZoon 738 Most Valuable Professional on at

    Hello,

     

    Here is two options for the child gallery when Parent form is in "New" Mode :

     

    Set the Gallery.Visibility to Form_PCard.Mode <> FormMode.New

     

    Or

     

    If you have a lookup column in your child list, filter on his ID = Thisitem.ID

    In NewMode, Calling ThisItem in a form will result in a blank value, your gallery will display only records if the ID in the lookup column is the same as your parent item ID

     

    To relate child record to parent one, just add a lookup column in the child list

     

    Sharepoint offers very limited options for data relationships, if you need better relattionnal database, consider switching to Dataverse or Dataverse for teams

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

  • tcantrell75 Profile Picture
    tcantrell75 20 on at

    @DavidZoon 

    Thank you for the reply.  I'm not following what you are saying here

    If you have a lookup column in your child list, filter on his ID = Thisitem.ID

    In NewMode, Calling ThisItem in a form will result in a blank value, your gallery will display only records if the ID in the lookup column is the same as your parent item ID

     

    I have now created a PID lookup column in the child list.

     

    Thanks

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

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 839

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 412

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans