Practice Lab 3.1 – Forms

Scenario

You are a Power Platform functional consultant and have been assigned to the Fabrikam project for the next stage of the project.

In this practice lab, you will be modifying the forms for the Fabrikam Environment model-driven apps.

There are three model-driven apps in the solution:

  • Environmental Administration
  • Environmental Management
  • Environmental Project Delivery

You will be:

  • modifying columns on the project form
  • adding the timeline control to the project form
  • replacing the project outcomes sub-grid
  • adding the columns you created in the earlier lab to the forms
  • editing the project quick view form
  • adding a filter to the contact lookup on Program
  • adding a quick create form
  • copying a form
  • adding the table you created in the earlier lab to an app

Exercise 1 – Edit Project forms

In this exercise, you will make changes to the forms for the Project table.

Task 1.1 – Modify the Project main form

In this task, you will perform the following changes to the form:

  • change the label for project description
  • increase the size of project description field
  • add columns to the form
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in your Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Project table.

  7. Under Data experiences, click Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit > Edit in new tab.

  9. Select the Project Description field.

  10. In the properties pane on the right-hand side, change Label to Description.

  11. In the properties pane on the right-hand side, increase Form field height to 4 rows.

  12. Select Table columns on the left-hand side of the form designer.

  13. Drag the Project Code column into the Header.

  14. Drag the Project Lead column below Region.

  15. Drag the Length of Project column below Estimated End.

  16. Select the Funding tab.

  17. Drag the Total Project Funding column above the Project Funding sub-grid.

  18. Click Save. Do not navigate away from this page.

Task 1.2 – Add Timeline control to main form

In this task, you will perform the following changes to the form:

  • change tab properties
  • insert the Timeline control
  • restrict the activities available on the Timeline
  1. Select Tree view on the left-hand side of the form designer.

  2. Select the General tab.

  3. In the properties pane on the right-hand side, select 3 columns in the Layout drop down.

  4. Select the Program section and drag to the new right-hand column of the General tab.

  5. Select the New section in the right-hand pane and click the Delete icon.

  6. Select Components on the left-hand side of the form designer.

  7. Expand Display.

  8. Drag the Timeline control to the middle column of the General tab.

  9. Select Tree view on the left-hand side of the form designer, expand General tab, and select the New Section.

  10. In the properties pane on the right-hand side, enter Timeline for Label and Name.

  11. Check the Hide label box.

  12. In Tree View, select the Note Text control for the Timeline.

  13. In the properties pane on the right-hand side, click on Fax, uncheck the Enable box, and click Done.

  14. In the properties pane on the right-hand side, click on Letter, uncheck the Enable box, and click Done.

  15. In the properties pane on the right-hand side, click on Social Activity, uncheck the Enable box, and click Done.

  16. In the properties pane on the right-hand side, select Date Created in Sort activities by drop-down.

  17. Click Save. Do not navigate away from this page.

Task 1.3 – Sub-grids on main form

In this task, you will perform the following changes to the form:

  • replace the sub-grid for the many-to-many relationship between Project and Outcome with a sub-grid for the Project Outcome table
  1. Select the Outcomes tab.

  2. Select the Outcomes SubGrid.

  3. In the properties pane on the right-hand side, select Project Outcomes (Project) in the Table drop-down.

  4. Click Save.

  5. Close the form designer.

  6. Click Done.

Task 1.4 – Modify the Project quick view form

In this task, you will perform the following changes to the form:

  • add a sub-grid of Outcomes to the quick view form
  1. Select the Quick View form, click on the ellipses (…), and select Edit in new tab.

  2. Select Table columns on the left-hand side of the form designer.

  3. Drag the Region column below Owner.

  4. Drag the Project Type column below Region.

  5. Click on the Project Status column to add to the form below Project Type.

  6. Select the Owner field.

  7. In the properties pane on the right-hand side, check the Hide box.

  8. Select Components on the left-hand side of the form designer.

  9. Click on the the 1-column section control to add it to the form.

  10. In the properties pane on the right-hand side, enter Outcomes for Label and Name.

  11. Expand Grid in the Components pane.

  12. Click Subgrid and check Show related records.

  13. Select Outcomes for Table.

  14. Select Outcomes SubGrid for Default view.

  15. Click Done.

  16. In the properties pane on the right-hand side, enter Outcomes for Label and OutcomesSG for Name.

  17. Check Hide Label

  18. Click Save.

  19. Close the form designer.

  20. Click Done.

Exercise 2 – Edit Program form

In this exercise, you will add filtering on a lookup field on the Program table form.

Task 2.1 – Add filtering to lookup

