Microsoft Power Apps
Learn how to build powerful business applications without heavy coding. Master Canvas Apps, Model-Driven Apps, formulas, connectors, and best practices to create scalable enterprise solutions using Microsoft Power Platform.
π± App Creation and Types
Three-Screen Canvas App
Learn how to create a three-screen Canvas Power Apps application.
- Browse Screen
- Details Screen
- Edit Screen
Create a Model-Driven App
Understand how Model-Driven Power Apps work and how to create one step-by-step.
Blank Canvas Power App
Create a Canvas App from scratch and learn the fundamentals of screen design.
Create an App from Template
Learn how to quickly create applications using built-in Power Apps templates.
Power Apps from Teams
Create Power Apps inside Microsoft Teams and manage table permissions and sharing.
Rename, Preview & Themes in PowerApps
Learn how to manage basic app settings:
- Renaming the app
- Previewing the application
- Applying themes
ποΈ Controls in Power Apps
Attachment Control in PowerApps
Learn how to upload and manage file attachments in Canvas apps.
Image Control in PowerApps
Display images dynamically using the Image control in Canvas apps.
Data Table Control in Power Apps
Display tabular data with sorting and filtering capabilities.
Column Chart Control
Create column charts to visualize business data in Power Apps.
Line Chart Control
Use line charts to visualize trends and time-series data.
Pie Chart Control
Visualize proportions and distributions using pie charts.
Gallery Control in PowerApps
Display dynamic lists of records using gallery layouts.
Form Control in Power Apps
Create data entry and editing forms connected to data sources.
Dropdown Control in Power Apps
Allow users to select values from a dropdown list.
Combo Box Control
Select single or multiple records using advanced search features.
Button Control in PowerApps
Create interactive actions such as navigation, submission, or calculations.
Card Control in PowerApps
Understand how cards organize fields inside forms.
Radio, Checkbox & Toggle Controls
Use selection controls to capture user choices in apps.
Slider & Rating Controls
Allow users to provide ratings or select numeric ranges.
Text Input Control
Capture user text input for forms and filtering.
List Box Control
Select items from a scrollable list of options.
Timer Control
Trigger events automatically using timers.
Text Label Control
Display static or dynamic text in Power Apps screens.
Date Picker Control
Select and manage date inputs inside Power Apps forms.
HTML Text Control
Render formatted HTML content directly inside Power Apps screens.
βοΈ Functions in Power Apps
LookUp PowerApps Function
Learn how the LookUp function retrieves a single record from a data source in Canvas Power Apps.
Filter Function in Power Apps
Use the Filter() function to return records from a data source based on conditions.
First, Last & Index Functions
Understand First, FirstN, Index, Last and LastN functions used to retrieve records from collections.
Search Function in Power Apps
Learn how the Search function finds records containing specific text.
Table Function in Power Apps
Use the Table function to create temporary tables inside Power Apps.
Remove, RemoveIf & Clear Functions
Learn how Remove, RemoveIf, and Clear functions delete records or clear collections.
Patch Function in Power Apps
The Patch() function updates or creates records in a data source.
Concat, Concatenate & Split
Work with strings using Concat(), Concatenate(), and Split() functions.
Reset Function in Power Apps
The Reset() function resets controls back to their default values.
If & Switch Functions
Use If() and Switch() to implement conditional logic in Power Apps.
Sort Functions
Sort data using Sort() and SortByColumns() functions.
ForAll Function
Use ForAll() to execute formulas for each record in a table.
Navigate and Back Functions
Control screen navigation using Navigate() and Back().
Distinct Function
The Distinct function returns unique values from a data source.
True and False Concept
Understand Boolean values and logical conditions in Power Apps.
Controls in Power Apps
Learn about different UI controls used in Canvas Power Apps.
Display Mode of a Control
Understand how display modes affect control behavior in Power Apps.
Group Controls
Learn how to group multiple controls for better layout management.
Find Function
The Find() function locates text inside a string.
Len Function
Use Len() to count the number of characters in a string.
AddColumns Function
Add calculated columns dynamically using AddColumns.
DropColumns Function
Remove columns from tables using the DropColumns function.
RenameColumns Function
Rename existing columns using the RenameColumns function.
ShowColumns Function
Select specific columns using the ShowColumns function.
Value Function
Convert text into numeric values using the Value() function.
Select Function
The Select() function triggers another controlβs action.
SubmitForm() & ResetForm()
Work with forms using SubmitForm() and ResetForm().
Date Functions
Use functions like Today(), Now(), Day(), Month(), and Year().
Round Functions
Use Round, RoundDown, and RoundUp for numeric rounding.
Left, Mid & Right Functions
Extract text using Left(), Mid(), and Right().
Notify() and User() Functions
Display messages using Notify() and retrieve user info using User().
Text Function
Format numbers, dates, and values using the Text() function.
Color Functions
Work with colors using ColorFade() and ColorValue().
GroupBy Function
Group records using the GroupBy function.
Weekday and WeekNum Functions
Work with week calculations using Weekday() and WeekNum().
Numeric Functions
Learn numeric functions like Average(), Max(), Min(), Mod(), and Sum().
ποΈ Dataverse and Data Management
Auto numbering column in Dataverse Table
Learn how to create an Autonumbering column in a Dataverse table to automatically generate unique values.
Import data in Dataverse
Learn how to import data into Microsoft Dataverse tables from external sources.
Power BI with Dataverse
Learn how Power BI integrates with Dataverse to build analytics within Power Apps solutions.
Create a Calculated column in Dataverse
Learn how to define calculated columns inside Dataverse tables for dynamic value generation.
Views in Dataverse
Learn how to edit existing views and create new custom views in Microsoft Dataverse.
Environment, Business Units, and Security concepts in Microsoft Dataverse
Understand environments, business units, and security roles in Microsoft Dataverse.
Microsoft Dataverse Table
Create Microsoft Dataverse tables and define columns to store structured data.
Business rules in Dataverse
Learn how to define business rules to automate logic within Dataverse tables.
Choices in Dataverse
Create and use reusable choice lists in Dataverse across Power Apps applications.
Create an alternate key in Dataverse
Learn how to define alternate keys to uniquely identify records in Dataverse.
Attachment in Dataverse
Enable attachments in Dataverse tables and use attachment controls inside Power Apps.
Forms in Model-driven apps
Customize forms in model-driven apps to create and manage records in Dataverse.
βοΈ Advanced Features and Concepts in Power Apps
Collections in Power Apps
Learn the Collections and the Collect() and ClearCollect() functions in canvas Power Apps.
App Object in Power App
Learn about the various app object properties available in Power Apps.
Elements of a Table in Power Apps
Understand the Elements of a Table such as fields, columns, records, and tables.
Canvas App Components
Create reusable components to build scalable and maintainable canvas apps.
Sidebar Navigation Component in Power Apps
Create a reusable sidebar navigation component for canvas apps.
Cascading Dropdown in Power Apps
Create a cascading dropdown where the first dropdown filters values in the second dropdown.
The in and exactin Operators
Understand how the in and exactin operators work in canvas Power Apps.
Filter with Combo Box
Filter records dynamically using a combo box selection.
Form Components in Power Apps
Learn about different components used inside the form control in canvas apps.
Tabbed PowerApps Form
Create a tabbed form interface in canvas Power Apps.
Save as Draft in PowerApps
Implement Save as Draft functionality in canvas Power Apps.
Improve PowerApps Performance
Learn best practices to optimize Power Apps performance.
Variables in PowerApps
Understand Global and Context variables and the @ disambiguation operator.
Add a Scrolling Screen to a Canvas App
Learn how to create scrollable screens and reposition controls in canvas apps.
Relationships in SharePoint List and Power Apps
Create relationships between SharePoint lists and use them inside Power Apps.
Design the Form Control
Learn how to design and customize form controls in canvas Power Apps.
π Integrations and Connectors
Office365Users Connector
Learn about the various Office365Users connector functions.
- SearchUser
- UserProfile
- UserPhoto
- MyProfile
- DirectReports
- Manager
office365outlook.SendEmail | Send Mail from Powerapps
Learn how to send emails from Power Apps using the Office365Outlook connector.
Customize SharePoint List Form using Power Apps
Create custom forms for SharePoint lists using Power Apps.
Trigger Flow From PowerApps
Trigger Power Automate flows directly from Canvas Apps and receive responses.
π App Management and Deployment
Manage PowerApp Versions
Learn how to manage Power Apps versions and restore previous versions.
Share the Power Apps
Share Canvas or Model-Driven apps with users, groups, or your organization.
Solutions in Power Platform
Understand managed and unmanaged solutions and how to import/export them.
Comments in PowerApps Code
Use comments in Power Fx formulas for readability, testing, and maintenance.
Configure Charts and Dashboards in Model-Driven Apps
Learn how to configure charts and dashboards in model-driven applications.
Environment Variables in Solution
Understand environment variables and how to use them inside solutions.
Containers in Power Apps
Learn how to structure layouts using containers in Canvas Apps.