Power Apps: Build Business Apps Without Code
Power Apps: No-Code Business Apps is an intermediate-level course of 5 lessons (about 1 h 30 min), with 15 exercises and 15 quiz questions. Prerequisites: Power Automate: Automate Your Tasks. The course needs a Windows virtual machine with Power BI, planned for a later phase of the platform.
- Power Platform
- Intermediate
- 5 lessons
- 1 h 30 min
- 15 exercises
- Windows virtual machine (phase 2)
The course in brief
This course teaches you to build a complete canvas app for purchase requests. You discover the studio and properties, connect a SharePoint list while handling delegation, write Power Fx formulas (variables, filters, logic), then create galleries and forms to view, create and edit data. You finish with sharing, data security, environments and calling a Power Automate flow.
What you will be able to do
- Design a multi-screen canvas app and name its controls cleanly
- Connect a data source and avoid the pitfalls of delegation
- Write Power Fx formulas: variables, Filter, LookUp, Sort, aggregations and logic
- Display, create and edit records with galleries, forms and Patch
- Share an app while securing the data in the source
- Organize the lifecycle with environments and solutions, and call a Power Automate flow
Syllabus: 5 lessons
- Distinguish a canvas app from a model-driven app
- Find your way around Power Apps Studio: screens, tree view, properties, formula bar
- Write your first property and behavior formulas
Canvas appPower Apps StudioControls and propertiesNavigating between screens
- 02
Data Sources and Delegation
- Connect an app to a SharePoint list, an Excel table or Dataverse
- Understand delegation and the data row limit
- Choose a source suited to the need
- 03
Power Fx Formulas: Variables, Filters and Logic
- Use global variables, context variables and collections
- Filter, search, sort and aggregate tables
- Write conditional logic and format values
- 04
Galleries and Forms: Display, Create, Edit
- Display a list of records in a gallery
- Create and edit records with a form and SubmitForm
- Write directly to a source with Patch and Remove
- 05
Sharing, Security and Lifecycle
- Share an app and manage permissions on the data
- Adapt the interface to the user's role without confusing display with security
- Organize the lifecycle: environments, solutions, versions and the link with Power Automate
Final project
Purchase Request App
Build the Demandes d'achat app on the Demandes SharePoint list: a home screen showing the signed-in user, a gallery filterable by status and search, a form for creating and editing, a summary screen, an approval button reserved for managers and an approval flow for requests over €500. Share it with a group while setting the list's permissions.
Deliverables
- The published app (at least 4 screens: home, list, entry, summary) with named controls
- The main formulas documented (gallery Items, OnSuccess, OnStart)
- The DemandeApprobation flow (Power Apps V2 trigger) triggered for amounts over €500
- The summary screen showing, on the course data, 3 pending requests for 1700 € and 580 € approved
- A security note: sharing, SharePoint permissions, limits of hiding interface elements, delegation
Assessment criteria
- Correct, readable Power Fx formulas (separators, prefixed names, no unnecessary variables)
- Delegation under control: warnings identified and addressed or justified
- Working creation, editing and approval of requests, with input checks
- Security set in the source and interface adapted to the role
- Clean integration of the Power Automate flow and sharing with a group and a co-owner
Frequently asked questions
Do I need to know how to code to use Power Apps?
No, but you should be comfortable with Excel-style formulas. Power Fx follows the same logic: every property is a formula that is recalculated automatically.
Why do the formulas use semicolons?
In a Power Apps configured for French, the semicolon separates arguments and the double semicolon chains actions. English documentation uses the comma and the semicolon.
Which data source should I choose to get started?
A SharePoint list works well for a simple team app. Dataverse is preferable for large volumes, relationships and fine-grained security, depending on your organization's license.
What is delegation?
It is the ability to have the source filter or sort the data. A non-delegable formula only processes the first rows (500 by default), which can give an incomplete result.
This course, told for your job
Say what you want to be able to do: “Power Apps: No-Code Business Apps” takes its place in your path, with examples from your field. The concepts stay those of the course.