cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MathiasGijsels
Frequent Visitor

Private database for user

Hi all,

 

I need to make a Powerapp in Teams which has a private table for a user.

More specific: the app contains a table, the user can update the table with a form but the user can only see his entries, not the entries of other users.

 

Is this possible?

Thanks!

2 ACCEPTED SOLUTIONS

Accepted Solutions
ChrisPiasecki
Super User
Super User

Hi @MathiasGijsels,

 

If the data source for the Table is Dataverse for Teams, unfortunately the security configuration does not allow you to restrict data between Team Members. Team Members have access to all data. Only Guests added to the Team from outside the Tenant will be restricted to see data they create.

More information about Dataverse for Teams security here

 

To achieve your scenario, you would need to use a full Dataverse database, which would require those using it to have a Power Apps per user or per app plan. Or you would need to look at using a SharePoint List and setup item level permissions so that users can only see their own items.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

dpoggemann
Memorable Member
Memorable Member

Hi @MathiasGijsels ,

 

This is a standard capability within the Dataverse outside of Teams where you can assign security roles that will allow users to view only their records.  

 

Internal Team Members are given "Teams Member" access which provides access to all records in the Dataverse for teams (https://docs.microsoft.com/en-us/power-platform/admin/about-teams-environment#user-access-to-dataver...).

 

You would need to upgrade to standard Dataverse licensing to control the way you are looking here.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,

 

Drew

View solution in original post

2 REPLIES 2
ChrisPiasecki
Super User
Super User

Hi @MathiasGijsels,

 

If the data source for the Table is Dataverse for Teams, unfortunately the security configuration does not allow you to restrict data between Team Members. Team Members have access to all data. Only Guests added to the Team from outside the Tenant will be restricted to see data they create.

More information about Dataverse for Teams security here

 

To achieve your scenario, you would need to use a full Dataverse database, which would require those using it to have a Power Apps per user or per app plan. Or you would need to look at using a SharePoint List and setup item level permissions so that users can only see their own items.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

dpoggemann
Memorable Member
Memorable Member

Hi @MathiasGijsels ,

 

This is a standard capability within the Dataverse outside of Teams where you can assign security roles that will allow users to view only their records.  

 

Internal Team Members are given "Teams Member" access which provides access to all records in the Dataverse for teams (https://docs.microsoft.com/en-us/power-platform/admin/about-teams-environment#user-access-to-dataver...).

 

You would need to upgrade to standard Dataverse licensing to control the way you are looking here.

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.

 

Thanks,

 

Drew

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,280)