This blog will help you understand how we can manage record-level security in PowerApps Portal.
We will understand what is table permission and the different Access Types available in table permission.
What is Table Permissions?
- Table permissions are used to manage record-level security in PowerApps Portal.
- Using table permission we define whether the user can create, read, update or append records of a particular table.
- Below are the privileges available in table permission.

- Table permissions have below access types:
- Global
- Account
- Contact
- Parent
- Self
Now, let’s see how to create table permission
- Go to PowerApps Portal Studio.
- Select your portal and click on Edit.
- Go to settings –> Table permissions

- Click on “+New Permission” to create new table permission.

Table permission with Global scope
- If we create table permission with a global scope then the user can see all the records of that particular table in the PowerApps Portal.
- For example, let say we have a project table and we want to display all the projects in PowerApps Portal.
- Enter below details
- Name: Enter name for table permission record.
- Table: select the table for which you are creating table permission.
- Access Type: select Global access from the drop-down.

- Select Privileges
- Click on “+Add roles” and select the role.


- Click on Save.
Project records in Dataverse

Go to Portal, you will see all the project records.

Table permission with Contact scope
- If we create table permission with a contact scope then the user can only see records that are related to that user’s contact record via a defined relationship.
- Records directly linked to the current user
- Example 1
- let say we have a project table, and in the project table we have a client column which is a lookup to contact table and we want to display only those project which is related to the user.
- Enter below details
- Name: Enter name for table permission record.
- Table: select the table for which you are creating table permission.
- Access Type: select Contact access from the drop-down.

- Click on the drop-down and select the relationship between the project and the contact table.
- Select Privileges
- Click on “+Add roles” and select the role.


- Click on Save.
Project records in Dataverse

Project records in PowerApps Portal

Example 2
Display cases that are related to signed-in users.
The case table has a customer column and we want to display only those cases that are related to the signed-in user in the PowerApps portal.
Create Table permission with below details.



Case records in Dataverse

Case records in PowerApps Portal.

In the next blog, we will see table permission with account,parent and self scope.
I hope you find this helpful!! If you have any queries, you can share those in the comments section.