Course Outline for Microsoft PowerApps

Course Outline for Microsoft PowerApps

This course is designed to enable you to develop web apps easily with a minimum of coding and using a complete browser based IDE. This course shall focus on Canvas Apps and the connections to external sources will be limited to SharePoint and non-premium data sources.

The course shall span over 3 days with the following specifications:

• No more than 8 participants in a single batch
• All participants meet the prerequisites
• Class begins at 9am and ends at 5pm with one hour’s lunch breaks and two 15 minute breaks in between (as per HRDCorp regulations).

Expected outcome:

Every learner has different learning patterns and absorption rates. As such, it is virtually impossible to gauge an exact learning outcome of each participant. However, it may be safely assumed that by the end of this course, each learner shall be able to:

• Know what Microsoft PowerApps is and where it is used
• How to create user interface elements using PowerApps
• How to add functionality to the apps that are built using PowerApps
• How to connect PowerApps to external sources (SharePoint, Excel and Automate Flows)
• How to secure Power Apps (without going deep into security)
• How to deploy Power Apps solutions (the new APK and IPA distribution with AppCenter will not be covered)
• How to work with Power Automate Environments
• How to customize SharePoint forms using Power Apps and adding additional functionalities to SharePoint forms

Prerequisites:

It is expected that the pupil shall have the following at hand when participating in the course:

• Access to two screens
• Steady usage of a webcam
• Internet with at least 1 MBPS connection
• Access to MS Exchange Account
• Fluency in English
• Understanding of how to upload and download files
• Understanding of how the local file system works
• Experience in using SharePoint

Course Outline:

The course shall span over 3 full days and cover the following topics:

1. Introduction
   1. Ice Breaker
   2. Exploration
   3. Course Plan Presentation
   4. Environment setup
2. Getting started
   1. Canvas
   2. Screen
   3. Controls
   4. Dynamic property manipulation
   5. Complex controls
   6. Actions and functionalities
   7. RTE & Markup
   8. Multimedia
   9. Buttons
   10. Icons and other clickables
   11. UI Components
   12. Visualizations
3. Functionalities
   1. Code planning
   2. Operators
   3. Filters
   4. Formulas
   5. CRUD
   6. Aggregate functions
4. Connectors
   1. Excel
   2. Forms
   3. SharePoint
   4. Lookup tables
   5. PowerAutomate
   6. Email integration
5. Security
   1. Permissions
   2. Environments
   3. Packaging
   4. Deploying