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

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

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/

Purchase the Course

Other Courses Available

  • $600.00

    $600.00Power Apps and Flow for App Builders

    Buy Now