PART 1 - Power Platform Overview
Introduction to the Power Platform
The Microsoft Power Platform consists of Power Apps, Power Automate, Power BI, Power Virtual Agents and Power Pages.
These applications are powerful alone, yet together, they can be used to create end-to-end business solutions.
In this module we will see how Power Apps and Power Automate fit within this Platform.
- Overview of the Microsoft Power Platform
- Power Apps, Power Automate, Power BI, Power Virtual Agents & Power Pages
- Microsoft Dataverse
- Real world use case of the Power Platform
Power Platform Licensing Guide
the licensing for the Power Platform might initially seem complex.
This chapter will furnish a comprehensive overview of the licensing system and equip you with all the necessary
information to accurately assess potential costs.
- Power Apps and Power Automate Licensing Overview
- Included features by license type
- Connectors and Connections Overview
- Standard vs Premium Connectors
PART 2 - Power Apps Canvas Apps
Introduction to Power Apps
In the world of information workers, you will handle information that is stored across various software suites, such as SharePoint, Salesforce, Access databases and more.
You would like your end-users to be able to browse and/or modify this data in a user-friendly and preferably mobile manner.
Microsoft Power Apps enables you, without requiring any development skills, to create these user-friendly applications using your data.
Once your design is complete, you can share your apps so others can utilize (and modify) them.
- Microsoft Power Apps
- Power Platform Environments
- Canvas Apps vs. Model-Driven Apps
- Getting started with Canvas Apps using templates
- Power Apps on mobile
- LAB - Getting started with Canvas Apps
Building Canvas Apps
In this module, we'll explore the capabilities of designing a Power Apps Canvas app using the Power Apps Studio.
It also introduces students to Power Fx, a low-code formula language that enables app makers to incorporate
logic into Power Apps. You will become familiar with connecting to data sources, creating screens, adding controls,
bindings, behaviour, and more.
- Power Apps Studio
- Data and API Connections
- Creating Canvas Apps from Data Connection vs. from Scratch
- Screens & Controls
- Power FX
- LAB - Customizing a Canvas App
Working with Forms in Canvas Apps
In applications, we often require the ability to view, modify, add, or delete data from external data sources,
such as SQL Server or SharePoint. In Canvas Apps, this functionality is achieved using forms.
In this module, we will take an in-depth look at the various types of forms available for use in Canvas Apps.
- Customizing Edit- and Detail Forms
- Saving Form Data to a Data Source
- Data Cards
- Data Card Customizations
- Input validation
- Hidden Data Cards
- LAB - Working with Forms
Data Sources and Local Data in Canvas Apps
In your application, you almost always utilize one or more data sources.
In this module, we will delve deeper into these, while also exploring local data collections
and variables that allow for the temporary retention of data without requiring a connection to a data source.
- Variables and Collections
- Data Source Configuration, Operations & Manipulations
- Handling and Preventing Errors
- Data Source Search, Sort & Refresh
- Data Source Delegation
- LAB - Build Canvas App on SharePoint Data Source
Configuring and Publishing Canvas Apps
Canvas Apps provide a range of configuration options.
Take into account factors like orientation, responsiveness, version control, and more.
Once the Canvas App is finalized, you'll likely want to share it with others,
embed it within platforms like Microsoft Teams, and monitor its usage.
All these facets will be covered in detail within this module.
- Canvas Apps Configuration
- Canvas App Responsiveness
- Saving, Sharing and Publishing Apps
- Sharing and Permissions
- Embed a Canvas App in a SharePoint Page & Microsoft Teams
- Canvas App Analytics & Monitoring
- LAB - Publishing and Sharing a Canvas App
PART 3 - Power Automate
Introduction to Power Automate
Power Automate enables the creation of automated business processes, referred to as flows.
These processes can be initiated automatically, by a button click or on a scheduled base.
We harness contextual information from these triggers to execute one or more actions,
seamlessly connecting to a variety of data sources such as Outlook, SharePoint, Twitter, Dynamics 365, and more.
- Power Automate Overview
- Power Automate Building Blocks
- Using Connections in Flows
- The Power Automate Mobile App
Building Basic Flows
In this module, you will learn how to construct and customize flows.
This involves starting from a template or building them from the ground up.
You will learn how to incorporate and fine-tune actions, oversee connections, and introduce conditions within flows.
You will explore the utilization of connectors such as Teams, SharePoint, Exchange, and others.
- Building Flows from Scratch
- Automated, Instant & Scheduled Flows
- Flow Actions & Connections
- Flow Conditions and Dynamic Content
- Monitoring Flows
- Microsoft 365 Integration
- LAB - Building Flows to Synchronize Files
Popular Connections and Actions
This chapter will furnish you with an overview of engaging connectors and utilities that you can leverage with Power Automate.
- List Data and Document Management in SharePoint
- File management in OneDrive
- File manipulation in Word and Excel
- User and Group Manipulation in Office 365 and Azure AD
- Data Management in Relational Databases
Modern Approvals with Power Automate
This module will demonstrate how to perform content approvals using Power Automate.
Approvals can be employed for various tasks, such as publishing SharePoint documents, planning Teams-meetings, or finally obtaining approval for a well-deserved vacation.
- Configuring Approvals with Power Automate
- Approval Settings
- Approving and Rejecting Approvals
- Processing the Approval Outcome
- LAB - Approval Flow for Holiday Requests
Power Automate Patterns
Armed with fundamental Flow knowledge and available coding skills, we can elevate the sophistication of our Flows.
This chapter will present practical scenarios and advanced patterns that can be applied during the design of your Flow.
- Advanced Trigger and Action Configurations
- HTTP Actions to call APIs or other Flows
- Variables, Collections and Data operations
- Conditions, Parallelism and Loops
- Flow Error Handling
- Flow and Connector Limitations
Workflow Definition Language
You can construct impressive flows through the user interface of Microsoft Power Automate.
This interface is constructed on the foundation of the Workflow Definition Language.
In this module, we will cover the fundamentals of this language and delve into various possibilities for enhancing flows using it.
- Introduction to the Workflow Definition Language
- Expressions, Operators and Functions
- Using Expressions in Flows
- LAB - Using Patterns and the Workflow Definition Language
Flow Permissions & Sharing
In this module, you will discover best practices for sharing and permissions related to Flows created within your company.
You will gain an understanding of the impact of sharing and the various available sharing permissions.
- Sharing a Flow
- Flow Permissions
- Shared Flow Connections & Credentials
- Run only users and Connections
PART 4 - Power Platform Integrations
SharePoint Form Customization
SharePoint is frequently employed as a data source within organizations. Similar to how InfoPath was utilized
for customizing SharePoint forms on SharePoint Server, Power Apps Canvas Apps serve the same role in SharePoint Online.
This chapter will guide you through the process of customizing forms for SharePoint lists or libraries.
- Customizing a SharePoint Form
- SharePoint Integration Control
- Differentiate your Form based on the mode: view, edit, new
- Adding Behaviour with Controls
- Wide screen SharePoint Forms
- LAB - Customizing a SharePoint List Form
Power Platform Integrations
Power Apps and Power Automate are distinct products, yet they can also be seamlessly integrated with each other.
This module will demonstrate how you can utilize Flows to enhance your Power Apps and vice versa.
- Bundling Apps and Flows in Solutions
- Trigger a Flow from a Canvas App
- Open a Canvas App from a Flow Notification
- Power BI & Power Virtual Agent Integrations
- LAB - Combining a Canvas App with a Power Automate Flow