Portals Child table relationships

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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,

Categories:

Power Apps portals

I have the same question (0)

All responses (1)

Answers (0)

H V 1,510 on at

Like
a
(1)

Report
Copy link

Link copied!
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
Group Function
- Access Type = Parent
- Select Relationship for Group & Group Functions
Group Volunteer
- Access Type = Parent
- Select Relationship for Group & Group Volunteer
Site Group Responsible
- Access Type = Parent
- Select Relationship for Group & Site Group Responsible
Group Member
- Access Type = Parent
- Select Relationship for Group & Group Member
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!

Was this reply helpful? Yes No