Join Us!

Don't miss this rare opportunity to take this course live!

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course Includes

  • 12 hours of live training via Teams!

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

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

  • A monthly invitation (6 months) to "Office Hours" where Shane and other PowerApps911 consultants answer questions and talk shop

  • 6 months of access to the curated library where you can view Shane's entire library of videos. Over 100 videos and full working app downloads for many videos.

  • 6 months of access to the recording of this course + previous recordings + the current on demand modules

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


Course curriculum

  • 1

    Course Overview

    • Course Information

  • 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

    • 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

    • Managing and removing the customized form

  • 4

    Building a standalone PowerApps App with SharePoint as a data source

    • 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

    • 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

  • 10

    Build your first Power BI from SharePoint data

    • Getting started with Power BI

    • Connecting to and manipulating SharePoint Data

    • Create a Power BI Report with visuals

    • Share your report

Pricing Options

  • $750.00

    $750.00Power Apps And Power Automate For Share Point - Live Bundle

    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/