In this task, you will perform the following changes to the form:

  • add a filter to the Contact lookup to only show Contacts that belong to the selected Account
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Program table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Select the Sponsor Main contact field.

  10. In the properties pane on the right-hand side, expand Filtering.

  11. Check the Filter by related rows box.

  12. Select Sponsor (Programs) for Relationship to current table.

  13. Select Company name (Contacts) for Relationship to this lookup’s table.

  14. Click Save.

  15. Close the form designer.

  16. Click Done.

Exercise 3 – Edit Program Funding form

In this exercise, you will add new columns to the Project Funding table form.

Task 3.1 – Add columns to form

In this task, you will perform the following changes to the form:

  • add columns to the form
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Project Funding table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Select Table columns on the left-hand side of the form designer.

  10. Drag the Currency column below Funding Percentage.

  11. Click on the Funding amount column to add to the form below Currency.

  12. Click Save.

  13. Close the form designer.

  14. Click Done.

Exercise 4 – Edit Region form

In this exercise, you will add the hierarchical relationship to the Region table form.

Task 4.1 – Add parent lookup and child sub-grid to the form

In this task, you will perform the following changes to the form:

  • add parent region lookup
  • add a sub-grid for child regions
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Region table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Select Table columns on the left-hand side of the form designer.

  10. Drag the Parent Region column below Region Name.

  11. Select Components on the left-hand side of the form designer.

  12. Click on the the 1-column section control to add it to the form.

  13. In the properties pane on the right-hand side, enter Sub Regions for Label and ChildRegions for Name.

  14. Expand Grid in the Components pane.

  15. Click Subgrid and check Show related records.

  16. Select Regions (Parent Region) for Table.

  17. Click Done.

  18. In the properties pane on the right-hand side, enter Sub Regions for Label and ChildRegionsSG for Name.

  19. Check the Hide label box.

  20. Click Save.

  21. Close the form designer.

  22. Click Done.

Exercise 5 – Project Resource Quick Create form

In this exercise, you will create a Quick Create form for the Project Resource table form.

Task 5.1 – Enable Quick Create form

In this task, you will enable the Project Resource table for quick create.

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

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Project Resource table.

  7. Under Table Properties, select on Properties.

  8. In the Edit table pane that appears on the right-hand side of the screen, expand Advanced options and scroll down.

  9. Check the Leverage quick-create form if available box.

  10. Click Save.

Task 5.2 – Create Quick Create form

In this task, you will create a quick create form.

  1. Under Data experiences, click on Forms.

  2. Click + New form and select + Quick Create Form.

  3. Drag the Project column to add to the form in the first section.

  4. Drag the Resource column to add to the form in the first section.

  5. Drag the Project Role column to add to the form in the second section.

  6. Drag the Start column to add to the form in the third section.

  7. Drag the End column to add to the form in the third section.

  8. Select the first section, and in the properties pane click Hide label.

  9. Select the second section, and in the properties pane click Hide label.

  10. Select the third section, and in the properties pane click Hide label.

  11. Click Save.

  12. Click <- Back.

Exercise 6 – Edit Milestone form

In this exercise, you will add the status choice column to to the Milestone table form.

Task 6.1 – Add columns to the form

In this task, you will perform the following changes to the form:

  • add Milestone status to the form
  • remove Status reason from the form
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Milestone table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Drag the Milestone Status column below the Status Reason field.

  10. Select the Status Reason field and click on Delete.

  11. Click Save.

  12. Close the form designer.

  13. Click Done.

Exercise 7 – Edit Outcome form

In this exercise, you will add the status choice column to to the Outcome table form.

Task 7.1 – Add columns to the form

In this task, you will perform the following changes to the Outcome form:

  • add Outcome status to the form
  • remove Status reason from the form
  • delete the Project tab
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Outcome table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Drag the Outcome status column below the Status reason field.

  10. Select the Status reason field and click on Delete.

  11. Select the Projects tab and click on the Delete icon.

  12. Click Save.

  13. Close the form designer.

  14. Click Done.

Exercise 8 – Edit Project Outcome form

In this exercise, you will configure the default form for the Project Outcome table.

Task 8.1 – Configure main form

In this task, you will perform the following changes to the Project Outcome form:

  • change for layout
  • add columns to the form
  • hide the name on the form
  • Add a quick view form
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Project Outcome table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. Drag the Owner field from the body into the Header.

  10. Select Tree view on the left-hand side of the form designer.

  11. Select the General tab.

  12. In the properties pane on the right-hand side, enter General for Name

  13. Select 2 columns in the Layout drop down.

  14. Select the New Section section.

  15. In the properties pane on the right-hand side, enter Related for Label and Name.

  16. Click Hide label.

  17. Select Table columns on the left-hand side of the form designer.

  18. Drag the Project column below the Title field.

  19. Click on the Outcome column to add to the form below Project.

  20. Click on the Comments column to add to the form below Outcome.

  21. Click on the Outcome Completed Date column to add to the form below Comments.

  22. Click on the Stakeholders Notified column to add to the form below Outcome completed date.

  23. Select the Title field.

  24. In the properties pane on the right-hand side, check Hide.

  25. Select Components on the left-hand side of the form designer, and expand Display.

  26. Drag the Quick view control to the Related section.

  27. Select Project for Lookup.

  28. Select Information for Project.

  29. Click Done.

  30. Click Save.

  31. Close the form designer.

  32. Click Done.

