web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 285vF4i5kaeh8790NOEEmZ
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.

 

 

I have the same question (0)
  • 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

  • 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 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 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 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard

Featured topics

Loading complete