Demo 3 - Tables

Objective: In this demo, you will show how to create tables in a Dataverse solution. In later demos you will add columns and relationships.

Screenshot ERD for Demo tables.

Task 3.1 - Create table for Pets

  1. Navigate to the Power Apps maker portal https://make.powerapps.com.

  2. Select the Demo environment.
  3. Select Solutions from the left navigation pane.
  4. Select the PL400 Demos solution.
  5. Select + New and then select Table and select Table again.
  6. Enter Pet for Display Name.
  7. Check Enable attachments.
  8. Expand Advanced options.
  9. Change Schema name to lower case.
  10. Show options for Type and select Standard.
  11. Show options for Record ownership and select User or team.
  12. Scroll down and show the other table options.
  13. Check Audit changes to its data.
  14. Check Create a new activity.
  15. Check Appear in search results.
  16. Uncheck Doing a mail merge.
  17. Select the Primary column tab.
  18. Change the Display Name to Pet Name.
  19. Expand Advanced options.
  20. Show the options for the primary column.
  21. Change Schema name to lower case.
  22. Enter 30 for Maximum character count.
  23. Select Save.
  24. Select All in the Objects tree.

Task 3.2 - Create table for Tricks

  1. Select + New and then select Table and select Table again.

  2. Enter Trick for Display Name.
  3. Expand Advanced options.
  4. Change schema name to lower case.
  5. Select Organization for Record ownership.
  6. Check Audit changes to its data.
  7. Check Appear in search results.
  8. Uncheck Doing a mail merge.
  9. Select the Primary column tab.
  10. Change the Display Name to Trick Name.
  11. Expand Advanced options.
  12. Change Schema name to lower case.
  13. Enter 50 for Maximum character count.
  14. Select Save.
  15. Select All in the Objects tree.

Task 3.3 - Create table for Pet Tricks

  1. Select + New and then select Table and select Table again.

  2. Enter Pet Trick for Display Name.
  3. Expand Advanced options.
  4. Change Schema name to lower case.
  5. Uncheck Apply duplicate detection rules.
  6. Uncheck Doing a mail merge.
  7. Select the Primary column tab.
  8. Expand Advanced options.
  9. Change Schema name to lower case.
  10. Select Optional for Column requirement.
  11. Select Save.
  12. Select All in the Objects tree.
  13. Select Publish all customizations.