Become RPA Master in MS Power Automate Desktop in 30 days

Become RPA Master in MS Power Automate Desktop in 30 days

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

<>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

Lecture 50 How to work with “Retrieve data table Column to list” action

Lecture 51 How to work with “Find or Replace in data table” action

Lecture 52 How to work with “Delete row from data table” action

Section 13: Files Actions

Lecture 53 Learn and Work with Files Actions

Lecture 54 Read Text from file and Write to Text File

Lecture 55 Get Filepath Part Action

Lecture 56 Read from CSV file and Write to CSV File

Section 14: Folder Actions

Lecture 57 Learn and Work with Folder Actions

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

Section 15: Compression Actions

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

Section 16: Text Actions

Lecture 60 How to work with “Append line to Text”

Lecture 61 How to work with “Get SubText” Action

Lecture 62 How to work with “Pad Text” Action

Lecture 63 How to work with “Trim Text” Action

Lecture 64 How to work with “Change Text Case” Action

Lecture 65 How to work with “Create Random Text” Action

Lecture 66 How to work with “Join Text” Action (Text Actions)

Lecture 67 How to work with “Split Text” Action (Text Actions)

Lecture 68 How to work with “Replace Text” Action (Text Actions)

Lecture 69 How to work with “Parse Text” Action (Text Actions)

Lecture 70 How to work with “Escape Text for Regular Expression”

Lecture 71 How to work with “Convert Text to Number”

Lecture 72 How to work with “Convert Number to Text” Action

Lecture 73 How to work with “Convert Text to DateTime” Action

Lecture 74 How to work with “Convert DateTime To Text” Action

Section 17: Working with Regular Expressions

Lecture 75 Understanding Regular Expressions

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

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

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

Lecture 79 Developed Desktop Flows for Regular Expressions

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

Lecture 80 Overview of Email Automation

Lecture 81 How to work with “Retrieve Emails” Action

Lecture 82 How to work with “Email Filters”(Retrieve Emails Actions)

Lecture 83 How to work with “Process Emails” Action

Lecture 84 How to work with “Send Email” Action

Section 19: Outlook Automation

Lecture 85 Introduction of Outlook Automation

Lecture 86 How to work with “Retrieve Email Messages from Outlook”

Lecture 87 How to work with “Retrieve Email Messages from Outlook” – Part 2

Lecture 88 How to work with “Sent Email through Outlook”

Lecture 89 How to work with “Respond to Outlook Mail Message”

Lecture 90 How to work with “Process email Messages in Outlook”

Lecture 91 How to work with “Save Outlook email Messages”

Section 20: PDF Automation

Lecture 92 Introduction of PDF Automation

Lecture 93 Extract Images from PDF

Lecture 94 Extract Text from PDF

Lecture 95 Extract PDF pages to new PDF

Lecture 96 Merge PDF Files

Section 21: XML Automation

Lecture 97 Read XML From File

Lecture 98 Execute XPath Expression

Lecture 99 Get XML Element Attribute

Lecture 100 Get XML Element value

Lecture 101 Set XML Element Attribute

Lecture 102 Set XML Element Value

Lecture 103 Insert XML Element

Lecture 104 Write XML to File

Lecture 105 Remove XML Element attribute

Lecture 106 Remove XML Element

Section 22: Automate using UI Elements

Lecture 107 Working with UI Elements

Lecture 108 How to Handle Dynamic UI Elements for Web Pages

Section 23: Web/Browser Automation

Lecture 109 Introduction of Web Automation

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

Lecture 111 Automation With UI Elements

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

Lecture 113 Working with (Entire) Web Form Filling Actions – Demo Project (Detailed)

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

Lecture 115 Web Data Extraction – Extract Data from Web Page

Lecture 116 Web Data Extraction – Get details of web page

Section 24: UI Automation

Lecture 117 Introduction of UI Automation

Lecture 118 Form Filling Actions – Part 1

Lecture 119 Form Filling Actions – Part 2

Lecture 120 Get Details of Window (UI Automation – Data Extraction)

Lecture 121 Get Details of an UI Element in Window (UI Automation – Data Extraction)

Lecture 122 Get Selected Radio Button in Window (UI Automation – Data Extraction)

Lecture 123 Get Selected CheckBox in Window (UI Automation – Data Extraction)

