About this class

Audience: Microsoft 365 & SharePoint Power Users, InfoPath designers, Access Web App designers, form creators

Course description

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 Power Apps provides the latest cutting edge method for creating solutions ranging from simple custom forms to full applications.  In this advanced class, you will obtain the skills necessary for implementing Power Apps canvas apps, to increase your organization's productivity.  


Module 1: Getting Familiar with Power Apps

In this introductory module, the Power Apps 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 Power Apps. You will learn the differences between canvas apps and model-driven apps, and standalone versus customized list forms.  Concepts and terminology will also be discussed to lay the foundation for advanced topics.
Topics: Examples, Possibilities, End user experience, types of Power Apps, app creation


Module 2: The Design Surface

The next step for developing Power Apps 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.  You will also learn about error checking and testing methods.
Topics: Tabs, property panel, data panel, rules panel, screen panel, screen layouts, naming conventions for controls, app checker, monitor.


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 and their syntax.
Topics: Formulas, enumerations, functions, logic, signals and named operators, 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 data structure and 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 and email connections are covered in detail and demonstrated. You will learn how to obtain data about the logged in user, such as their email address and Department, and how to send email directly from Power Apps without the need for flow.
Topics: data sources, data connections, and the difference between the two; connecting to data; intro to the Common Data Service, email, user data


Module 5: Forms and Lists

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.  You will learn about form properties and modes, how to submit forms, how to edit or view existing data, and set up form validation. Then, form logic is covered in detail, with examples of showing and hiding fields per conditions, and even changing the mode or validation of controls per conditions.
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, form logic.


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, collections and logic based functions that allows the creation of an efficient and user friendly application.  You will also learn in detail, how to pass a query string parameter to Power Apps.  In this module, we also go into detail about the properties and functionalities of various types of controls, such as text boxes, combo boxes, sliders, and more.
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 Power Apps. 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.  You will learn about repeating tables (parent/child lists) and how to set this up in Power Apps.
Topics: customizing list forms, SharePoint data structure, complex fields, parent-child relationships in forms, delegation, and collecting / 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.  Learn about color options, menus and navigation inside the app, how to create responsive apps, and even build animations.  Media controls, the camera control, and working with photo attachments will also be covered.
Topics: visual properties, color selecting, creating a standard menu across screens, animations, charts, and media controls.


Module 9: Publishing / Packaging / Printing

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 share and present Power Apps to end users in your organization. We will discuss publishing options, settings, versioning, and restrictions. Then, we will cover the central administration of Power Apps, such as managing the owner and user roles. The topics of analytics and environments will also be discussed.  You will also learn how to publish Power Apps directly to Microsoft Teams, and how to set up print capabilities, so that end users can print from the app. The concept of Power Apps reusable Components will also be taught and demonstrated, as well as how to test and monitor app performance.
Topics: App collaboration, sharing with end-users, app settings, versioning, analytics, PowerApps admin, components, testing, printing, and packaging & deploying.


Power Apps with Power Automate

This last module exists in both the Power Apps and Power Automate advanced courses.  Since it covers the integration of the two, it is duplicated across them.  In this module, learn how to create a button in a Power App to trigger a flow, and how to create parameters in the flow that retrieve data from the Power App.  We also cover how to set the flow up to send data back to the Power App after the button is pushed.

Course details

    1. Agenda

    1. Getting familiar with Power Apps

    2. Intro Demo 1

    3. Intro Demo 2

    4. End User Experience

    5. Demo: End User Experience

    6. Types of Power Apps, Create Standalone

    7. Demo: Creating an App

    8. Interactive: Create an app

    9. Advanced Power Apps Quiz

    10. Resources

    1. Getting familiar with the interface

    2. Screen Layouts

    3. Demo: Getting around the design interface

    4. Changing Control Properties & Naming Conventions

    5. Demo: Control Properties

    6. App Checker & Developer Notes

    7. Advanced Power Apps Quiz

    8. Resources

    1. Introduction to Formulas and Functions

    2. Demo: Formulas

    3. Function Basics & Structure

    4. Demo: Calculations & Referencing Properties

    5. Search in the App

    6. Syntax and Functions that Format

    7. App Properties, StartScreen, OnStart

    8. Demo: Screen Properties

    9. Advanced Power Apps Quiz

    10. Demo: Lab 1

    11. Power Apps Lab 1 - IW Mentor

    12. Resources

    1. Data Source Basics

    2. Demo: Connections

    3. Connect to Excel

    4. Connect to SharePoint

    5. Data Source Functions and Emails

    6. Demo: Sending Email

    7. Office 365 Users

    8. Other Data Sources

    9. Advanced Power Apps Quiz

    10. Resources

    11. Supplemental Deep Dive Video

    1. Introduction to Forms

    2. Demo: Create a Form

    3. Form Sections

    4. Advanced Cards

    5. Form Logic

    6. Demo: Arrange Rows & Columns in Forms

    7. Submitting Forms

    8. Introduction to Galleries

    9. Demo: Creating a Gallery

    10. Demo: Filtering Galleries

    11. Demo: Sort Gallery

    12. Demo: Searching Galleries

    13. Demo: Combining Gallery Functions

    14. Gallery Templates and Data Tables

    15. Demo: Data Table

    16. Fun with Galleries & Ideas

    17. Demo: New/Edit/Display Forms

    18. Conditional Formatting

    19. Demo: Hide/Show Form Fields Conditionally

    20. Demo: Required Fields Based on Condition

    21. Demo: Conditionally Disabled Field

    22. Advanced Power Apps Quiz

    23. Demo: Lab 2

    24. Power Apps Lab 2 - IW Mentor

    25. Lab 2 Excel File

    26. Resources

    27. Supplemental Deep Dive Videos

