How to Add a List in Power Pages [CRUD Operation]

While working on a Power Pages site, one of my colleagues asked me, “How can I display Dataverse data in Power Pages?”

I explained that you can easily display data using a list option. But here’s the best part: a list doesn’t just show data. It also allows users to create, edit, and delete records if they have the necessary permissions.

NOTE:

To add a list in Power Pages, first you need to create a Dataverse table and then create a view within that table.

So in this post, I will show you:

• Create a Dataverse table view
• How to add a list in Power Pages
• Enable full CRUD operations (Create, Read, Update, Delete)

Create a View in Power Pages

For this example, I created a custom Dataverse table named Support Tickets. It includes the following columns:

Column Name	Data Type
Ticket Title	Single line of text
Issue Description	Multiline text
Status	Choice
Created By	Lookup (Default)
Created On	Date and Time (Default)

Before adding a list to your Power Page, you must have a view in your Dataverse table. A view defines which columns (fields) are shown.

Here’s how you can create a view for your Support Tickets table:

1. In the left panel, click on “Data“, then open your “Support Tickets” table. Under the table menu, click “Views“, then click “+ New view“.

2. Give Your View a Name, for example, ‘Submitted Tickets’, then click ‘Create‘.

3. Add the fields you want to show in the list. For example:
   • Ticket Title
   • Status
   • Created By
   • Created On

4. If you want the view to show only specific records, you can add filters. Additionally, you can sort by a column, such as Date Submitted, in descending order to display the most recent tickets first. Then click Save and publish.

Add a list to Power Pages

Once your Dataverse table and view are ready, the next step is to bring them onto your site using a List component in Power Pages.

1. In the left pane, click on Pages, then either:
   • Choose an existing page, or
   • Click + Add page to create a new one.

2. Once you’re on the page, in the Components panel (on the right side), look for ‘List’ and then drag and drop it onto your page.

3. The List pop-up will appear. Follow these steps:
   • Choose a table: Select your Dataverse table (Support Tickets)
   • Select the data views: Select the view you created earlier (Submitted Tickets)
   • Name your list: Give your list a name (Support Tickets)
   • Then click Done.

4. Then select Preview.

5. Once you’ve added the list and clicked Preview, you might see a message like: “You do not have permissions to view these records.“

Don’t worry, this is expected the first time you view the page. Power Pages is built on Dataverse security, and by default, users need to be granted explicit permissions to view Dataverse data.

Set Table Permissions in Power Pages

The above message appears because the website user (you or others) has not yet set up table permissions. Even though the list is configured, the data won’t display unless permissions are properly assigned.

To allow users to view (or create/edit/delete) records, follow these steps:

1. In Power Pages Studio, go to Security -> Table permissions. Click + Add table permission.

2. Choose the table (Support Tickets), set the Access Type:
   • Read (to view)
   • Create (to submit)
   • Write (to edit)
   • Delete (to remove)
3. Under Web roles, select who gets access:
   • Administrators
   • Authenticated Users – for signed-in users
   • Anonymous Users – for public access
4. Click Save.

5. Once you’ve added table permissions with read access and click Preview, you’ll now be able to see the records in the list without the “you don’t have permission” error. But you can’t create, edit, or delete any records.

This is because your list in Power Pages won’t allow users to add, edit, or delete unless you explicitly enable those actions on the list.

Add a page with a form to View/Edit/Delete Records

Now follow the steps below:

1. In Power Pages Studio, go to the page where you added the list. Select the List component. Click the Edit List option. Under Action options, make sure to enable:
   • Create a new record
   • View details
   • Edit record
   • Delete record
2. Click Done, then Save and Sync Configuration.

2. Now, Preview Again, you’ll see the full experience in Preview:
   • ➕ A New button to add records
   • ✏️ Edit icons
   • 🗑️ Delete options (if enabled)

If someone asks you, How do I display Dataverse data in Power Pages?, now you know it’s not just about showing, it’s about giving users a way to interact with the data too.

In this tutorial, I covered:

• Created a view in Dataverse to define what data to show
• Added a list to the Power Pages site using that view
• Set up table permissions so users can see the data
• Enabled list actions so users can add, edit, and delete records

Hope you found this helpful.

Also, you may like some more tutorials:

• Add a Card Gallery in Power Pages
• Power Pages vs SharePoint
• Create A Form In Power Pages
• What is Microsoft Power Pages
• Add a Multistep Form in Power Pages