Exercise 9 – Copy Outcome form

In this exercise, you will be copying a form and implementing security on forms.

Task 9.1 – Copy Outcome form

In this task, you will perform the following changes to the form:

  • Rename the main form
  • Copy the main form to allow managers to view and edit columns
  • Associate security roles with the forms
  • Set the form order
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Tables.

  6. Select the Outcome table.

  7. Under Data experiences, click on Forms.

  8. Select the Main form, click on the ellipses (…), and select Edit in new tab.

  9. In the properties pane on the right-hand side, enter User for Display Name

  10. Click Save.

  11. Click the caret next to the Save button and select Save as.

  12. Enter Manager for Display Name and Form for managers for Description. Select Save.

  13. Select Tree view on the left-hand side of the form designer.

  14. Select the General tab.

  15. In the properties pane on the right-hand side, enter General for Name

  16. Select 2 columns in the Layout drop down.

  17. Select the New Section section.

  18. In the properties pane on the right-hand side, enter Details for Label and Name.

  19. Click Hide label.

  20. Select Table columns on the left-hand side of the form designer.

  21. Drag the Goal column to the Details section.

  22. Click on Approver to add to the Details section.

  23. Click on Approver Email to add to the Details section.

  24. Click on Approved to add to the Details section.

  25. Click on Target Aim to add to the Details section.

  26. Click on Stakeholders identified to add to the Details section.

  27. Click on Tasks created to add to the Details section.

  28. Click on Tasks assigned to add to the Details section.

  29. Click on Tasks completed to add to the Details section.

  30. Click on Environmental impact assessment completed to add to the Details section.

  31. Click Save.

  32. Click Form Settings.

  33. Select the Environmental manager and Environmental administrator roles as the specific security roles that should have access to this form.

  34. Select Form Order.

  35. Drag Manager above Information.

  36. Select Fallback forms.

  37. Uncheck Enable Manager form as a Fallback form.

  38. Click Save and publish.

  39. Close the form designer.

  40. Click Done.

  41. Select the User form.

  42. Click Form Settings.

  43. Select the Specific security roles radio button.

  44. Select the Environmental user role.

  45. Click Save and publish.

Task 9.2 – Publish changes

  1. In the Objects pane on the left, select All.

  2. Click on Publish all customizations.

Exercise 10 – Modify model-driven apps

In this exercise, you will be adding the tables and forms to the Fabrikam model-driven apps.

Task 10.1 – Environmental Management app

In this task, you will perform the following changes to the app:

  • Add Project Outcome table
  • Use the Manager form
  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Solutions.

  4. Click to open the Fabrikam Environmental solution.

  5. In the Objects pane on the left, click and expand Apps.

  6. Select the Environmental Management app, click on the ellipses (…), and select Edit in new tab.

  7. Click Add page.

  8. Select Table based view and form.

  9. Click Next.

  10. Search for and select Project Outcome.

  11. Uncheck Show in navigation.

  12. Click Add.

  13. Click Add page.

  14. Select Table based view and form.

  15. Click Next.

  16. Search for and select Outcome.

  17. Uncheck Show in navigation.

  18. Click Add.

  19. Expand Outcome in the Pages pane on the left-hand side.

  20. Select Outcome form.

  21. In the Outcome form pane on the right-hand side, click + Add form.

  22. Select the Manager form.

  23. Click Save.

  24. Click Publish.

  25. Click Play.

  26. Click around and interact with your Environmental Management app before closing the app and app designer windows.

  27. Click Done.

Task 10.2 – Environmental Project Delivery app

In this task, you will perform the following changes to the app:

  • Add Project Outcome table
  • Use the User form
  1. Select the Environmental Project Delivery app, click on the ellipses (…), and select Edit in new tab.

  2. Click Add page.

  3. Select Table based view and form.

  4. Click Next.

  5. Search for and select Project Outcome.

  6. Uncheck Show in navigation.

  7. Click Add.

  8. Expand Outcome in the Pages pane on the left-hand side.

  9. Select Outcome form.

  10. In the Outcome form pane on the right-hand side, click + Add form.

  11. Select the User form.

  12. Click Save.

  13. Click Publish.

  14. Click Play.

  15. Click around and interact with your Environmental Project Delivery app before closing the app and app designer windows.

  16. Click Done.