The Complete Guide To Microsoft Powerapps Power Automate

Microsoft PowerApps Developer-Learn Microsoft Power Apps, Microsoft Power Automate with Power Automate Desktop & MS Flow

Last updated 2022-01-10 | 4.6

- You Will Gain a Solid Understanding of the All Fundamental & Advanced Concepts of Microsoft PowerApps.
- We Will Learn to Make a Microsoft 365 E3 Account to Use PowerApps account & Other Services.
- Become an Expert in Microsoft PowerApps & Get Valuable Preparation For Certification
- and Add the Skill to Your Resume.

What you'll learn

You Will Gain a Solid Understanding of the All Fundamental & Advanced Concepts of Microsoft PowerApps.

We Will Learn to Make a Microsoft 365 E3 Account to Use PowerApps account & Other Services.

Become an Expert in Microsoft PowerApps & Get Valuable Preparation For Certification

and Add the Skill to Your Resume.

Create Real World Functional Business Application

on the Web

Tablets

and Phones for Businesses and Organizations Using PowerApps.

Connect PowerApps to Different Sources of Data (SharePoint

OneDrive

Google Drive

SQL

Spread Sheets etc.).

Empower Yourself With PowerApps Documentation and Resolve Errors for Future Application Builds.

Leverage the Microsoft Ecosystem to Expand Your Knowledge with Developer Tools.

Learn How to use these Services to Create Business Apps and Flows Without Needing Any Development Skills.

We Will Learn PowerApps Concepts & How to Build and Run your Applications through Data Loader.

Learn how to Build Canvas Apps & Learn Important Concepts Such as Layout

Galleries

Forms

Functions

Formulas

Navigation

Screens

Variables

Filter

Lookup

We Will Learn How to Use Resources & PowerApps Formula Reference to Help You Expand Your Knowledge.

You will be empowered to create your own business apps

You can create your own business Apps without coding (Iphone & Android compatible) within minutes

Be proud of yourself! You decided to take the plunge and dive into a new topic

Automate Any Tasks With Cloud & Desktop Version of Microsoft Power Automate

Understand Flow Diagrams & Structures of Cloud and Desktop Flows

How to Set Up Free Microsoft Power Automate Account

How to Create Power Automate Flows From Scratch to Advanced with Cloud & Desktop Versions of Power Automate

How to Create an Automated Flow From a Template in Microsoft Power Automate

Learn About Five Different Types of Flows ( Instant

Automated

Scheduled

Desktop

and Business Process Flows)

Learn To Create

Execute

Manage

and Monitor All of Your Cloud and Desktop Flows

Integrate External Applications Into Your Flow Using Connectors and Using 3rd Party API / HTTP Requests

Create Advance Flows With Conditions

Loops

Approvals

User Input

and Multiple Actions

Apply Robotic Process Automation Using Desktop or Web UI Flows in Power Automate Desktop

Read Microsoft Power Automate Documentation & Resolve Errors For Future Application Builds

Use Web and Desktop Recorders To Quickly Develop Flows

Incorporate Various Types of Input

Output

and Flow Variables

Loops

Conditions

Messages and User Input in Power Automate Desktop

How to Automate Tasks Related With Excel

PDFs

Emails

Files & Folders With Power Automate Desktop

* Requirements

* No prior knowledge to PowerApps or Flow is required
* No coding skills required
* Some knowledge of Microsoft Excel Formulas
* Willingness to learn
* A Burning Desire To Learn Microsoft Power Automate Cloud & Desktop
* No Programming Skills Required - Everything Is Drag and Drop
* A Windows 10 PC With Internet Connection ( To Learn Power Automate Desktop )
* Familiarity With Microsoft Applications (Word
* Excel
* especially Excel Formulas) is desired but not required
* This course goes starts from the basic level
* so no prerequisites are required. Come hungry to learn!

Description

You Will Gain a Solid Understanding of the All Fundamental & Advanced Concepts of Microsoft PowerApps.
We Will Learn to Make a Microsoft 365 E3 Account to Use PowerApps account & Other Services.
Become an Expert in Microsoft PowerApps & Get Valuable Preparation For Certification, and Add the Skill to Your Resume.
Create Real World Functional Business Application, on the Web, Tablets, and Phones for Businesses and Organizations Using PowerApps.
Connect PowerApps to Different Sources of Data (SharePoint, OneDrive, Google Drive, SQL, Spread Sheets etc.).
Empower Yourself With PowerApps Documentation and Resolve Errors for Future Application Builds.
Leverage the Microsoft Ecosystem to Expand Your Knowledge with Developer Tools.
Learn How to use these Services to Create Business Apps and Flows Without Needing Any Development Skills.
We Will Learn PowerApps Concepts & How to Build and Run your Applications through Data Loader.
Learn how to Build Canvas Apps & Learn Important Concepts Such as Layout, Galleries, Forms, Functions, Formulas, Navigation, Screens, Variables, Filter, Lookup,
We Will Learn How to Use Resources & PowerApps Formula Reference to Help You Expand Your Knowledge.
You will be empowered to create your own business apps
You can create your own business Apps without coding (Iphone & Android compatible) within minutes
Be proud of yourself! You decided to take the plunge and dive into a new topic
Automate Any Tasks With Cloud & Desktop Version of Microsoft Power Automate
Understand Flow Diagrams & Structures of Cloud and Desktop Flows
How to Set Up Free Microsoft Power Automate Account
How to Create Power Automate Flows From Scratch to Advanced with Cloud & Desktop Versions of Power Automate
How to Create an Automated Flow From a Template in Microsoft Power Automate
Learn About Five Different Types of Flows ( Instant, Automated, Scheduled, Desktop, and Business Process Flows)
Learn To Create, Execute, Share, Manage, and Monitor All of Your Cloud and Desktop Flows
Integrate External Applications Into Your Flow Using Connectors and Using 3rd Party API / HTTP Requests
Create Advance Flows With Conditions, Loops, Approvals, User Input, and Multiple Actions
Apply Robotic Process Automation Using Desktop or Web UI Flows in Power Automate Desktop
Read Microsoft Power Automate Documentation & Resolve Errors For Future Application Builds
Use Web and Desktop Recorders To Quickly Develop Flows
Incorporate Various Types of Input, Output, and Flow Variables, Loops, Conditions, Messages and User Input in Power Automate Desktop
How to Automate Tasks Related With Excel, PDFs, Emails, Files & Folders With Power Automate Desktop

Course content

18 sections • 260 lectures

Introduction 1 lectures

How to Create Microsoft PowerApps Accounts Preview 07:32

Basic Canvas Apps: Lets Build Your First PowerApps 10 lectures

Microsoft PowerApps Dashboard Overview Preview 07:52

How to Create Your First Connection/Datasource in Microsoft PowerApps Preview 04:02

How to Create a Spreadsheet to load data from in our PowerApps Preview 07:01

App Structure And Basic Customizations In Microsoft PowerApps Preview 08:03

How to Customize Icons of Your PowerApps Preview 04:26

How to View App Preview and Test Its Functionality in PowerApps Preview 03:28

How To Change The Alignment Of Data In App Entries Preview 03:42

Basic App Settings in PowesApps Preview 03:47

How to Save Apps in Microsoft PowerApps Preview 04:46

How To Add And Modify Data To Existing App Preview 04:04

Beginner Canvas Apps: Create A Beginner PowerApps With Google SpreadSheets 9 lectures

Creating A New Screen For Your App Preview 10:41

Creating A New Flooring App Preview 07:51

Understanding Data Cards In Microsoft PowerApps Preview 08:51

Adding Home Page Icon & Associating it with a URL in our Flooring App Preview 05:20

Working With Formulas - Using Conditional Logic (IF) in our Flooring App Preview 06:55

Customizing The Background Image Of Our App Preview 03:23

Adding Ratings Control and Reviews in Flooring App Preview 05:25

Let's Make Ratings & Reviews Controls Functional Preview 05:06

How to Create A Popup Message Within Flooring App Using PowerApps Preview 05:25

Basic Canvas Apps: Creating A Basic SharePoint Based PowerApps 6 lectures

Creating an Office 365 E3 Trial Account Preview 07:49

Creating a SharePoint Site From Scratch Preview 05:40

Creating a SharePoint List Preview 07:20

Creating a Data Connection With SharePoint List Preview 03:47

Building A PowerApp Using The SharePoint List Preview 05:49

Exporting and Importing Apps Aetween Different Accounts Preview 09:38

Beginner Canvas Apps: Building A Beginner SharePoint based PowerApp 15 lectures

Introduction to Intern Selection App Preview 02:54

Uploading An Excel File On SharePoint & Converting It Into A SharePoint List Preview 06:38

Creating A Data Connection With Intern SharePoint List In PowerApp Studio Preview 05:10

Adding Missing Fields From Detail & Edit Screen Of Our App Preview 06:26

Changing The Data of Browse Screen Preview 03:19

Changing The Function Formula To Customize Our App Preview 05:04

Reordering List & Customize The Layout Preview 05:47

Changing Field Titles On Detail Screen Preview 04:46

Customizing The Edit Screen Of Our Intern App Preview 05:17

Changing The Title Of First Name Field Preview 01:44

How To Change Sorting Preference In PowerApps Preview 04:23

Lets Change Searching Preferences In PowerApps Preview 02:55

Remove Unwanted Action From Our Intern App Preview 03:50

Testing Our Final Intern App Preview 03:12

Saving Our Intern App Preview 05:06

Budget Tracker App - Creating A Power App With Template 9 lectures

Introduction to Building A PowerApp Using Template Preview 03:50

Create The Budget Tracker App & Configure Its Data Connection Preview 05:24

Lets Analyze The Datasheet Of Budget Tracker App Preview 03:17

Preview & Understand The Working Of Budget Tracker App Preview 05:20

Removing Unwanted Data Fromm DataSheet & Refreshing The Data Connections Preview 03:13

Customize The Budget Tracker App With New Data Preview 04:16

Refreshing The Data Connections & Customizing Our Budget Tracker App Preview 07:10

Changing App Icon & Background Color Preview 03:32

Final Look Of Our Budget Tracker App Preview 02:00

Intermediate Canvas Apps - Lets Build Customer App 15 lectures

Creating The Customers App Preview 05:42

Properties Of Elements - Statically Set & Dynamically Set Method Preview 12:12

Understanding Galleries & Use Of Concatenate Function Preview 08:06

Forms & Data Cards In Detail Screen Preview 07:47

How to Use Formatting Functions to Customize Date ( Text Function ) Preview 05:45

Creating A Function To Set Title Dynamically (Concatenate Function) Preview 07:24

Layout Of Edit Form In Our App & Reordering Fields Preview 04:55

Update Property Of Datacards In Edit Screen of Our PowerApps Preview 06:28

Removing Timestamps From Edit Screen & Change Display Mode Of Fields Preview 11:20

What are Triggers & How to Use Them In PowerApps Preview 08:32

Introduction To Formula Reference Of PowerApps & How To Use It Preview 09:46

Using Month & Year Functions Task Solution Preview 03:57

Navigate & Back Function In PowerApps Preview 11:12

How To Use App Checker & Fixing Errors Preview 06:28

Final View Of Our App & End Of Our Intermediate Canvas Apps Section Preview 01:53

Advanced Canvas App - Lets build An App From Scratch 24 lectures

Create Advanced Canvas App & Understanding Master Screen & Documentation Screen Preview 10:15

Customizing the theme of app & Linking with Documentation screen Preview 04:54

Adding Gallery & Connecting it with Data Source Preview 06:02

Creating Home Screen & Adding Buttons in Our App Preview 11:44

Adding Navigation Functionality To Our App Preview 06:37

Introduction To Variables In PowerApps Preview 04:43

Types Of Variables & Contextual Variables Preview 08:35

Global Variables In PowerApps Preview 03:52

Collection Variable - Syntax & Use With Gallery Preview 05:37

Making Collections Dynamic & Adding Remove Functionality In Gallery Preview 06:25

Adding Search Bar & Making it Functionality Preview 06:42

Customizing Search Bar & Linking it With Search Icon Preview 05:54

Filter Functions in PowerApps & Adding a Filter in Our App Preview 11:41

Creating The Detail Screen Using Display Form Preview 08:46

Creating The Edit Screen Using Edit Form Preview 06:55

Adding Navigation Between Detail & Edit Screens Preview 02:45

Creating The Add New Customers Screen Preview 08:55

Data Validation In PowerApps (IsMatch Function) Preview 07:59

