Intro to Power Apps Portals Web Roles and Table Permissions

In this post, we will look at Power Apps Portals Web Roles and Table Permissions how they are used. We will go through an example of displaying a list of Dataverse records.

First, let’s create a new portal called Company Jobs. The goal of the website is to display content to both internal authenticated and external non-authenticated users. The difference is that internal people will see some more information on the role, whereas external people will see slightly less information.

In https://make.powerapps.com, select Create->Blank Website->Create:

Enter the name and click Create:

Let’s now create a new table called Internal Company Announcements:

Publish the table, and let’s create a new record:

Now. let’s add this to our list to the portal. Go to the Power Apps Maker and edit the portal:

We see below:

Click to add a new list:

On the right, select the table and view to display:

Click Sync configuration:

Now as a user, click on the Sign In button:

We will sign in with a user using Azure AD:

Click Accept:

We are taken to the profile page:

Browse to the homepage. We see the message “You don’t have permission to view these records”:

We need to set permissions to this entity. In the designer, on the list component, click on Manage Table Permissions:

You will see below. Click on New permission:

Give the permission a name, and select the table. For the access type, we will select Global:

And for the privilege, we will select Read. Now click Save:

Click on Sync Configuration, and you will now see as an authenticated user the list data displayed:

In the Portal Management app, we can see the Table Permission was added:

Now, let’s create its own Web Role instead. We will delete the table permission we created, and create a new Web Role called Internal Users:

We will assign it to the Company Jobs website, and set it to be authenticated users only:

At this point, our user does not have access to the list table once again:

Now, let’s create a new Table Permission:

Enter like below and save. Note the web roles are unavailable until we save:

Our portal user still won’t see the entity list records.

Next, click on Add Existing Web Role:

Select the web role we created:

Now refresh the configuration, and you will see the record.

In summary, for any table data you want to display:

1. Create a web role for the website. Select Anonymous or Authenticated
2. Create a table permission, select the table and its permissions
3. Assign the web role to the table permission

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.com | LinkedIn | Twitter | YouTube