Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages - Security / Table Permission that ...
Power Pages - Security
Suggested answer

Table Permission that doesn't rely on contact or account access

(1) ShareShare
ReportReport
Posted on by CU26031408-0

I have a portal where users enter reports related to their current parent account. These reports are also associated with a county (stored in an independent table). The client now wants to introduce an elevated permission level that allows users to view all reports within their county (users are also assigned a county), instead of being limited to reports related only to their parent account.

Does anyone know how this can be implemented? It seems like we're currently limited to viewing records directly related to the contact or the contact's parent account.

Categories:
General
  • Suggested answer
    surya narayanan Profile Picture
    surya narayanan 53 on at
    Table Permission that doesn't rely on contact or account access
    Hi, 
     
    Power Pages permissions by default are constrained to what can be represented using OOB (Out of the Box) Web Roles, Table Permissions, and Relationships. These mostly rely on:
     
    Record ownership (Created By)
    Direct relationships to the logged-in contact
    Relationships via contact’s parent customer (i.e., account)
     
    Solution: Use a Custom N:N Relationship and Table Permissions
    Each user/contact is assigned a county
    Each report is linked to a county
     
    You want to allow users to see all reports in their assigned county
     
    Steps:
    1. Ensure You Have the Right Relationships
    Contact (User) → Lookup → County
    Report → Lookup → County
    2. Create a Table Permission for Report
    Type: Global
    Table: Report
    Scope: Parent
    Related table: County
    Relationship: report > county and contact > county
    3. Assign the Table Permission to a Web Role
    Create a new Web Role for elevated users (e.g., County Report Viewer) and assign the table permission to it.
     
  • Suggested answer
    Fubar Profile Picture
    Fubar 8,027 Super User 2025 Season 2 on at
    Table Permission that doesn't rely on contact or account access
    You can use a Table Permission with scope = Parent (in the designer these are called child permissions, but in the Power Pages Management App you will see the scope is Parent). As an example, if you had an Invoice and Invoice Line Items, you would typically use a scope = Parent on the relationship between the Invoice and the Line Item (so the Line Item doesn't have an account or contact associated with it, but has a lookup to the parent invoice record).
     
     
     
     

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

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans