Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Suggestions for defining permission to Dataverse entity

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    Re: Suggestions for defining permission to Dataverse entity

    No there is no specific mapping defined yet

  • Prakash4691 Profile Picture
    1,332 on at
    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 at
    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 at
    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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics