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

All responses (8)

Answers (0)

Lucas Luong 26 on at

Like (0)

Report

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

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

Thanks a lot for your help.
OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

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

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.
Lucas Luong 26 on at

Like (0)

Report

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

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?
Lucas Luong 26 on at

Like (0)

Report

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

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.
Lucas Luong 26 on at

Like (0)

Report

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

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.
EricRegnier 8,714 Most Valuable Professional on at

Like (1)

Report

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

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
OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

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

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?
Lucas Luong 26 on at

Like (0)

Report

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

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