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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Records cannot be seen...
Power Pages
Answered

Records cannot be seen without contact table permission

(0) ShareShare
ReportReport
Posted on by 252

Dear all, 

 

Could someone clarify what I'm doing wrong? I have a custom table where it can be both associated with an account and a contact. A user can be associated with multiple accounts, meaning I made a many-to-many relationship with the contacts table and the accounts table. That's settled. The contact is a contact. 

 

The thing is, when we did the UAT and I associated my test account with the account of the participant, I didn't see his entries in the table entity. Even if we were in the same company, I still couldn't see his records. 

 

I have both account and contact table permissions. I tried disabling the contact permission suspecting that both permissions enabled gave an AND functionality to the permissions. However, disabling results in me not seeing any records. 

 

I tried deleting the records' association with the contact, leaving only its association with the accounts. I still can't see the records. 

 

Can anyone help me? 

Is it the many-to-many relationship? When I look at the Associated Accounts of my contacts, they are all associated with the companies listed. Yet I still can't see the records from the same account. 

 

HELP @Fubar 

Categories:
I have the same question (0)
  • apangeles Profile Picture
    252 on at

    I suspect that it's because the mspp_webrole does not have an association with the Accounts table. I am currently using the enhanced version of Power Pages

  • Verified answer
    Fubar Profile Picture
    8,491 Super User 2026 Season 1 on at

    The Table Permission with scope = Account only works where the Contact record's out of the box Parent Lookup  field (parent account) is populated with the respective account record (those contacts appear in the out of the box Contacts subgrid on the Account).  If not using that lookup field (e.g. as you've created a new many to many), you need to create a new Table Permission for the new relationship between the contact and account tables.

  • Verified answer
    apangeles Profile Picture
    252 on at

    @Fubar 

     

    Thank you very much, Fubar. That clarification really helped. I now placed the custom table table permission under the account->contact many-to-many relationship as a child permission. It has now worked. 

     

    A gem in the community. Thank you Fubar!

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

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 Pages

#1
Valantis Profile Picture

Valantis 58

#2
11manish Profile Picture

11manish 55

#3
Vish WR Profile Picture

Vish WR 29

Last 30 days Overall leaderboard