Demo 4 - Columns

Objective: In this demo, you will show how to add columns to the tables created in the previous demo.

Task 4.1 - Add columns to Pets table

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. Expand Tables.
6. Select and expand the Pet table.

7. Select Columns.

8. Select + New column
9. Enter Date of birth for Display name.
10. Select Date and time and then Date only for Data type.
11. Expand Advanced options.
12. Change Schema name to lower case.
13. Show options for Time zone adjustment and select Date only.

14. Select Save.

15. Select + New column
16. Enter Species for Display name.
17. Select Choice and then Choice for Data type.
18. Under Sync this choice with, select + New choice.
19. Enter Species type for Display name.
20. Enter Cat for Label and select + New choice.
21. Enter Dog for Label.
22. Expand Advanced options.
23. Change Schema name to lower case.
24. Select Save.
25. Select Species type for Sync this choice with.
26. Expand Advanced options.
27. Change Schema name to lower case.

28. Select Save.

29. Select + New column
30. Enter Pet value for Display name.
31. Select Currency for Data type.
32. Expand Advanced options.
33. Change Schema name to lower case.
34. Enter 0 for Minimum value.
35. Enter 99999 for Minimum value.
36. Select Save.

Task 4.2 - Add columns to Tricks table

1. Select Tricks table.

2. Select + New and then select Column.
3. Enter Points for Display name.
4. Select Number and then Whole number for Data type.
5. Show the options for Format and select None.
6. Expand Advanced options.
7. Enter `trickpoints’ for Schema name.
8. Enter 0 for Minimum value.
9. Enter 100 for Minimum value.
10. Select Save.

Task 4.3 - Add columns to Pet Tricks table

1. Select Pet Trick table.
2. Under Schema, select Columns.
3. Select + New column.
4. Enter Points for Display name.
5. Select Number and then Whole number for Data type.
6. Show the options for Format and select None.
7. Expand Advanced options.
8. Change Schema name to lower case.
9. Enter 0 for Minimum value.
10. Enter 100 for Minimum value.

11. Select Save.

12. Select + New column
13. Enter Level for Display name.
14. Select Choice and then Choice for Data type.
15. Under Sync this choice with, select + New choice.
16. Enter Skill level for Display name.
17. Enter Beginner for Label and select + New choice.
18. Enter Intermediate for Label and select + New choice.
19. Enter Expert for Label.
20. Expand Advanced options.
21. Change Schema name to lower case.
22. Select Save.
23. Select Skill level for Sync this choice with.
24. Select Beginner for Default choice.
25. Expand Advanced options.
26. Change Schema name to lower case.

27. Select Save.

28. Select the Status Reason column.
29. Select Edit.

30. Change the Active option label to New Trick.

    • Make sure you have Active selected for Status.
    • Change the Label from Active to New Trick.

31. Add the Training option.

    • Select + New choice.
    • Enter Training for Label.

32. Add the Evaluation option.

    • Select + New choice.
    • Enter Evaluation for Label.

33. Add the Passed option.

    • Select + New choice.
    • Enter Passed for Label.

34. Add the Rejected option.

    • Select + New choice.
    • Enter Rejected for Label.

35. Select New Trick for Default choice.

36. Change the Inactive option label to Canceled.

    • Select the Inactive Status.
    • Change the Label from Inactive to Canceled.
37. Select Save.
38. Select All in the Objects tree.
39. Select Publish all customizations.