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

Community site session details

Session Id : envvS8Et3AfM7YqTWklnLJ
Power Pages - Power Apps Portals
Unanswered

Portals Child table relationships

Like (0) ShareShare
ReportReport
Posted on 14 Oct 2021 07:20:31 by

Hi community,

 

I currently face following problem. We have this situation where a contact record can belong to one or more 'Groups'. This groups is a custom entity in CDS or Dataverse. At this point no problems as we use the table permissions and the contact relationship to show only those groups for the contact.


Next is that under this group we have some 5 child tables. For each of the child tables we provide seperate Web Pages. Issue now is that these webpages have lists that are filtered on a static way, i.e. we've created seperate views in CDS filtered on a specific group. Problem now is that they have > 700 groups so this would mean 700 views to be created, 700 Web Pages,...
Is there a way via standard Portals functionality to have the 5 child tables automatically filtered on the group? See also image in attachment.

 

Thanks for your help!

 

Kind regards,

I have the same question (0)
  • H V Profile Picture
    1,510 on 14 Oct 2021 at 09:08:41
    Re: Portals Child table relationships

    Hi @Anonymous 

     

    Yes, you have to create Child Table Permission under your Group Table Permission. While creating Child Table Permission, you have to select as Access Type "Parent" and also select relationship between "Group" and your child Table.

     

    Table Permission

    • Group:
      - Access Type = Contact
    • From this Group Table Permission, you have to create 5 Child Table Permission
    1. Group Function
      - Access Type = Parent
      - Select Relationship for Group & Group Functions
    2. Group Volunteer
      - Access Type = Parent
      - Select Relationship for Group & Group Volunteer
    3. Site Group Responsible
      - Access Type = Parent
      - Select Relationship for Group & Site Group Responsible
    4. Group Member
      - Access Type = Parent
      - Select Relationship for Group & Group Member
    5. Group Activities
      - Access Type = Parent
      - Select Relationship for Group & Group Activities

     

    Please refer this blog: https://vblogs.in/table-permissions-in-powerapps-portal-part-2/

    In above bl0g, you need to refer "Table permission with Parent scope" section.

     

    --------------------------
    If you like this post, give a Thumbs up. Where it solved your query, Mark as a Solution so it can help other people!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#2
Lucas001 Profile Picture

Lucas001 48 Super User 2025 Season 2

#3
KevinGador Profile Picture

KevinGador 44 Super User 2025 Season 2