Microsoft Power Apps Super User (55265)
Welcome to the Microsoft Power Apps Super User course, designed especially for companies seeking to empower their employees with the ability to create efficient, customizable business applications. Whether you're an individual aiming to enhance your skills or part of a team developing internal applications, this course provides the tools and knowledge to succeed with Power Apps. Discover how Power Apps can transform the way you manage data and workflows in your organization.
We kick off with An Introduction to Power Apps, where you'll learn to build a new app directly from a data source. You'll add, edit, and remove controls, explore basic formulas, and understand the nuances of testing, publishing, and sharing your apps. This section also covers app settings, version history, and even utilising the Power Apps mobile app for on-the-go accessibility. The hands-on lab will guide you through getting started, creating an app from an existing data source, publishing and sharing your creation, and viewing it on a mobile device.
In the Branding and Media lesson, we'll explore strategies for improving your app's visual appeal. Learn why less is often more when it comes to design, and master techniques for duplicating screens, choosing fonts, and matching colors. Practical exercises include setting screen backgrounds, utilizing buttons and icons, and controlling visibility through timers. A comprehensive lab will ensure you understand how to import class data from Excel, work with backgrounds and icons, and duplicate screens effectively.
The next section on Power Apps Controls covers a variety of interface elements essential for data entry and display. You'll use text controls, dropdowns, combo boxes, date pickers, radio buttons, and more. Learn to add and edit data swiftly through forms and visualize data using charts like pie, line, and bar charts. A lab session will walk you through building apps from scratch, adding controls, and implementing formulas for interaction.
Moving on to Data Sources and Logic, you'll explore data storage options and services, and learn how to select the right database for your needs. Gain proficiency in connecting to on-premises data via gateways, and understand delegation for efficient data handling. Use live examples to display data, such as connecting a SharePoint list to an app or using Flow to collect tweets. A dedicated lab experience will help you solidify these concepts with exercises like displaying tweets and creating a reply screen in Power Apps.
Explore the potential of Model-Driven Apps, beginning with an introduction to what model-driven apps are and data storage options. Learn to create model-driven apps and understand their differences from canvas apps. This section includes navigating and editing sample apps in model-driven mode, giving you practical experience through a hands-on lab.
The Power App Integration lesson is your gateway to embedding Power Apps in platforms like Teams and SharePoint Online. Learn to initiate Flows from within a Power App, enhancing your applications' functionality and connectivity. The integration lab will provide a step-by-step guide to embedding your apps seamlessly within Microsoft Teams and SharePoint Online, expanding their reach and utility.
Finally, in Administration and Maintenance of Power Apps, you'll discover strategies for managing and maintaining your apps effectively. Learn to identify app users, move apps from testing to production, review usage statistics, and manage environments. Exercises in this section include exporting an app for use in another location and managing user access within your test environment.
By the end of this course, you'll be equipped with the skills needed to harness the full potential of Power Apps, enabling you to build robust business applications that enhance your organization’s efficiency and data management capabilities. You'll be prepared to integrate Power Apps into your company’s digital infrastructure and elevate your team's workflow processes to new heights.
- Understand when to use Power Apps.
- Describe the components of Power Apps and their correct use.
- Create Power Apps from existing data sources.
- Brand Power Apps.
- Customize Power Apps beyond just using the automated wizards.
- Connect to a range of data sources from Excel to Azure SQL.
- Understand the difference between canvas apps and model-driven apps.
- Integrate Power Apps with other Office 365 systems – including Teams and SharePoint Online.
- Administer and Maintain Power Apps.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
- An Introduction to Power Apps
- Building a new app from a data source
- Add, edit and remove controls
- Intro to Formulas
- Testing an app
- App Settings
- Publish and Share Apps
- Version History and Restore
- Power Apps Mobile App
- Lab 1: Getting Started
- Create App from an existing Data Source
- Publish and Share
- View an app on your mobile device
- Branding and Media
- Less is more
- Duplicate Screens
- Fonts
- Screen Colors and Matching Colors
- Screen Backgrounds
- Buttons and Icons
- Hide on Timer
- Size and Alignment by reference
- Show and Hide on Timer
- Lab 1: Branding and Media
- Backgrounds and icons
- Import Class Data from Excel
- Duplicate Screen
- Power Apps Controls
- Text Controls for Data Entry and Display
- Controls – Drop downs, combo box, date picker, radio button and more
- Forms – Add and edit data in underlying data sources quickly
- Charts – present information in pie, line and bar charts
- Lab 1: Build Apps from Blank
- Create an App from the blank template
- Add Controls to collect and display data
- Add Formulas to allow the controls to interact
- Data Sources and Logic
- Data Storage and Services
- How do I decide which database to use?
- Connect to on-premises data - Gateway
- What is Delegation?
- Specific Data Examples
- Displaying Data
- Lab 1: Data Source and Logic
- SharePoint List connect to App
- Flow to collect tweets to SharePoint
- Display Tweets in Power Apps using the Twitter service
- Create a reply screen in Power Apps
- Model-Driven Apps
- What is a model-driven app?
- Where will my data be stored?
- How do create a model-driven app
- Canvas vs model-driven summary
- Lab 1: Model-Driven App
- Switch to Model-Driven mode in Power Apps
- Navigate the Model-Drive app interface
- Test a Sample App
- Edit the Sample App
- Power App Integration
- Embed Power Apps in Teams
- Embed Power Apps in SharePoint Online
- Start a Flow from a Power App
- Lab 1: Power App Integration
- Embed your app in Microsoft Teams
- Embed your app in SharePoint Online
- Administration and Maintenance of Power Apps
- Identify which users have been using Power Apps
- Reuse an app in another location (move from testing or development to production)
- Review app usage
- Prevent a user from using Power Apps
- Manage environments
- Lab 1: Administration and Maintenance
- Export an app for use in another location
- Review current Power App users in your test environment
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Power Platform class:
- No previous experience of Power Apps is required.
Live Public Class
$1,190.00 / student
Live Private Class
- Private Class for your Team
- Live training
- Online or On-location
- Customizable
- Expert Instructors