Course Includes

  • Over 7 hours of video content and a 59 page companion guide

  • Includes connections to Outlook, OneDrive, Teams, and Power BI

  • Download of the apps and flows we build in the class

  • All enrolled students get access to the monthly "Office Hours" session

  • Active subscriptions include access to the Curated Video Library.

  • Keep access to the course as long as you want. $39 per month. Cancel anytime.

Course curriculum

  • 1

    Course Overview

    • Quick Introduction

  • 2

    What is PowerApps and how does it work with SharePoint

    • What is PowerApps

    • Going Deeper on PowerApps

  • 3

    Customizing SharePoint List Forms with PowerApps

    • Review the SharePoint list

    • Customize your first SharePoint list form

    • SharePoint Lookup Columns

    • Send an email with a link to the SharePoint item

    • Combo boxes, Office 365 Users, and pop-ups

    • Add Power BI to your app

    • Dynamically setting default values

    • Managing and removing the customized form

  • 4

    Building a standalone PowerApps App with SharePoint as a data source

    • Introduction and Demo

    • Setting up SharePoint

    • Start with a Blank app

    • Add a Gallery control

    • Add a Form control

    • Create lookup column like functionality

    • Add lite branding and screen duplication

    • Errors, filtering, distinct, and sort

    • Create a dynamic welcome screen

    • Additional data sources, performance, and email

    • Create parent and child lists

    • The patch function

    • Using Collections

    • Deleting and Summing data

    • The ForAll function

    • Display related data

    • Use the Yes/No column

    • Save and Publish your app

    • Securing the SharePoint list

  • 5

    What is Power Automate and how does it work with SharePoint

    • What is Power Automate

    • Demo of some cool Power Automate flows

    • SharePoint Built-In Power Automate Capabilities

  • 6

    Build a flow to approve and log your SharePoint content

    • Turn on SharePoint approvals and create the new lists

    • Get the approvers and ask them for approval

    • Evaluate and take action on the Approval by saving back to SharePoint

  • 7

    Build a Flow to import a File, create items, post to Teams, and error checking

    • Create the SharePoint list by importing an Excel file

    • Select an Excel file in SharePoint and import into Flow and get the tables and rows

    • Create SharePoint list items from the imported data

    • Add an input, use variables to compute summary data, and post it to Teams

    • Notify the user when they have errors and how to correct them

  • 8

    Connect Power Apps and Flow to make a PDF of your SharePoint data

    • Create the flow and connect it to your app

    • Add dynamic SharePoint data to your PDF using Concat

    • Return the SharePoint link from flow to your app

  • 9

    Additional Content

    • Companion Guide: Customize SharePoint List - Updated July 2021

    • Companion Guide: Building a standalone PowerApps App with SharePoint as a data source - Updated July 2021

    • Clickable links from the course

    • PDF: Import the Customer SharePoint App

    • Video: Import the Customer SharePoint App

    • Download the example Flows

    • Companion Guides for recreating the flows - Coming soon

Pricing Options

  • $39.00 / month

    $39.00 / monthPower Platform for SharePoint 201 Bundle

    Includes access to Curated Video Library and Monthly Office Hours.
    Buy Now
  • $429.00 / year

    $429.00 / yearPower Platform for SharePoint 201 Bundle

    Includes access to Curated Video Library and Monthly Office Hours.
    Buy Now

Check out what our students are saying!

5 star rating

Building Power Apps for SharePoint

Sabra Curry

Awesome class. All the core skills one needs to start building their own stand alone applications. Thanks Shane!!

Awesome class. All the core skills one needs to start building their own stand alone applications. Thanks Shane!!

Read Less
5 star rating

Interesting, complete and well explained

Yann mercier-savignoni

thanks for the course

thanks for the course

Read Less
5 star rating

Shane is unbelievable!

Daniel Rumbak

Thank you Shane for addressing so many burning questions I've had for ages. You don't just deal with the technical side but also best practices and understan...

Read More

Thank you Shane for addressing so many burning questions I've had for ages. You don't just deal with the technical side but also best practices and understanding the appropriate use cases for the different tools in the power platform. This course is worth it's weight in gold.

Read Less
5 star rating

Power Apps and Power Automate for SharePoint

Daniel Dugas

In all training I took on PowerApps this is the best one so far

In all training I took on PowerApps this is the best one so far

Read Less
5 star rating

Awesome!

Pam Buckner

Shane is an wonderful instructor. He makes learning fun and can bring his knowledge down to a beginner level.

Shane is an wonderful instructor. He makes learning fun and can bring his knowledge down to a beginner level.

Read Less
5 star rating

Just started Power Apps and Power Automate for SP

Thomas Allan

Just started, however have worked through two other courses with Shane. Always learn a lot of practical stuff; always a lot of fun in the process..

Just started, however have worked through two other courses with Shane. Always learn a lot of practical stuff; always a lot of fun in the process..

Read Less

Meet your instructor

Shane Young

Shane Young has been a Microsoft MVP for the past 15 years and was named one of the first PowerApps and Flow MVPs. Microsoft has awarded him this for his work speaking at major conferences on their behalf, contributions to their training and documentation, and for his YouTube channel that has almost 38 million minutes of watch time for teaching people Microsoft technologies. He uses his strong relationship with the PowerApps and Flow product teams at Microsoft to provide his clients the best, most up-to-date information, and techniques for their apps. Shane has consulted on apps across the globe, with Antarctica the only continent not covered. So if you know anyone who needs a polar bear app, please let him know. When Shane is not teaching or consulting, you can find him chasing his very active children all over the city of Cincinnati. LinkedIn Bio: https://www.linkedin.com/in/cincyshane/

Other Courses Available

  • $49.00 / month

    $49.00 / monthPower Apps and Power Automate 201 Bundle

    Buy Now