Microsoft Power Apps
Data Analytics
COURSE OVERVIEW
Students will be taught how to design, test, and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their businesses.
Duration: 2 days / 16 hours
Delivery Method: Classroom-based, Virtual Instructor Led Training
AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO:
· Understand when to use PowerApps
· Describe the components of PowerApps and their correct use
· Create PowerApps from existing data sources
· Brand PowerApps
· Customize PowerApps 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 PowerApps with other Office 365 systems – including Teams and SharePoint Online
· Administer and Maintain PowerApps
COURSE OUTLINE
MODULE 1 - AN INTRODUCTION TO POWERAPPS
· What is PowerApps?
· The benefits of apps
· How to get PowerApps
· Canvas Apps and Model-Driven Apps
· License Options and Costs
· Discover PowerApps with Templates
MODULE 2 - GETTING STARTED WITH POWERAPPS
· 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
· PowerApps Mobile App
MODULE 3 - BRANDING AND MEDIA
· Less is more
· Duplicate Screens
· Fonts
· Screen Colours and Matching Colours
· Screen Backgrounds
· Buttons and Icons
· Hide on Timer
· Size and Alignment by reference
· Show and Hide on Timer
MOUDLE 4 - POWERAPPS 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
MODULE 5 - 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
MODULE 6 - 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
MODULE 7 - POWERAPP INTEGRATION
· Embed PowerApps in Teams
· Embed PowerApps in SharePoint Online
· Start a Flow from a PowerApp
MODULE 8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS
· Identify which users have been using PowerApps
· Reuse an app in another location (move from testing or development to production)
· Review app usage
· Prevent a user from using PowerApps
· Manage environments
REGISTER NOW