Microsoft Power Apps
Microsoft Power Apps is a hands-on course in building canvas apps with today's Power Apps, from modern controls and Power Fx formulas to connecting SQL Server for CRUD and stored procedures, calling Power Automate to send email, scanning barcodes with the camera and showing Power BI. It suits citizen developers, power users, developers and IT teams who know some Excel formulas.
- Duration18 hours · 3 days
- FormatOnsite / live online
- Next roundOn request
- CertificateIncluded
Course overview
Many organisations still run work on paper, on Excel files passed through several hands, or on forms whose data has to be retyped into another system. Writing a new program in a programming language takes time and depends on a development team. Microsoft Power Apps lets citizen developers and developers build internal apps quickly with Power Fx formulas that feel like Excel, connected to existing data such as SQL Server, SharePoint and Microsoft 365, and usable on the web, tablets and phones.
This course builds canvas apps with today's Power Apps from the first screen to real use. Learners start with modern controls, themes and containers, use Power Fx, variables, collections and named formulas, build galleries and forms, connect to SQL Server for CRUD, call views and stored procedures and understand delegation. They then extend apps with Power Automate to send email and create Excel or PDF files, use the camera and barcode scanning, show charts and Power BI, meet Copilot in Power Apps, and publish and share apps, finishing with an approval app workshop. (3 days, 6 hours per day, 18 hours in total, Beginner to Intermediate level.)
What you’ll gain
- Understand Power Platform, canvas apps and model-driven apps, and choose suitable data sources and licences
- Build screens with modern controls, themes and containers that adapt to screen size
- Use Power Fx, variables, collections, named formulas and user-defined functions
- Connect to SQL Server for CRUD, call views and stored procedures, and handle delegation
- Pass values between screens, validate data before saving and handle errors
- Call Power Automate from an app to send email and create Excel or PDF files
- Use the camera, barcode scanning and attachments, and show charts and Power BI in an app
- Publish, share and move apps with solutions in an orderly way
Who this course is for
- Citizen developers and power users who want to build apps for their own work
- Developers who want to build internal apps faster with low-code
- IT teams who look after Microsoft 365 and SQL Server databases
- Team leaders and IT managers who want to understand how Power Apps can help the organisation
Prerequisites
- Able to use some Excel functions or formulas
- A basic understanding of data tables, such as rows, columns and keys
- No previous Power Apps or programming experience needed
- A work Microsoft 365 account, or the ability to sign up for the Power Apps Developer Plan
Curriculum
Course Details
This is the 2026 edition of the Microsoft Power Apps course. It runs for 3 days, 6 hours per day, 18 hours in total (09:00-16:00), building one app hands-on throughout the course, at Beginner to Intermediate level. The content has been reorganised into 15 sections for today's Power Apps, adding modern controls and themes, containers, named formulas, user-defined functions, error handling, delegation, solutions and Copilot in
Power Apps, while keeping the original core topics of SQL Server, views, stored procedures, Power Automate, charts, Power BI, the camera and barcode scanning. Power Pages is now covered as an overview. The SQL Server connector is a premium connector, so learners use a work account with a suitable licence or the Power Apps Developer Plan for practice. Learners take home the course handbook, database scripts and sample apps to adapt.
Day 1 Getting Started with Canvas Apps and Power Fx
Section 1: Power Platform and Today's Power Apps
- How Power Apps, Power Automate, Power BI and Power Pages work together
- Canvas apps and model-driven apps, and the work each one suits
- Common data sources: SharePoint, Excel, SQL Server and Dataverse
- Environments, standard and premium connectors, and licensing
- Lab: sign in to make.powerapps.com and explore Power Apps Studio
Section 2: Lab: Building a First App from Data
- Create a canvas app from an Excel table or a SharePoint list
- Tree view, properties, the formula bar and naming controls consistently
- Save, preview and test on the web and on a phone
- Lab: build an asset register app from a sample list
Section 3: Lab: Modern Controls, Themes and Containers
- Turn on modern controls and themes in an app
- The new Button, Text input, Dropdown, Date picker and Table controls
- Horizontal and vertical containers for screens that adapt to screen size
- Lab: design the home screen and navigation menu of the app
Section 4: Lab: Power Fx, Variables and Collections
- Power Fx formulas compared with Excel: If, Switch, Filter, LookUp and Sort
- Set for global variables and UpdateContext for screen variables
- Collect and ClearCollect to hold tables of data in memory
- Named formulas in App.Formulas instead of settings in OnStart
- Lab: build a supplies request basket with a collection
Section 5: Lab: Galleries, Forms and Passing Values between Screens
- Vertical and horizontal galleries and setting Items
- Edit forms, display forms and data cards
- Navigate with values passed to the next screen, and Param from the URL
- Lab: list, detail and edit screens
Day 2 SQL Server Data and App Logic
Section 6: Lab: Connecting to SQL Server
- The SQL Server connector and choosing tables with a primary key
- Connect to a cloud database, or to on-premises SQL Server through the on-premises data gateway
- SQL data types and their Power Fx equivalents
- Lab: connect to a requests database and show it in a gallery
Section 7: Lab: CRUD with SubmitForm, Patch and Remove
- Add and edit records with an edit form and SubmitForm
- Patch to save several fields or records without a form
- Remove, with confirmation before deleting
- Refresh data and report results with Notify
- Lab: a request system that can add, edit and delete records
Section 8: Lab: Delegation, Views and Stored Procedures
- What delegation is, and the warnings shown in Studio
- Filter, Search and Sort that can be processed by SQL Server
- Views for data that needs joins across several tables
- Call stored procedures from Power Fx with parameters
- Lab: a search screen for large data sets without hitting limits
Section 9: Lab: Combo Boxes, Validation and Error Handling
- Linked combo boxes and dropdowns, such as department then employee
- Validate data before saving and show messages at the field
- IfError, Errors and reporting errors in a way users understand
- Lab: a request form that checks every field before submitting
Section 10: Lab: User-Defined Functions and Components
- User-defined functions in App.Formulas for formulas you reuse
- Build components such as a header and menu to reuse on every screen
- Component libraries for sharing across several apps
- Lab: refactor the app to use functions and components
Day 3 Microsoft 365 Integration, Reports and Rollout
Section 11: Lab: Calling Power Automate from Power Apps
- Build a cloud flow with a Power Apps trigger that receives parameters
- Return values from the flow and show them in the app
- Send approval requests with Approvals and report the result
- Lab: a submit button that runs an approval flow
Section 12: Lab: Email, Excel and PDF
- Send email alerts through the Office 365 Outlook connector
- Look up user details with Office 365 Users
- Use a flow to write data to an Excel file and convert documents to PDF
- Lab: email a request summary as an attachment
Section 13: Lab: Camera, Barcodes and Attachments
- Barcode reader to scan product or asset codes
- Camera and Add picture to take and upload photos
- Attachments with SharePoint lists, and storing files within the organisation
- Lab: count assets on a phone with photo evidence
Section 14: Lab: Charts, Power BI and Copilot
- Charts in the app from summary data
- Show a Power BI tile in the app and open the full report from it
- Copilot in Power Apps: create apps and tables from a description, and help with formulas
- Review what Copilot creates before real use
- Lab: a dashboard screen summarising the department's requests
Section 15: Workshop: An Approval App and Rollout
- Publish, version history and rolling back to an earlier version
- Share the app and set users' data permissions
- Solutions for moving apps from development to production, and an overview of Power Pages
- Workshop: an end-to-end approval app from form to report
- Present the app and wrap up with a go-live checklist
Schedule & training options
For individuals — public rounds
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
For organisations — in-house / private
- Tailor the content to your team’s tools and projects
- Your dates, at your office or live online
- Quotation with tax ID for procurement
Instructors
Frequently asked questions
How are galleries and forms used differently in Power Apps?
A gallery shows many records repeated in the same template, such as a customer list or a list of requests, with its data source set in the Items property, scrolling vertically or horizontally. An edit form views or edits one record at a time, with each field in a data card, and saves with SubmitForm. A common pattern is to let users pick an item in a gallery and then open the form for that item.
How do you build CRUD against a SQL database in Power Apps?
Add the SQL Server connector and choose a table, which needs a primary key to be editable. Set a gallery's Items to that table to read data, use an edit form with SubmitForm or the Patch function to add and update records, Remove to delete them, and Filter or Search to find them. Design formulas that SQL Server can process (delegation) when the data is large, and note that this is a premium connector requiring a suitable licence.
What is the difference between Set, UpdateContext, collections and named formulas in Power Apps?
Set creates a global variable available on every screen. UpdateContext creates a variable for the current screen only, and values can be passed to the next screen through Navigate. A collection, created with Collect or ClearCollect, holds a table of data in memory, such as basket items before saving. A named formula, written in App.Formulas, recalculates automatically when its data changes and cannot be changed with Set, which suits constants and reference data instead of settings in OnStart.
Who is the Microsoft Power Apps course for, and what should I know beforehand?
It suits citizen developers and power users who want to build apps for their own work, developers who want to build internal apps faster, IT teams who look after Microsoft 365 and SQL Server, and IT managers who want to understand how Power Apps can help. You do not need Power Apps experience, but you should be able to use some Excel formulas and have a work Microsoft 365 account or be able to sign up for the Power Apps Developer Plan.
What will I be able to do after the Microsoft Power Apps course?
You will be able to build canvas apps with modern controls, themes and containers, use Power Fx, variables, collections and named formulas, connect to SQL Server for CRUD, call views or stored procedures and handle delegation, run Power Automate flows to send email and create Excel or PDF files, use the camera and barcode scanning, show charts and Power BI, and publish and share apps. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Can the Microsoft Power Apps course be run in-house for our team?
Yes. It can be run in-house for your team, with examples adapted to your own work, such as building approval or record-keeping apps for tasks your team still handles on paper or in Excel. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.