Unanswered

Sub-grid (of secondary) is not showing on portal.

(0) Share

Report

Posted on by Lucas Luong

Hello team,

I have the requirements and configured many ways (sub-grid in metadata of the web form steps, parent-child entity permission, standalone permission for each entity) still - I am not able to see the second entity in sub-grid (primary entity is configured by web forms step).
1/ Primary entity: account (OOB)

2/ Secondary entity: family (custom).

Entity relationship: Account 1:N Family.

Req: record of family will be shown in the Account entity sub grid on PowerApps portals.

Web form steps configuration:

On portals:

Please suggest if you have any idea/suggestion about this.

Thanks.
@EricRegnier

Categories:

Power Apps portals

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Lucas Luong 26 on at

Like
a
(0)

Report
Copy link

Link copied!

@OOlashyn @ragavanrajan
Please help me on this. Thanks.

Was this reply helpful? Yes No
OOlashyn 3,498 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @lucasluong ,

As far as I understand on this step user should see a sub grid of records right? The error clearly shows that there is some issue with table permissions. Can you share with us your permissions configuration for family and account tables?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @lucasluong,

As @OOlashyn mentoined, have a look at your entity/table permission setup. Here's the MS doc page for more details: https://docs.microsoft.com/powerapps/maker/portals/configure/entity-permissions-studio

Cheers

Was this reply helpful? Yes No
Lucas Luong 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Eric and OOlashyn,

I forgot this important part, please take a look in the screenshot below:
The parent permission for Account entity:

The child entity permission for Family:

Configuration in web form metadata:

Thank you.

Was this reply helpful? Yes No
Lucas Luong 26 on at

Like
a
(0)

Report
Copy link

Link copied!

I also considered the conflict of the OOB entity permissions of Account entity (from Customer Self Service portal) and deactivate all the entity permissions that relates to the Account entity on it. However, before and after deactivating the results are the same.

Was this reply helpful? Yes No
Lucas Luong 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Update 1:

If I change the scope of the account entity from Account -> Global - all the child record can be view as usual.
Not sure what is the actual issue here 😞

Could someone please enlighten me?

Was this reply helpful? Yes No
OOlashyn 3,498 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Does the account you are trying to access is parent account of the user's account? If switching to Global permission solves the issue that means that your current permission is not applicable to the account you are trying to access. Please validate that contact is related to the account through the relationship that you defined.

Was this reply helpful? Yes No
Lucas Luong 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks man. I changed to another custom entity to go forward on this.

Thanks a lot for your help.

Was this reply helpful? Yes No