PowerApps911

Day 1 Morning

Day 1 Afternoon

Day 2 Morning

Day 2 Afternoon

Day 3 Morning

Day 3 Afternoon - PBI

Excel file of Doggie Data

What is PowerApps

Going Deeper on 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

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

What is Power Automate

Demo of some cool Power Automate flows

SharePoint Built-In Power Automate Capabilities

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

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

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

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

Getting started with Power BI

Connecting to and manipulating SharePoint Data

Create a Power BI Report with visuals

Share your report