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
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.
Depends on that I can able to give some suggestions. Without that how are you planning to identify the record belongs to user from some department.
No there is no specific mapping defined yet
Is there any custom user lookup field available to identity the record belongs to particular user or is it based on owner field?
Thank you for your response. We already have existing data maintained in the excel sheet which we will import / add to dataverse table "Departments Information". then users will be allowed to view / modify / add data for the department where they belong to via canvas app
Is it only importing data from excel for "Departments Information" table or will those record be manually created in dataverse using any apps like model driven app/canvas app?
Regards,
Prakash
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1