Table Permissions in PowerApps Portal. (PART 1)

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.

Now, let’s see how to create 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.

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.