Data Validation Using Variables In PowerApps Preview 06:58

Uploading Agents Excel File & Using it as a Data Source Preview 03:58

Creating Agent Screen & Connecting Our App With Multiple Data Source Preview 06:45

Lookup Function & Linking Data From Multiple Screens & Data Sources Preview 06:39

Adding A Call Button & Making It Functional Preview 04:24

Changing The Screen Order & Publish Our Final App Preview 03:20

Expert Canvas Apps - Learn to Use Functions & Formulas 16 lectures

User Function in PowerApps Preview 03:48

Today() And Now() Functions In PowerApps Preview 03:52

Grouping Elements In PowerApps Preview 04:13

Launch Functionality In Microsoft PowerApps Preview 04:43

Launch Function For Sending Emails & Making Phone Calls Preview 04:52

Launching Other Apps From Our Current App Using Launch Functions Preview 05:20

Cascading Dropdown in PowerApps - Use of Distinct Function & SortByColumn fxn Preview 09:36

Cascading Dropdown - Linking Location & VIPLevel Dropdowns with data table Preview 07:34

Cascading Dropdown In Power Apps - Linking Both Dropdowns With One Another Preview 05:35

Adding Remove Function To Delete Records In Our App Preview 09:34

Adding A Confirmation Popup in Our PowerApp Preview 01:03

Date Picker Input Control in PowerApps Preview 04:37

Slider Input Control In PowerApps Preview 06:02

Ratings & Timer Input Control In PowerApps Preview 10:23

ComboBox Input Control in PowerApps Preview 08:54

Toogle Input Control In PowerApps Preview 07:19

Advanced Common Data Service Apps 22 lectures

Introduction To Common Data Service Preview 03:52

Setting Up The Environment For Common Data Service Preview 03:02

Entities in Common Data Service Preview 02:59

Fields in CDS & Types of Fields Preview 02:41

Understanding Relationships In Entities Theory Preview 04:37

Relationships in Entities Practical Preview 03:19

Business Rules & Their Uses In Cds Preview 02:44

Views In Entities Preview 01:44

Forms, Dashboard, Charts, Keys And Data Preview 02:34

Creating A New Entity Preview 03:19

Adding New Fields In Customer Entity Preview 03:46

Adding A Calculated Field In Entity Preview 04:38

How To Switch Between Different Environments in PowerApps Preview 01:51

Adding Remaining Fields To Our Entity (VIP, Date Joined, Location & Others) Preview 04:09

Uploading Data From Excel File To Our Entity Preview 06:16

Viewing Data & Fixing FullName Column Preview 02:17

Creating Custom Views For Data Preview 07:33

Creating A New Custom Form Preview 06:28

Testing Forms In Action By Adding New Record & Editing A Record Preview 03:36

Creating A Business Rule in CDS Preview 07:27

Business Rules In Action in CDS Preview 05:57

Other Useful CDS Features Preview 02:33

Advanced Model Driven Apps 9 lectures

Setting Up Environment For Model Driven Apps Preview 02:49

Lets Preview Some Basic Model Driven App Templates Preview 04:25

Navigation The Remaining Model Driven Apps Preview 03:53

Understanding The Environment Of Model Driven Apps Preview 05:05

Creating Site Map For Our App Preview 06:02

Editing The Views In Our Model Driven App Preview 03:59

Using Forms In Model Driven App Preview 03:36

Increasing Site Map Complexities By Adding More Items Preview 08:53

Understanding Business Process Flow In Model Driven Apps Preview 03:49

Getting Started With PowerApps Portals 6 lectures

01 Creating a new trial account for PowerApps Portal Preview 08:57

02 Creating a separate new environment Preview 05:35

03 Creating First Portal App Preview 02:13

04 Understanding Different PowerApps Portal Areas Preview 08:59

05 Pages And Components in PowerApps Portal Preview 16:06

06 Applying Basic Themes & Custom CSS Options in PowerApps Portals Preview 07:28

Introduction Power Automate 2 lectures

Platform Setup Preview 06:05

Basic Interface Walkthrough Preview 11:22

Getting Started With Microsoft Power Automate 9 lectures

Creating a flow from a template Preview 01:13

Understanding Flow Template Structure Preview 03:15