About this course

  • 145 lessons
  • 12 hours of video content

What you get

This is a list of everything that you get when you purchase this class

  • Video training content

  • Class lab files to work through

  • A recording of the class available to you any time

  • Quizzes along the way

  • A completion certificate

  • Earn coins to spend in our point store

Pricing

Discover Unlimited Learning with Our Ultimate Plan! Access all our courses under one comprehensive plan. Please note: This course is exclusively available as part of the Ultimate Plan and is not sold individually.

Compare subscription plans

Take a look at this chart, to find the plan for you.

Reviews of this class

What did people think of this class?

5 star rating

Great knowledge-gathering!

Phill Harris

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
5 star rating

Student165 Response

Becky Wheeler

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
5 star rating

In Depth Exploration of All Key Power Apps Functionality

William Cooper

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
5 star rating

Great class!!!

Ed Annack

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
5 star rating

great course

Verena Pailer

Thanks Laura and the whole iMentor Team, for this awesome Course, i learned so much and it is definitely one of the best way to learn and understand how po...

Read More

Thanks Laura and the whole iMentor Team, for this awesome Course, i learned so much and it is definitely one of the best way to learn and understand how powerapps works and which solutions you can build with it.

Read Less
5 star rating

Best PowerApps class out there

David Hock

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
5 star rating

I wish I had taken it earlier!

Alexis Bruno

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
5 star rating

Big Picture and even little details.

Rich Mariner

In the end it will be the little details that set your work apart from someone else. Laura does an excellent job of driving those points home.

In the end it will be the little details that set your work apart from someone else. Laura does an excellent job of driving those points home.

Read Less
5 star rating

PowerApps

Shila Nagarsenker

Excellent! Very thorough and clear instruction with specific examples. Thank you so much!

Excellent! Very thorough and clear instruction with specific examples. Thank you so much!

Read Less
5 star rating

Comprehensive and thorough training with useable demonstr...

Jack Soriano

I have been referring to IWMentor for training for myself and my coworkers for years now. I find these trainings to be more in depth and have better real-lif...

Read More

I have been referring to IWMentor for training for myself and my coworkers for years now. I find these trainings to be more in depth and have better real-life examples than I get from Plural's site. Thank you for helping me make the most of the my training time.

Read Less
5 star rating

Power Apps Advanced Training

Yohannes Giday

Thank you so much Laura for the training. It was amazing. Instructions are very clear, easy to follow up and intuitive.

Thank you so much Laura for the training. It was amazing. Instructions are very clear, easy to follow up and intuitive.

Read Less
5 star rating

Super In depth

Gela Ghaderi

Extremely In depth course overall, but I love how well she taught it. And you can tell how much she enjoys teaching about SharePoint. Has been a wonderful le...

Read More

Extremely In depth course overall, but I love how well she taught it. And you can tell how much she enjoys teaching about SharePoint. Has been a wonderful learning experience so far.

Read Less

Your Instructor

Microsoft MVP Laura Rogers

Laura Rogers is a SharePoint, Teams, Power Apps & Power Automate expert, speaker, author and educator. She is well-versed in helping organizations make the most of their SharePoint business processes using Power Apps and Power Automate flows. Laura’s technical expertise also includes over 20 years of experience working with Microsoft’s messaging and collaboration systems. She has been named a Microsoft Most Valuable Professional (MVP) for the past fourteen years. She has contributed to several books on SharePoint over the past eleven years. You can read more about Laura’s experiences on her blog, www.wonderlaura.com, and follow her on X: @WonderLaura