News and Announcements icon

Power Platform CommunityForums Power Pages - Security Child table permission...

Power Pages - Security

Suggested answer

Child table permissions & web roles

(0) Share

Report

Report

Posted on by RV-20030916-0

2

Hi all,

I have created a Power Page where calls are done to the web api. I have the following setup:

Contact is related to account
Account has a company

Product has a company

Now, i have a table permission for the 'Customer' web role for both the account and the company, and both are enabled in the api using site settings and both are returning the expected data.

Then, I wanted to include products on the portal. However, I cant get it to work as expected. I added a child permission to the company permission for the products table. I selected the table, and the relationship came popping up. When trying it in the web api, I got the following error:

{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x80040216","innererror":{"code":"0x80040216","message":"entityRelationshipRole for given navigation property not found"}}}

The relationship from products to company is many to one:

How can I best fix this (without just filtering on the companyid, since products from other companies should not be visible)

Thank you in advance!

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Fubar 7,821 Super User 2025 Season 1 on at

Like (0)

Report

Child table permissions & web roles

Check the fields that you have enabled for the Portals API in the Site Settings. If you have listed individual fields, you will need to add one for the relationship name - you can check if this is the issue by temporarily using an asterisk instead of the field list (but note for production it is strongly recommended you do not use the asterisk).
RV-20030916-0 2 on at

Like (0)

Report

Child table permissions & web roles

So, I just found out that putting it into a standard list works, but via the web api it does not.

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

Leaderboard

#1

WarrenBelz 146,524 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,898 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans