Course Overview

What is a model-driven app

What is a canvas app

What is the Dataverse (Common Data Service)

What is Power Automate

Getting setup

Introduction to section 2 - Power Apps Maker Studio

Where to find your Apps

Where to start building Apps from

How to access Power Apps maker and landing page overview

What are solutions

What are Flows

What are Tables

What are Dataflows

Wrap-up with miscellaneous features

Orientation of the left navigation

Orientation of the design area

About the formula bar

Orientation of the object properties

Wrap up of section 3

Create an simple App using an existing SharePoint list

Create a simple app using Microsoft Excel Data

Create a simple App using an existing Dataverse table

Create a simple App using Copilot

How to add screens to your app (Updated Feb 24')

Import the exercise template

Working with labels

Working with Inputs (Part 2)

Working with inputs (Part 1)

Working with buttons

Working with containers

Working with the timer control

Exploring the address input control using geospatial services

Working with Forms

Working with icons

Working with sound - Microphone and Audio Controls

Working with the Add Picture control

Working with the image control

Comparing Excel with Power Fx

How to configure the navigate function

How to invoke a Power Automate Flow from a button click

Understand the three types of variables

Filter - Setup database for filtering exercise

Filter - Write the expression to filter contacts

Filter - Using a dropdown to Filter Data

How to use the Search expression

Filter - Configure Galleries on Canvas

Delete a record

Edit an exiting record

Mapping the current user details to a record

Setting global variable within the APP Object

And, Or, Not Operators

Using the Sum expression

Using the Calendar Object

Using the ColorFade Expression

Using Concatenate to join strings

Using CountRows in a table

One click dialing

Date calculations

Download function

Creating an app with the new designer

Introduction to Model-driven Apps

Introduction to Tables

Introduction to Table Relationships

Introduction to Forms

Introduction to Datatypes

Introduction to Views

Introduction to Business Processes

Introduction to Business Rules

Introduction to columns

Setup for column exercise

Text Field

Multiline Text Column

Decimal Number

Text Area Column

Whole Number

Choice Column

Choices Column

URL Field

YesNo Option

Status & Status Reason Fields

Phone Column

Owner Field

Email Column

Image Column

Date and Time columns

Lookup Column

Introduction to forms and views

Introduction to views

Cars missing from the site map

Exploring existing View configuration

Create a SystemPublic View

Create a Personal View

Preparation for this section

Creation your first form

Creating a quick view form

Inserting data grids into forms

Creating a quick create form

Introduction to Business Rules

Setting column values

Set column requirement levels

Clearing column values

Validate data and show error messages

Lock or unlock columns

Create business recommendations

Show or hide columns

Introduction to Business Processes

Creating the Credit Application Business Process

Create the Credit Application Table

Introduction

Demo of the completed version

Create a model-driven app

Complete the model-driven app

Lunch time app - Home Screen

Creating the Menu Screen

Introduction to the Delivery App

Create a solution and required tables

Creating the confirmation screen

Creating the Order Screen

Creating the home screen

Creating the Confirm Collection page

Exporting your project

Creating the My Deliveries Page

Creating the confirm Delivery Page

Creating the Ready for Collection page

Final Solution Demontration

Setup the required tables

Create a Solution for your app

Configure the car components

Creating the required columns (Fields)

Configure the fuel purchase components

Configure the Odometer reading components

Create an real-time workflow

Assemble the Model-driver App

Create a real-time workflow part 2

Configure the buttons on the home screen

Create a real-time workflow part 3

Setting up the required screens

Configure the IncomTripList screen

Configure the Select car screen

Configure the Record New Trip screen

Configure the EditTrip screen

Configure the Car Report screen

Update on the image save error

Configure Fuel Purchase screen

Export your completed project

Finishing touches

Configure the Submit Receipt screen

Download and install the required components

Demo of the Completed Solution

Installing the base components

Setup the database - Part 1

Overview of Lucid and Miro

Setup the database - Part 2

Setup the database - Part 3

Setup the database - Part 4

Setup the database - Part 5

Configuring the form layouts - Part 2

Configuring the form layouts - Part 1

Configuring the form layouts - Part 3

Configuring the table views

Creating the Admin Application

Creating sample data for our APP

Purchase Order & Order Products Automation

Automatic creation of Items

Connecting the required data sources

Review Keypad Configuration

Configure the items gallery

Recording the items the customer purchased

Cashier & Manager Login Configuration

Configure the itemselected Gallery

Configuring the receipt

Function to cancel selected items

Loyalty Membership

Some odds and ends

Using Patch to create the receipt items

Calculating the change

Creating a receipt using Power Automate

Change item(s) status to sold

Email receipt to customer

Cancel Sale Function

Create new Loyalty Customer

Configuring the End-of-Shift report

Configuring the Cash Up total

Configuring the end-of-shift Form

Configuring the end-of-shift button

Configuring the manager PIN

Configuring the stock take functions - part 1

End-to-end test

Configuring forced rollups

Final end-to-end solution test - Part 1

Final end-to-end solution test - Part 2

Exporting your completed project

Completing the stock take functions

Providing users with access to your app

Security Roles - Business Case