Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
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 - Building Power Apps / Parent/Child relationship
Power Apps - Building 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!

  • tcantrell75 Profile Picture
    tcantrell75 20 on at
    Re: Parent/Child relationship

    @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

  • DavidZoon Profile Picture
    DavidZoon 738 Most Valuable Professional on at
    Re: Parent/Child relationship

    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.

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

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans