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.

Check out the video below for an overview of the course!


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 my 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

    • Companion Guide: Building a standalone PowerApps App with SharePoint as a data source

    • 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

  • $30.00 / month

    $30.00 / monthPower Apps and Power Automate for SharePoint and Curated Library

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

    $300.00 / yearPower Apps and Power Automate for SharePoint and Curated Library

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

Check out what our students are saying!

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

Interesting, complete and well explained

Yann mercier-savignoni

thanks for the course

thanks for the course

Read Less
star rating

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

  • $150.00 first payment, $40.00 / month onwards

    $150.00 first payment, $40.00 / month onwardsPower Apps and Power Automate for App Builders and Curated

    Buy Now