Hello,
I'm working on a Model-Driven app in PowerApps, where I'm managing roles and permissions through custom tables. Here's a brief overview of my setup:
- Role Table: Contains role names (e.g., Manager, Director).
- Permission Table: Lists permissions (e.g., Proposal).
- PermissionByRole Table: Associates roles with specific permissions and actions (e.g., Manager has Read permission, Director has CRUD permission on Proposal).
My challenge is managing the dynamic visibility of forms, views, and controls based on these roles and permissions. For instance:
- Currently, the Manager role has only the Read permission on the Proposal, while the Director role has CRUD permissions.
- If I later add more permissions to the Manager role (e.g., Update), I want the corresponding forms and controls to automatically reflect this change without needing to create separate views and forms.
I'm trying to avoid hardcoding views and forms for each role and permission combination, as I anticipate adding more roles and permissions in the future. Could you guide me on the best approach or PowerApps feature to handle this scenario dynamically?
Thank you!