Exercise - Create custom tables

  • 20 minutes

In this unit, you learn how to:

  • Create a Dataverse solution
  • Create a custom table in Dataverse

Here, you create the table and columns needed to store the booking request information.

Create a solution

Follow these steps to create a new solution.

  1. Navigate to the Power Apps maker portal.

  2. Select your Environment.

  3. In the left navigation pane, select Solutions, and select + New solution

    Screenshot of solutions in the Maker portal.

  4. Enter Bookings for Display name.

  5. Select + New publisher.

  6. Enter Contoso for Display name.

  7. Enter contoso for Name.

  8. Enter contoso for Prefix.

  9. Select Save.

  10. Select the Contoso (contoso) publisher.

  11. Select Create.

  12. Select Back to solutions in the top-left of the screen.

Set the preferred solution

All objects are automatically added to the preferred solution.

  1. Under Solutions in the Maker portal, select Manage for Set your preferred solution.

  2. Select Bookings (contoso) and select Apply.

    Screenshot of preferred solution in the Maker portal.

Create the Real Estate Properties custom table

Follow these steps to create a new custom table in Dataverse for Real Estate Properties.

  1. In the left navigation pane, select Tables, select New table, and then select Add columns and data.

    Screenshot of creating a new table in Dataverse.

  2. Rename the table from New Table to Real Estate Property.

  3. Change the name of the column called New Column to Property Name.

  4. Select the + New column button to add a new column in the columns and data pane.

  5. In the New column pane, enter the following values, and then select Save:

    • Display name: Asking Price
    • Data type: Currency

  6. Let's add another column in the columns and data pane. Again, select the + New column button to add a new column.

  7. In the New column pane, enter the following values, and then select Save:

    • Display name: Street
    • Data type: Single line of text (this value is the default)

  8. Select the + New column button to add a new column in the columns and data pane.

  9. In the New column pane, enter the following values, and then select Save:

    • Display name: City
    • Data type: Single line of text (this value is the default)

  10. Select the + New column button to add a new column in the columns and data pane.

  11. In the New column pane, enter the following values, and then select Save:

    • Display name: Bedrooms
    • Data type: Choice

  12. Create the choice values:

    • Under Choices you see two entry fields titled Label and Value. Enter 1 under the label. Power Apps assigns a value automatically but you can change the value to 1.
    • Select + New choice and make 2 the new entry for Label and 2 for Value.
    • Select + New choice and make 3 the new entry for Label and 3 for Value.
    • Select + New choice and make 4 the new entry for Label and 4 for Value.
    • Select + New choice and make 5 the new entry for Label and 5 for Value.
    • Select Save.

  13. Add another column by selecting the + button again in the columns and data pane.

  14. Select the + New column button to add a new column in the columns and data pane.

  15. In the New column pane, enter the following values, and then select Save:

    • Display name: Bathrooms
    • Data type: Choice

  16. Create the choice values:

    • Under Choices you see two entry fields titled Label and Value. Enter 1 under the label. Power Apps assigns a value automatically but you can change it to 1.
    • Select + New choice and make 2 the new entry for Label and 2 for Value.
    • Select + New choice and make 3 the new entry for Label and 3 for Value.
    • Select + New choice and make 4 the new entry for Label and 4 for Value.
    • Select + New choice and make 5 the new entry for Label and 5 for Value.
    • Select Save.

  17. Add another column by selecting the + button again in the columns and data pane.

  18. In the New column pane, enter the following values, and then select Save:

    • Display name: Client
    • Data type: Lookup
    • Related Table: Contact

  19. At the bottom of the pane, select Create.

  20. Under Real Estate Property columns and data, enter the following test data:

    • Property Name: 1100 High Villas
    • Asking Price: 250,000
    • Bathrooms: 3
    • Bedrooms: 2
    • City: Redmond
    • Street: Main Avenue
    • Client: Select any contact

Create the Bookings table

Follow these steps to create a new custom table in Dataverse for Real Estate Property Bookings.

  1. In the left navigation pane, select Tables, select New table, and then select Add columns and data.

  2. Rename the table Booking Request.

  3. Change the name of the column called New Column to Booking Name.

  4. Select the + New column button to add a new column in the columns and data pane.

  5. In the New column pane, enter the following values, and then select Save:

    • Display name: Property
    • Data type: Lookup
    • Related Table: Real Estate Property

  6. Add another column by selecting the + button again in the columns and data pane.

  7. In the New column pane, enter the following values, and then select Save:

    • Display name: Viewer Name
    • Data type: Single line of text

  8. Add another column by selecting the + button again in the columns and data pane.

  9. In the New column pane, enter the following values, and then select Save:

    • Display name: Viewer Email
    • Data type: Single line of text
    • Format: Email

  10. Add another column by selecting the + button again in the columns and data pane.

  11. In the New column pane, enter the following values, and then select Save:

    • Display name: Booking Date
    • Data type: Date and time

  12. Add another column by selecting the + button again in the columns and data pane.

  13. In the New column pane, enter the following values, and then select Save:

    • Display name: Notes
    • Data type: Multiple lines of text

  14. Select the + New column button to add a new column in the columns and data pane.

  15. In the New column pane, enter the following values:

    • Display name: Decision
    • Data type: Choice

  16. Create the choice values:

    • Under Choices you see two entry fields titled Label and Value. Enter Undecided under the label. Power Apps assigns a value automatically, but you can change it to 1.
    • Select + New choice and make Accepted the new entry for Label and 2 for Value.
    • Select + New choice and make Declined the new entry for Label and 3 for Value.
    • Designate Undecided as the Default choice.
    • Select Save.

  17. At the bottom of the pane, select Create.