This blog is a step-by-step walkthrough of building a fully functioning leave request app for any organization with a vacation, sick leave, military leave, bereavement leave, holidays, Jury Duty, and so on. This app will include a solution in the Common Data Service, a Model-Driven App, a Canvas App, and Power Automate. The Canvas App is for employees to submit a request. The Model-Driven App will be a back-office system used by admin or supervisors to check everyone’s requests. The Power Automate flow will trigger an approval email to the employee’s supervisor and an automated email to the employee once the supervisor has either approved or rejected the leave request.

The app’s flow will start with the employee using the Canvas App to submit a leave request form. Once that form is submitted, an email is sent to the supervisor, and, simultaneously, a new row is added to the Model-Driven App with the new leave request entry. Once the supervisor has approved or rejected the request, the employee will receive an email with the decision.

Pre-requisites

1. A Microsoft PowerApps Trial Plan 2, this can be a Free Trial
2. Ensure you are using an environment with a database

Common Data Service (CDS)

1. Navigate to https://make.powerapps.com/
2. Create a New Solution called “Leave Request Solution”
   1. Create a New Publisher called “Leave Request App”
3. Select New > Entity name it “Leave Request Entity” and Enable Attachments
   
   
4. Select Add Fields
   

• Add Field: First name
  • Data Type: Single Line Text
  • Required
• Add Field: Last name
  • Data Type: Single Line Text
  • Required
• Add Field: Email
  • Data Type: Email
  • Required
• Add Field: Supervisor Email
  • Data Type: Email
  • Required
• Add Field: Start date
  • Data Type: Date Only
  • Required
• Add Field: End date
  • Data Type: Date Only
  • Required
• Add Field: Request Type
  • Data Type: Option Set
    • Create New: “Request Type”
      
  • New Option: Vacation Leave
  • New Option: Sick Leave
  • New Option: Military Leave
  • New Option: Bereavement Leave
  • New Option: Jury Duty
• Add Field: Work Items
  • Data Type: Multiline Text
  • Required: Recommended

1. SAVE ENTITY
2. Navigate to the Views tab
3. Select Active Leave Request Entities
   
   

• Right-click on Created On Column > Remove
• Add Last Name by clicking the field on the left
• Add Email by dragging the field to the editor
• Add Start Date
• Add End Date
  
  

1. Once your View looks like the above, click Save, Publish, then Back
2. Navigate to the Forms tab
   1. Click on the row with the Form type “Main”
      
   2. Add all custom fields by clicking them directly on the left
   3. Select the section so that it is outlined in purple
   4. Click Formatting on the right, select 2 columns
      
3. Once your Form looks like the above, select Save, Publish, then Back

Model-Driven App

1. Navigate to the “Leave Request Solution”
2. Select New > App > Model-Driven App
3. Name it “Leave Request Back Office”
4. Check “Use the existing solution to create the App”
5. Select Next
6. Select Solution: * “Leave Request Solution”
7. Select Site Map to configure it
   
   1. Select the pencil next to New Subarea
   2. Select the “Leave Request Entity” from the dropdown on the right
      
8. Publish, and Save and Close
9. In the App Designer view, select Publish then Play
10. Select New
    1. Add test data
    2. Select Save & Close
       

Canvas App

1. Navigate back to the “Leave Request Solution”
2. Select New > App > Canvas App > Tablet form factor
3. Select the Insert tab > Forms > Edit
4. A box will appear in the editor, select Connect to data
   1. Select “Leave Request Entities” on the left
   2. Under Data source on the right, select “Leave Request Entities”
   3. Select Edit Fields
   4. Add the remaining fields in the popup modal
   5. Set Default mode to New
   6. Change name to “Leave Form”
      
5. Navigate to Insert tab > Button
   1. Select OnSelect from dropdown
   2. Type “SubmitForm(‘Leave Form’);Navigate(Screen2);” in the functions(fx) box
      
      1. Select Text from dropdown and type “Submit Request”
6. Navigate to Insert tab > New Screen > Success
7. Navigate to the File tab > Save > Publish > Play
   
8. Add test data, select Submit, navigate back to the Model-Driven App to see the new entry

Power Automate

1. Navigate back to the “Leave Request Solution”
2. Select New > Flow
3. In the search box type “When a record is created” and select the Common Data Service option
   
4. Fill in the trigger box:
5. Select New Step
6. Then the Choose an Action box, type “Start and wait for an approval” in the search box and select it
7. Fill in the action box using the Dynamic Content box
   1. Click inside the input field and then select the correct dynamic field from the Dynamic Content popup box
      
8. Select New Step
9. Select Condition
10. Fill in the boxes:
    
11. Select Save >Test > Check “I’ll perform the trigger action” > Select Save & Test
12. Navigate to your Canvas App, select Play, add test data, and Submit Form
13. You should see an approval email in the inbox you sent the supervisor email to, select Approve
    
14. Another email will be sent to the employee’s email with the response
    

Final Thoughts

Congratulations! You have completed the Leave Request app using the Common Data Service, a Model-Driven App, a Canvas App, and Power Automate. You have a fully functioning application that can be used right away! The next steps would be to implement a status field where the Approve or Reject decision will be updated in the Model-Driven App so supervisors can keep track of any pending requests. This app can be adjusted to your organization’s needs and requirements, but this app is a great starting point.