Lecture 124 Extract Data From Window (UI Automation – Data Extraction)

Section 25: Recorders

Lecture 125 Web Recorder

Lecture 126 Desktop Recorder

Section 26: Schedule, Share and Monitor Desktop Flows

Lecture 127 How to schedule Desktop Flows?

Lecture 128 How to share the Desktop Flows?

Lecture 129 Monitor Desktop Flows

Section 27: Environments ,Export & Import Desktop Flows

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

Lecture 131 How to Export and Import Desktop Flows?

Section 28: On-Premises data gateway

Lecture 132 What is on-premises data gateway?

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

Section 29: Scripting Actions

Lecture 134 Introduction to Scripting Actions

Lecture 135 How to work with “Run VBScript” Action

Lecture 136 How to work with “Run JavaScript” Action

Lecture 137 How to work with “Run JavaScript Function on web Page” Action

Lecture 138 How to work with “Run Python Script” Action

Lecture 139 How to work with “Run Powershell Script” Action

Section 30: Power Automate Machine Runtime

Lecture 140 Introducing Power Automate Machine Runtime App

Lecture 141 Manage Machines

Lecture 142 Machine Group

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

Section 31: December 2021 Features

Lecture 144 How to Create a copy of Desktop Flow

Lecture 145 Unified Recorder ( Web Recorder , Desktop Recorder )

Section 32: SharePoint Actions (Preview)

Lecture 146 Introduction to SharePoint Actions (Preview)

Lecture 147 SharePoint : Connection and Connection Reference

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

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

Lecture 150 How to work with “Get Folder metadata using path” action

Lecture 151 How to work with “List Folder” Action

Lecture 152 How to work with “Get File metadata using path” action

Lecture 153 How to work with “Get File content using path” action

Lecture 154 How to work with “Delete File” action

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

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

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

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

Lecture 158 Part 4 : Desktop Flow for Email Automation

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

Lecture 159 Introduction to WorkItem Management

Lecture 160 Demo || WorkItem Management

Lecture 161 Set Up and Configure Azure DevOps Rest API

Lecture 162 Personal Access Token

Lecture 163 Test Azure DevOps Rest API

Lecture 164 Components for Azure DevOps Rest API

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

Lecture 166 Add Workitems to Azure Boards Dynamically

Lecture 167 Update Workitems

Lecture 168 WIQL (WorkItem Query Language)

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

Lecture 169 Usecase for RPA challenge

Lecture 170 Demo for RPA Challenge

Lecture 171 Steps to Solve RPA challenge

Lecture 172 How to Capture UI Elements

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

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

Lecture 175 Read Excel data and populate on web page

Lecture 176 Create Subflow for RPA challenge

Lecture 177 Error Handling

Lecture 178 Complete & Final Run for RPA Challenge

Lecture 179 RPA Challenge – Source Code (Developed Desktop Flow )

Section 36: Project #4 : National Stock Exchange (NSE)

Lecture 180 Introduction to Web Scraping

Lecture 181 Web Scraping : National Stock Exchange

Lecture 182 What are the learning Concepts as part of Web scraping?

Lecture 183 Data Extraction from NSE (Working with “Extract Data from web page “ action)

Lecture 184 Work with “Wait for Web page Content” action

Lecture 185 How to get list of items from dropdown using “Extract Data from web page“ Action

Lecture 186 Get list of items from dropdown using “Run JavaScript Function on web page“ -2

Lecture 187 NSE : How to work with “Set Drop-Down List value on the web page” action

Lecture 188 NSE : Working with Excel actions to store data in Excel file

Lecture 189 NSE: Creating a folder for Excel data

Lecture 190 NSE : Exception Handling

Lecture 191 NSE : How to Schedule NSE Desktop flow using Power Automate Cloud?

Lecture 192 NSE : Final Output

Lecture 193 Complete Solution for NSE Project – Developed Cloud Flow & Desktop Flows

Section 37: Interview Questions and Answers

Lecture 194 Power Automate Desktop Interview Questions – Series 1

Lecture 195 Power Automate Desktop Interview Questions – Series 2

Section 38: Congratulations!!!

Lecture 196 Congratulations!!!

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

Course Information:

Udemy | English | 28h 6m | 11.63 GB
Created by: Learning Technologies

You Can See More Courses in the Developer >> Greetings from CourseDown.com