Become Rpa Master In Ms Power Automate Desktop (In 30 Days)

This Course is designed with 25+ hours & 3 live Projects to learn MS Power Automate Desktop to Automate repetitive Tasks

What you'll learn
By the end of the course, you will be capable of working on real time projects
You will get, Complete Knowledge on Power Automate Desktop
You will learn, How to Install Power Automate Desktop
You will learn, How to create Desktop Flow
You will learn, How to Connect with MS Excel ,Database and Outlook
You will learn, How to use Web and Desktop recorders to develop flows
You will become master in Microsoft Power Automate Desktop
*PL-500. Covering all Power Automate Desktop Concepts*
Requirements
No Programing Knowledge / Coding Knowledge Required
Better to have basic understanding on MS Excel, Outlook, SQL Database
No Prerequisites are Required.
Description
<<Covering all concepts* of Power Automate desktop related to PL-500 Certification>>This Course is Designed to Learn RPA with orientation and structure of Microsoft Power Automate desktop, installation, error handling, flow control, debugging and automation of business processes. This Course covers many aspects of RPA to keep the technology up to speed.This course is for everyone (Beginners , Intermediate ,Experts) , how wants to learn Power Automate Desktop step by step about Desktop flows, creating automated steps, and flow development essentials.By the End of the course , you will  be able to :1) Introduction to the Power Automate Desktop2) How to Install Power Automate Desktop3) Create  a simple Desktop Flow4) Working with Variable Actions (Set Variable, Truncate Number, Get Random Numbers , Increase Variable , Decrease Variable , Create New List, Add Item to List, Remove Item From List, Clear List , Remove Duplicate items from  List, Reverse List, Shuffle List, Merge Lists, Subtract Lists, Find Common List items)5) Working with Conditional Actions (If and Else, If , Else If, Switch, Case, Default Case , If File / Folder  Exists and If Process )6) working with Loops7) working with Excel Automation8) working with Database Automation9) Working with File Actions10)  Working with Folder Actions11) Work with Compression Actions (Zip and Unzip Files)12) Work with Text Actions13) Working with Date and Time Actions14) working with Email Automation Actions15) working with Outlook Automation Actions16) working with web recorder 17) working with web Automation Actions18) working with UI Automation Actions19) working with Desktop recorder20) working with  PDF Automation Actions21) working with XML Automation Actions We  will  learn Every action step by step with basic examples.

Overview

Section 1: Introduction

Lecture 1 Welcome to the course

Section 2: Microsoft Power Automate Cloud

Lecture 2 What is Microsoft Power Automate

Lecture 3 How to Sign-up and sign-in for Power Automate

Section 3: Power Automate User accounts and Pricing

Lecture 4 Get Started with Accounts

Lecture 5 Pricing Model

Lecture 6 Pay-As-You-Go Licensing Model (New !!!)

Section 4: Lets Start Power Automate Desktop

Lecture 7 Power Automate Desktop is now FREE for Windows 10 users

Lecture 8 How to Download and Install Power Automate Desktop

Lecture 9 Quick Look Power Automate Desktop application

Lecture 10 Microsoft Power Automate Versus Microsoft Power Automate Desktop

Section 5: Variables Actions

Lecture 11 How to Set Variable, Truncate Number, Get Random Numbers

Lecture 12 How to Increase Variable , Decrease Variable

Lecture 13 Desktop Flow for Set varable , Truncate & Get Rand Numbers , Inc & Dec Variable

Lecture 14 How to Create New List, Add Item to List, Remove Item From List, Clear List

Lecture 15 How to Work with Remove Duplicate items from List, Reverse List, Shuffle List

Lecture 16 How to Work with Merge Lists, Subtract Lists, Find Common List items

Section 6: Conditional Actions

Lecture 17 Learn Conditional Actions (Theoretical)

Lecture 18 How to work with Conditional Actions (Practical Use case)

Lecture 19 Working with Conditional Actions (If and Else)

Lecture 20 Working with Conditional Actions (If , Else If, Switch, Case, Default Case)

Lecture 21 Working with If File / Folder Exists and If Process Conditional Actions

Section 7: Loop Actions

Lecture 22 Learn and Work with "Loops" (Loop, Loop Condition, Next loop & Exit loop)

Lecture 23 Learn and Work with "For Each Loop"

Section 8: Database Actions

Lecture 24 Open and Close SQL Connection, Execute SQL Statement

Lecture 25 Database Actions with Stored Procedure

Section 9: Excel Automation

Lecture 26 Launch Excel, Read from Excel, Close Excel

Lecture 27 Write to Excel Worksheet

Lecture 28 How to Add New Worksheet

Lecture 29 How to Set Active Excel Worksheet

Lecture 30 How to work with Get First free Column / Row from Excel Worksheet action

Lecture 31 How to work with "Get first free row on column from Excel Worksheet"

Lecture 32 Sample Desktop flows for Excel Automation

Section 10: Advanced Excel

Lecture 33 How to "Get Active Excel Worksheet"

Lecture 34 How to "Get All Excel Worksheets"

Lecture 35 How to work with "Delete Excel Worksheet"

Lecture 36 How to work with "Rename Excel Worksheet"

Lecture 37 Insert Column , Insert Row to Excel Worksheet

Section 11: Excel as Database (Using SQL Queries)

Lecture 38 Introduction for Excel as Database

Lecture 39 Pre-Requisites for OLEDB provider

Lecture 40 OLEDB Connection String

Lecture 41 Install Microsoft Access database Engine

Lecture 42 Topic 1 : Read Excel File Data Using A SQL Connection (From Multiple WorkSheets)

Lecture 43 Topic 2 : How to Filter the Records from the excel

Lecture 44 Topic 3 : Get Top 5 salaries by Using SQL Query

Section 12: Data table - Variable actions

Lecture 45 Introduction to Data table - variable actions

Lecture 46 How to work with "Create new Data table" variable Action

Lecture 47 How to create a data table using "Set Variable" Action

Lecture 48 How to add a row to data table using "Insert Row into Data table" action

Lecture 49 How to work with "Update data table item" action

Section 13: Files Actions

Lecture 50 Learn and Work with Files Actions

Lecture 51 Read Text from file and Write to Text File

Lecture 52 Get Filepath Part Action

Lecture 53 Read from CSV file and Write to CSV File

Section 14: Folder Actions

Lecture 54 Learn and Work with Folder Actions

Lecture 55 Work with Folder Actions (Empty, Delete, Copy, Move and Rename Folder)

Section 15: Compression Actions

Lecture 56 Learn How to Work with Compression Actions (Zip and Unzip Files)

Section 16: Text Actions

Lecture 57 How to work with "Append line to Text"

Lecture 58 How to work with "Get SubText" Action

Lecture 59 How to work with "Pad Text" Action

Lecture 60 How to work with "Trim Text" Action

Lecture 61 How to work with "Change Text Case" Action

Lecture 62 How to work with "Create Random Text" Action

Lecture 63 How to work with "Join Text" Action (Text Actions)

Lecture 64 How to work with "Split Text" Action (Text Actions)

Lecture 65 How to work with "Replace Text" Action (Text Actions)

Lecture 66 How to work with "Parse Text" Action (Text Actions)

Lecture 67 How to work with "Escape Text for Regular Expression"

Lecture 68 How to work with "Convert Text to Number"

Lecture 69 How to work with "Convert Number to Text" Action

Lecture 70 How to work with "Convert Text to DateTime" Action

Lecture 71 How to work with "Convert DateTime To Text" Action

Section 17: Working with Regular Expressions

Lecture 72 Understanding Regular Expressions

Lecture 73 RegEx (Global & Case Insensitive, Character Sets, Ranges, Repeating characters)

Lecture 74 RegEx (Metacharacters, Special & Alternate Characters, Starting & End Patterns)

Lecture 75 Real Time Example : To Extract Email IDs from Outlook with Regular Expressions

Lecture 76 Developed Desktop Flows for Regular Expressions

Section 18: Email Automation (GMAIL Features are getting deprecated)

Lecture 77 Overview of Email Automation

Lecture 78 How to work with "Retrieve Emails" Action

Lecture 79 How to work with "Email Filters"(Retrieve Emails Actions)

Lecture 80 How to work with "Process Emails" Action

Lecture 81 How to work with "Send Email" Action

Section 19: Outlook Automation

Lecture 82 Introduction of Outlook Automation

Lecture 83 How to work with "Retrieve Email Messages from Outlook"

Lecture 84 How to work with "Retrieve Email Messages from Outlook" - Part 2

Lecture 85 How to work with "Sent Email through Outlook"

Lecture 86 How to work with "Respond to Outlook Mail Message"

Lecture 87 How to work with "Process email Messages in Outlook"

Lecture 88 How to work with "Save Outlook email Messages"

Section 20: PDF Automation

Lecture 89 Introduction of PDF Automation

Lecture 90 Extract Images from PDF

Lecture 91 Extract Text from PDF

Lecture 92 Extract PDF pages to new PDF

Lecture 93 Merge PDF Files

Section 21: XML Automation

Lecture 94 Read XML From File

Lecture 95 Execute XPath Expression

Lecture 96 Get XML Element Attribute

Lecture 97 Get XML Element value

Lecture 98 Set XML Element Attribute

Lecture 99 Set XML Element Value

Lecture 100 Insert XML Element

Lecture 101 Write XML to File

Lecture 102 Remove XML Element attribute

Lecture 103 Remove XML Element

Section 22: Automate using UI Elements

Lecture 104 Working with UI Elements

Lecture 105 How to Handle Dynamic UI Elements for Web Pages

Section 23: Web/Browser Automation

Lecture 106 Introduction of Web Automation

Lecture 107 Live Application for Browser Automation (Web Form Filling)

Lecture 108 Automation With UI Elements

Lecture 109 Work with Web Form Filling Actions (Launch New Browser, Close Web Browser)

Lecture 110 Working with (Entire) Web Form Filling Actions - Demo Project (Detailed)

Lecture 111 Data Entry Project with Web Form Filling Actions & Excel Automation

Lecture 112 Web Data Extraction - Extract Data from Web Page

Lecture 113 Web Data Extraction - Get details of web page

Section 24: UI Automation

Lecture 114 Introduction of UI Automation

Lecture 115 Form Filling Actions - Part 1

Lecture 116 Form Filling Actions - Part 2

Lecture 117 Get Details of Window (UI Automation - Data Extraction)

Lecture 118 Get Details of an UI Element in Window (UI Automation - Data Extraction)

Lecture 119 Get Selected Radio Button in Window (UI Automation - Data Extraction)

Lecture 120 Get Selected CheckBox in Window (UI Automation - Data Extraction)

Lecture 121 Extract Data From Window (UI Automation - Data Extraction)

Section 25: Recorders

Lecture 122 Web Recorder

Lecture 123 Desktop Recorder

Section 26: Schedule, Share and Monitor Desktop Flows

Lecture 124 How to schedule Desktop Flows?

Lecture 125 How to share the Desktop Flows?

Lecture 126 Monitor Desktop Flows

Section 27: Environments ,Export & Import Desktop Flows

Lecture 127 Learn About Power Automate Environments (Create & Switching Environments )

Lecture 128 How to Export and Import Desktop Flows?

Section 28: On-Premises data gateway

Lecture 129 What is on-premises data gateway?

Lecture 130 How to trigger Power Automate desktop Flows from another flow ?

Section 29: Scripting Actions

Lecture 131 Introduction to Scripting Actions

Lecture 132 How to work with "Run VBScript" Action

Lecture 133 How to work with "Run JavaScript" Action

Lecture 134 How to work with "Run JavaScript Function on web Page" Action

Lecture 135 How to work with "Run Python Script" Action

Lecture 136 How to work with "Run Powershell Script" Action

Section 30: Power Automate Machine Runtime

Lecture 137 Introducing Power Automate Machine Runtime App

Lecture 138 Manage Machines

Lecture 139 Machine Group

Lecture 140 How to Trigger a desktop Flow (Direct to Machine) to run on our machine

Section 31: December 2021 Features

Lecture 141 How to Create a copy of Desktop Flow

Lecture 142 Unified Recorder ( Web Recorder , Desktop Recorder )

Section 32: SharePoint Actions (Preview)

Lecture 143 Introduction to SharePoint Actions (Preview)

Lecture 144 SharePoint : Connection and Connection Reference

Lecture 145 How to upload a file to SharePoint (By using Create a file Action)

Lecture 146 How to update a file in SharePoint (By using Update file Action)

Lecture 147 How to work with "Get Folder metadata using path" action

Lecture 148 How to work with "List Folder" Action

Lecture 149 How to work with "Get File metadata using path" action

Lecture 150 How to work with "Get File content using path" action

Lecture 151 How to work with "Delete File" action

Section 33: Project #1 : HR Use case : Employee Onboarding Process

Lecture 152 Part 1 : Demo for Employee Onboarding Process (Employee ID & Email Generation)

Lecture 153 Part 2:Desktop Flow for Browser / Web Automation for Employee Onboarding process

Lecture 154 Part 3: Desktop Flow for Excel Automation for Employee Onboarding process

Lecture 155 Part 4 : Desktop Flow for Email Automation

Section 34: Project #2 : WorkItem Management {Integration With Azure DevOps}

Lecture 156 Introduction to WorkItem Management

Lecture 157 Demo || WorkItem Management

Lecture 158 Set Up and Configure Azure DevOps Rest API

Lecture 159 Personal Access Token

Lecture 160 Test Azure DevOps Rest API

Lecture 161 Components for Azure DevOps Rest API

Lecture 162 Create a desktop Flow to invoke Azure DevOps Ret API

Lecture 163 Add Workitems to Azure Boards Dynamically

Lecture 164 Update Workitems

Lecture 165 WIQL (WorkItem Query Language)

Section 35: Project #3 : RPA Challenge with Dynamic UI Elements for Web form Filling

Lecture 166 Usecase for RPA challenge

Lecture 167 Demo for RPA Challenge

Lecture 168 Steps to Solve RPA challenge

Lecture 169 How to Capture UI Elements

Lecture 170 How to handle dynamic UI elements on a web page ?

Lecture 171 Create a desktop flow for web form filling with dynamic UI elements

Lecture 172 Read Excel data and populate on web page

Lecture 173 Create Subflow for RPA challenge

Lecture 174 Error Handling

Lecture 175 Complete & Final Run for RPA Challenge

Lecture 176 RPA Challenge - Source Code (Developed Desktop Flow )

Section 36: Interview Questions and Answers

Lecture 177 Power Automate Desktop Interview Questions - Series 1

Lecture 178 Power Automate Desktop Interview Questions - Series 2

Section 37: Congratulations!!!

Lecture 179 Congratulations!!!

Beginners of RPA,Beginners of Microsoft Power Automate Desktop,Learners of Microsoft Power Automate