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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Suggestions for defini...
Power Apps
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.

 

 

I have the same question (0)
  • Prakash4691 Profile Picture
    1,332 on at

    @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 at

    @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

    @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

    No there is no specific mapping defined yet

  • Prakash4691 Profile Picture
    1,332 on at

    @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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard