Skip to main content
Community site session details

Community site session details

Session Id : LH+Z3hmk4oVh52U0vW9Dry
Power Apps - Microsoft Dataverse
Unanswered

Suggestions for defining permission to Dataverse entity

Like (0) ShareShare
ReportReport
Posted on 29 Mar 2022 06:39:27 by 19

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

 

  1. Finance Department
    1. Finance sub Department 1
    2. Finance Sub Department 2
  2. Accounts Department
    1. Accounts sub Department 1
    2. 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.

 

 

  • Prakash4691 Profile Picture
    1,332 on 29 Mar 2022 at 14:23:23
    Re: Suggestions for defining permission to Dataverse entity

    @BapatSanket ,

    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.

  • BapatSanket Profile Picture
    19 on 29 Mar 2022 at 09:33:03
    Re: Suggestions for defining permission to Dataverse entity

    No there is no specific mapping defined yet

  • Prakash4691 Profile Picture
    1,332 on 29 Mar 2022 at 08:28:47
    Re: Suggestions for defining permission to Dataverse entity

    @BapatSanket ,

    Is there any custom user lookup field available to identity the record belongs to particular user or is it based on owner field?

  • BapatSanket Profile Picture
    19 on 29 Mar 2022 at 08:08:44
    Re: Suggestions for defining permission to Dataverse entity

    @Prakash4691 

    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

  • Prakash4691 Profile Picture
    1,332 on 29 Mar 2022 at 07:54:24
    Re: Suggestions for defining permission to Dataverse entity

    @BapatSanket ,

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics