Demo 5 - Relationships

Objective: In this demo, you will show how to create relationships for the tables created in the previous demo.

Task 5.1 - Create one-to-many relationship from Pet to Pet Trick

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 Relationships.

8. Select + New relationship and select One-to-many.
9. Select Pet Trick for the Related (Many) Table.
10. Enter petid for Lookup column name.
11. Expand General.
12. Enter pet_pettrick for Relationship name.
13. Expand Advanced options.
14. Show the options for Type of behavior and select Parental.
15. Select Done.

Task 5.2 - Create many-to-one relationship between Contact and Pet

1. Select + New relationship and select Many-to-one.

2. Select Contact for the Related (One) Table.
3. Enter Pet Owner for Lookup column display name .
4. Enter petownercontactid for Lookup column name.
5. Expand General.
6. Enter contact_pet for Relationship name.
7. Expand Advanced options.
8. Show the options for Delete and select Remove Link.
9. Select Done.

Task 5.3 - Create many-to-one relationship between Pet Trick and Trick

1. Select the Pet Trick table.

2. Under Schema, select Relationships.
3. Show the relationship to the Pet table.
4. Select + New relationship and select Many-to-one.
5. Select Trick for the Related (One) Table.
6. Enter trickid for Lookup column name.
7. Expand General.
8. Enter trick_pettrick for Relationship name.
9. Expand Advanced options.
10. Select Restrict for Delete.

11. Select Done.

12. Select All in the Objects tree.
13. Select Publish all customizations.