Unanswered

Access subform parent child relationship only works for Power Platform Admin Role?

(0) Share

Report

Posted on by pstdennis

Does anyone know the setting in the admin center of Power Platform security roles that would cause the parent-child relationship of an Access subform to not work for a user security role? It works fine for the admin role but not for my users role. The Access form turns into a parameter query for them even though they can see the values of the GUID field used to link the form to the subform. Makes no sense to me.

Categories:

Governance & administering

I have the same question (0)

All responses (2)

Answers (0)

pstdennis 2 on at

Like (0)

Report
Copy link

Link copied!

I've set all of the permissions to the tables to organization level full control but the access subform still does not populate. It asks for the child field as if it were a parameter query. For the admin role, however, it works fine. There is some setting in the user role that is causing this error, but I can't track it down. The only solution I can find so far is to make the users admins. Not ideal, obviously.

Was this reply helpful? Yes No
velegandla 204 Moderator on at

Like (0)

Report
Copy link

Link copied!

@pstdennis

Didn't get your question completely. Maybe a screenshot would be helpful?

What roles have users got?

Only system admins can grant access to others.

====================================================

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

https://www.linkedin.com/in/devendravelegandla/

Was this reply helpful? Yes No