Starting Our First Flow & Introduction to Flow Detail Page Preview 02:14

Editing & Customizing Flow Template Preview 03:48

Running & Testing Our First Flow Preview 02:01

Understanding Flow Detail Page Preview 04:42

Creating an Automated Flow From a Template Preview 03:57

Editing Parameters Of Our Automated Twitter Flow Preview 05:48

Running & Testing Our Automated Twitter Flow Part Preview 05:16

Beginners Power Automate - Creating A Flow From Scratch 21 lectures

Creating a flow from scratch Preview 02:48

Creating our First Trigger Preview 04:40

Creating an Action Preview 03:00

Dynamic content in Power Automate Preview 05:06

Dynamic content at work Preview 04:41

Testing Our Flow Preview 03:49

What are Expressions & How to Use Expressions In Our Flow Preview 10:43

Using Concat Expression in Flow Preview 04:41

3.9 Adding Multiple Action Steps & Using Trello as a Connector in Power Automate Preview 06:44

Advanced Options in Action Steps Preview 03:33

Setting Up Due Date Dynamically Using Expressions & Date Functions Preview 07:46

Using Retweet Actions in Twitter Connector Preview 04:01

Getting Started With Built-In Control Functions in Power Automate Preview 03:13

Creating a Conditions in Our Flow Preview 07:07

Testing If Conditions in Our Twitter Flow Preview 05:39

Proof of Automated Re Tweet Bot Preview 01:51

Introduction to Scheduled Flows in Power Automate Preview 02:36

Creating Our First Scheduled Flow Preview 03:01

Customizing Our Scheduled Flow Using Slack Connector Preview 04:46

Customize Some parts of Our Scheduled Slack Flow Preview 03:28

Adding Delay Action in Scheduled Flow Preview 05:22

Intermediate Power Automate 45 lectures

4.1 Introduction to Various Inputs Types in Microsoft Power Automate Preview 03:13

4.2 Adding Multiple Inputs in Our Flows Preview 05:20

4.3 Customizing our Flow With Multiple Inputs & Trello Card Preview 07:31

4.4 Integrating PowerApps Within Power Automate Flow Preview 04:31

4.5 Customizing Our PowerApps Triggered Flow Preview 02:12

4.6 Creating An App in Microsoft PowerApps To Trigger Our Flow Preview 05:45

4.7 Testing Our Integrated PowerApps Flow Preview 03:21

4.8 Introduction to HTTP requests For Triggering Flows Preview 03:40

4.10 Creating JSON Schema & Customizing HTTP Triggered Flow Preview 05:27

4.11 Triggering HTTP Request Using PostMan & Testing Our Flow Preview 05:40

4.12 Introduction To Parallel Branches in Power Automate With Demo Preview 05:34

4.13 Introduction To Approvals in Power Automate Preview 03:08

4.14 Adding Approvals In Scratch Twitter Flow Preview 05:37

4.15 Integrating Approvals With Conditions in Power Automate Preview 04:39

4.17 Advanced Builtin Connectors Preview 02:05

4.18 Using Switch Control Action in Power Automate Preview 08:00

4.19 Testing Switch Condition Control Preview 02:32

4.20 Adding terminate Action With Switch Condition in Our Flow Preview 07:37

4.21 Implementing Apply To Each Control Action (Loop) Preview 06:33

4.22 Testing Apply To Each Loop Functionality of Our Flow & Error Handling Preview 08:02

4.23 Introduction To Do Until Control Function Preview 02:12

4.24 Do Until Control Setup in Power Automate Preview 07:42

4.25 Testing Do until Function & Analyzing Metadata Preview 05:14

4.26 Introduction to variables & Initializing Our First Variable Preview 04:15

4.27 Setting Up Variable values & Testing Variables Preview 02:29

4.28 Initializing Multiple Variables & Append to String Variable Action Preview 06:20

4.29 Variable Manipulation Example Preview 03:18

4.30 Setting Up Onedrive With Power Automate Preview 02:20

4.31 Creating File Checking Flow With OneDrive & Variables Preview 03:15

4.32 Customizing Find Files in Folder Action Preview 03:12

4.33 Initailizing Second Variable in Our Flow Preview 02:55

4.34 Setting Variable Based on Output From Other Actions Preview 05:05

