Are you a SharePoint Power User or form and workflow creator? Maybe you are looking to upgrade your skill level to the newest Microsoft technologies? Microsoft's PowerApps provides the latest cutting edge method for creating solutions ranging from simple custom forms to full applications. In this four day class, you will obtain the skills necessary for implementing PowerApps, to increase your organization's productivity.
This is a recording of our live class that we taught in April, 2019.
Audience: Office 365 & SharePoint Power Users, InfoPath designers, Access Web App designers, form creators
Module 1: Getting Familiar with PowerApps
In this introductory module, the PowerApps design interface will be demonstrated and explained. This will familiarize you with the basics of navigating the interface and aid in finding the tools necessary to create successful PowerApps. Concepts and terminology will also be discussed to lay the foundation for advanced topics.
Module 2: The Design Surface
The next step for developing PowerApps is the fundamental understanding of the various concepts in the canvas itself. Screens, controls, galleries and associated properties with each, will be taught. The knowledge from this module will allow us to begin shaping the user interface of the PowerApp. There are different types of PowerApps that will be demonstrated as well, such as a full app versus the quick customization of a SharePoint list form.
Topics: Tabs, property panel, data panel, rules panel, screen panel, naming conventions for controls, and the app checker.
Module 3: Functions
Creating controls such as labels, input boxes, or buttons is necessary for user interaction, however, the functions behind these controls is where we are able to add productivity to our business. Functions are the pivotal tool that allows your PowerApps to be brought to life. This module will introduce the fundamental principles of functions.
Topics: Formulas, enumerations, functions, logic, signals and named operators, and syntax tips.
Module 4: Data sources / Connections
In this module, we will begin by discussing the fundamentals of data connections and the avenues available in PowerApps. The foundational concepts of viewing the data within PowerApps will also be discussed, as well as several common types of data connections in Office 365. Specifically, SharePoint, Excel, OneDrive, and Planner. User data, approvals, and email connections are covered in detail and demonstrated.
Topics: data sources, data connections, and the difference between the two; connecting to data; intro to the Common Data Service
Module 5: Lists and Forms
Now that we have the capability of adding data sources, we will delve into the topics of viewing, filtering, creating, and editing data using galleries, tables, and forms. This module then advances into methods of passing values (aka: parameters) across controls such as cards, buttons, for advanced form logic upon submission.
Topics: Gallery properties, filtering/searching/sorting galleries, gallery templates, tables versus galleries, form properties, advanced functionality of cards, connecting galleries to forms, and form functions.
Module 6: Dynamic Controls and Variables
For an application to deliver increased efficiency to a user, it must possess the ability to dynamically change based on the user's input. This module will discuss the advanced use of variables and logic based functions that allows the creation of an efficient and user friendly application. The concept of PowerApps "Components" will also be taught and demonstrated.
Topics: collections, global variables, context variables, deep dive into controls, advanced functions, and using query string URLs for passing parameters, components
Module 7: Advanced SharePoint Functionality
Business requirements for solutions often become fairly complex, and form logic/rules becomes a necessity. This module starts with how to customize SharePoint list forms with PowerApps, then will dive into the depths of understanding SharePoint data as it pertains to PowerApps. This includes lookups, choice fields, people fields, and their advanced usage when implementing automation. Advanced data submission, outside of forms (patching), will be covered in detail.
Topics: customizing list forms, SharePoint data structure, complex fields, parent-child relationships in forms, and collecting and patching data.
Module 8: Curb Appeal
Once we have created the innerworkings of a PowerApp, we are faced with daunting task of visual appeal. This module will present concepts, tips, and tricks around branding your PowerApp. Apps that are professional looking and polished will help to increase user adoption.
Topics: visual properties, color selecting, creating a standard menu across screens, animations, charts, and media controls.
Module 9: Publishing
Now that it's ready to go live, how do you deliver it to the intended audience? In this module, you will learn how to present PowerApps to end users in your organization. We will discuss publishing options, settings, and restrictions. Then, we will cover the central administration of PowerApps, such as managing the owner and user roles. The topics of analytics and environments will also be discussed.
Topics: App collaboration, sharing with end users, app settings, versioning, analytics, PowerApps admin, and packaging & deploying.
- Agenda FREE PREVIEW
- IW Mentor - PowerApps Training Class
- Getting familiar with the interface
- Screen templates
- Changing Control Properties & Naming Conventions
- Module 2 Quiz
- Introduction to Formulas and Functions FREE PREVIEW
- Signals and Operators
- Syntax and Functions that Format
- Module 3 Quiz
- Demo: Lab 1
- IW Mentor - PowerApps Lab 1
- Data Source Basics FREE PREVIEW
- Connecting to Excel and SharePoint
- Data Source Functions and Emails
- Demo: Sending Email
- Office 365 Users
- Other Data Sources
- Module 4 Quiz
- Introduction to Galleries, Filtering, Sorting, Searching
- Combining Gallery Functions
- Gallery Templates and Data Tables
- Introduction to Forms
- Advanced Cards
- Form Logic
- Demo: Form Structure & Logic
- Submitting & Connecting to Galleries
- Module 5 Quiz
- Demo: Lab 2
- IW Mentor - PowerApps Lab 2
- Lab 2 Excel File
- Query String Parameters
- Collection with List Data
- Context Variables
- Advanced Controls and Functions
- ForAll Function
- Module 6 Quiz
- Demo: Lab 3
- IW Mentor - PowerApps Lab 3
- Customize SharePoint List Forms
- SharePoint List Fields in PowerApps
- Complex Fields - Lookups and People Pickers
- Complex Fields - Choice & Managed Metadata
- Parent Child Lists (Repeating Tables)
- Demo: Patch - Create list item
- Demo: Patch - Edit list item
- Demo: Patch - Person column
- Demo: Patch - Bulk Updates
- Module 7 Quiz
- Demo: Lab 4
- IW Mentor - PowerApps Lab 4
- Visual Properties
- Color, Size, and Location of a Control
- Standardizing Menus
- Setting Standards for Controls and Colors
- Media Controls
- Module 8 Quiz
- Sharing, Settings, Versions
- PowerApps Admin
- Packaging Apps
- Module 9 Quiz
- IW Mentor - PowerApps Lab 5
- IW Mentor - PowerApps Lab 5 BlueGradient File
~12 hours of training content
Class lab files to work through
A recording of the class available to you for one month
Quizzes along the way
A completion certificate
Laura is such an easy-going instructor and obviously knows the material---despite MS changing the interface on her in the middle of the class! I appreciate t...Read More
Laura is such an easy-going instructor and obviously knows the material---despite MS changing the interface on her in the middle of the class! I appreciate that she has extensive real-world usage and examples of PowerApps features. The agenda was very useful, although Day 3 could've used some time for hands-on exercises to make the material sink in. The labs were well done, but future classes might want to include app "solutions" that we can consult to make sure we were on the right track. I love that we can refer to the class recordings and, of course, her extensive "PowerHour" videos are amazing. I look forward to updates and new training as the product evolves. If I had a criticism, it's that the participants were a little on the "chatty" side. Although most of what was typed was useful info, it at times disrupted the flow of the session.Read Less
I thoroughly enjoyed taking this class offered by iwMentor. It helped that I had developed an app or two as that helps you become acquainted with the softwa...Read More
I thoroughly enjoyed taking this class offered by iwMentor. It helped that I had developed an app or two as that helps you become acquainted with the software (regardless of product). Laura was enthusiastic, explained things very well as well as wiling to answer questions immediately and kudos to Chris as well. I'm sure I'll be taking another course here. Regards, Stephanie NormanRead Less
Laura (and Chris), thank you for providing this course. For me, challenging, but worth the effort and knowledge in understanding these buildouts in PowerApps...Read More
Laura (and Chris), thank you for providing this course. For me, challenging, but worth the effort and knowledge in understanding these buildouts in PowerApps. I would highly recommend the course to those looking to further understand MS 365 apps and the solutions that come with it!Read Less
This training course is a great way to dive into the world of PowerApps development. I have no doubt that I would have struggled to learn all these concepts ...Read More
This training course is a great way to dive into the world of PowerApps development. I have no doubt that I would have struggled to learn all these concepts if I had not taken this class. I feel well equipped to build my first real world PowerApp application for my O365 customer. I would STRONGLY recommend this course to anyone who wants an in depth understanding how to build solutions with PowerApps. Laura, Chris and Joelle make a great team and I really appreciate their efforts to put together this valuable course.Read Less
Was very well thought out and there was alot of usefull information.
Was very well thought out and there was alot of usefull information.Read Less
Awesome class! Informative and fun.
Awesome class! Informative and fun.Read Less
The class was very informative and presented well. The homework was well though out and documented, however, for me, the homework was not presented in a styl...Read More
The class was very informative and presented well. The homework was well though out and documented, however, for me, the homework was not presented in a style I learn with very well. I would have liked to have an overview of what I needed to accomplish along with some end result screen shots and been turned loose without the instructions. Or maybe provide the instructions separately in case the students get stuck.Read Less
I love how you work through problems when things are not going right. Very good at teaching troubleshooting.
I love how you work through problems when things are not going right. Very good at teaching troubleshooting.Read Less
Laura is the only Microsoft MVP I know of who is focused on PowerApps. I have not seen another 4-day class out there that is dedicated to PowerApps. She's al...Read More
Laura is the only Microsoft MVP I know of who is focused on PowerApps. I have not seen another 4-day class out there that is dedicated to PowerApps. She's also an excellent trainer. She's very down-to-earth, seems to never get frazzled, and is not intimidating even though her knowledge and ability are impressive. She's able to convey development concepts in simple, everyday language that non-IT pros can understand. I think this class is a very good value for the money, especially considering the fact that you have access to her whole training library for a year, including your account in her tenant where your lab work is stored and a very useful PowerApps knowledge base on her site.Read Less
The four days were filled with lots of useful information. Now I have to figure out how to get all the info into my own world :)
The four days were filled with lots of useful information. Now I have to figure out how to get all the info into my own world :)Read Less
This is just what I needed to start diving into PowerApps. I've been a dedicated InfoPath creator for years and have had trouble finding the time or resource...Read More
This is just what I needed to start diving into PowerApps. I've been a dedicated InfoPath creator for years and have had trouble finding the time or resources for excellent training so I don't waste a ton of time (that I don't have) trying to figure it all out. I'm so excited to start creating ALL THE APPS and getting rid of those clunky and ugly InfoPath forms. Thanks Laura and Team!Read Less