Hi Team, We have a use case where we are maintaining list of departments and sub departments in the excel file, we will be importing / dumping these details in to Dataverse table "Departments Information". Following is the example
- Finance Department
- Finance sub Department 1
- Finance Sub Department 2
- Accounts Department
- Accounts sub Department 1
- Accounts sub Department 2
We have users from multiple departments who will be accessing the Departments information table. Here our requirement is users should only be able to see Department and its sub departments where user belongs.
For example - Accounts department user should only see / modify Account Department and corresponding Sub departments.
Could you please help me defining the permissions for this case where users belonging to specific department could only see modify data of their own department.