4.35 Integrating Do Until Loop & Completing Our Variable Manipulation Flow Preview 06:03

4.36 Error Handling in Variable Manipulation Flow & Homework Preview 03:04

4.37 Solution & Finalizing Our variable Manipulation Flow Preview 04:05

4.38 Running & Testing Variable Manipulation Flow Preview 04:24

4.39 Advance HTTP & Request Connectors in Power Automate Preview 02:30

4.40 Advance Creating HTTP Trigger Request in Power Automate Preview 03:59

4.41 Advance Testing HTTP Trigger Request & Analyizing Metadata Preview 03:14

4.42 Data operations - Parsing JSON & Creating Schema Using Sample JSON Payload Preview 04:24

4.43 Integrating Apply to Each Loop & Formatng the Raw Outputs Preview 03:33

4.44 Transformative Connectors ( Text, DateTime & Number Functions ) Preview 04:44

4.45 Using Text Connector & Substring Functions in Power Automate Preview 04:26

4.46 Introduction to Button Trigger Tokens in Power Automate Preview 03:49

4.47 Creating Button Trigger Flow & Testing it Preview 04:48

Advanced Developer Mode 21 lectures

5.1 Good Development Practices - Analytics Preview 06:33

5.2 Good Development Practices - Copy & Paste Preview 05:07

5.3 Good Development Practices - Naming & Commenting Preview 04:26

5.4 Static Results in Power Automate ( Theory & Example ) Preview 05:29

5.5 Triggers & Connectors based on location Preview 07:10

5.7 Good Example of Error Handling Preview 03:19

5.8 Using Scopes in Power Automate Preview 05:44

5.8.2 Using Scopes in Power Automate Preview 02:01

5.9 Using Scopes for Error Handling in Power Automate Preview 05:26

5.10 Integrating Scopes in Flow For Error Handling Preview 04:07

5.11 Advance Expressions Guide Overview Preview 04:50

5.12 Expressions Environment Setup Preview 01:02

5.13 String Functions - Concat & Replace Expressions Preview 07:44

5.14 Using SubString Expression in Flow Preview 04:55

5.15 Using IndexOf Expression Within SubString Expression Preview 06:23

5.16 Split Expression in Power Automate With Example Preview 04:42

5.17 Split Function With Apply to each Control Action Loop Preview 04:28

5.18 Collection Functions in Power Automate - Contains Collection Expression Preview 07:22

5.19 Logical Comparison Functions - Using IF Statements Manually Preview 09:42

5.20 Three Most Used Logical Comparison Functions ( and, or & equals ) Preview 03:41

5.21 Other Expressions & Functions in Power Automate Preview 07:46

Getting Started With Power Automate Desktop 20 lectures

Requirements to Get Started With Desktop Flows Preview 03:33

Installing Required Browser Extensions For Desktop Flows Preview 02:26

Installing & Setting Up Power Automate Desktop Preview 02:45

Desktop Flow Environment Walkthrough Preview 09:10

Creating Our First Desktop Flow Using Desktop Recorder Preview 04:34

Error Handling While Running Desktop Flows Preview 05:19

Editing or Modifying Parameters of Desktop Flows Preview 04:50

6.8 Testing Modified Parameters in Desktop Flows Preview 01:28

6.9 Creating Dialog Box For Getting User Input in Desktop Flows Preview 04:09

6.10 Intregating User Inputs in Desktop Flows Preview 04:45

6.11 Integrating Input Variables &Testing Inputs in Desktop Flows Preview 05:33

6.13 Creating First Web Flow using Web Recorder Preview 08:37

6.14 Running Our Flow & Fixing Errors Preview 05:54

6.15 Excel Automation - Launch Excel 1 Preview 05:21

6.16 Excel Automation - Read From Excel Worksheet Preview 03:12

6.17 Excel Automation - Write Text to File & Close Excel Preview 06:00

6.18 Running & Testing Excel Automation Flow Preview 01:57

6.19 Excel Automation - Write to Excel Worksheet & Testing Flow Preview 03:47

6.20 Excel Automation - Dynamically Set User Input For Write to Excel Step Preview 04:35

6.21 Excel Automation - Insert Row & Column to Excel Worksheet Preview 04:03