Create Dataverse Expense Details Table And Build Simple PowerApp Using That Table

This article is divided into 2 sections

1. Creating Dataverse Table with Choice, Date, Lookup type columns and
2. Creating a simple PowerApp using that Dataverse table

Let’s jump into creating a simple use-case where we will create Expense Table & Expense Category Tables with the following Data types of Columns,

For Expense Table, we will create below mentioned columns,

• Expense Amount: Currency,
• Expense Description: Text,
• Expense Category: Lookup from Expense Category Table,
• Date of Expense: Date Only type,

For Expense Category, we will create the below mentioned column,

• Expense Categories: Choice

Above mentioned is the quick summary of Dataverse Tables. Let’s look into this step by step in detail,

Step 1

Navigate to https://make.powerapps.com

Step 2

From the left navigation click on Dataverse > Tables > Click on New Table as shown in Fig 1.1

Fig 1.1 - Dataverse New Table

Step 3

A panel will open when you click on New Table. Fill in the details like Table Name, also give a primary column name, this will be basically creating a primary column with the given name when this table will be created, give some description and select the Standard type of Table as shown in below Fig 1.2. Then click on Create table button

Fig 1.2 - New Dataverse Table “Demo_ExpenseTable” with Primary Column as ExpenseId

Step 3

Newly created Dataverse Table once created will look something like shown in the below Fig 1.3,

Also notice that the primary column “ExpenseId” is created for the new table

Fig 1.3 - Dataverse Table created with primary column

Step 4

Let’s modify the created Primary column, click on the Primary column and edit the details like changing the data type to Autonumber with minimum number of digits as 1, seed value as 1, as shown in Fig 1.4. Don’t forget to click on Done and Save table at the end

Fig 1.4 - Edit the Primary Columne “ExpenseId” > Click on Done > Save Table

Step 5

Let’s quickly create another Dataverse “Demo_ExpenseCategory” with CategoryId as the primary column, Once the table is created, edit the Primary column as shown in Step 4, refer below shown Fig 1.5 & Fig 1.6

Fig 1.5 - Demo_ExpenseCategory Table created with CategoryId as primary column

Fig 1.6 - Edit the CategoryId primary column > Done > Save table

Step 6

Let's create a Choice Type Column in Demo_ExpenseCategory Table, for this, Navigate to the mentioned table, Click on Add Column, Choose Choice as datatype and then add new choices in the Items as shown in fig 1.7. Click on save, it will redirect you to details panel as shown in Fig 1.8, click on Done to create new column then Save the table to reflect these changes in the table.