+- Forum Rockoldies (https://rockoldies.net/forum)
+-- Forum: Fotobearbeitung - Photoshop (https://rockoldies.net/forum/forumdisplay.php?fid=16)
+--- Forum: E-Learning, Tutorials (https://rockoldies.net/forum/forumdisplay.php?fid=18)
+--- Thema: Become Rpa Master In Ms Power Automate Desktop (In 30 Days) (/showthread.php?tid=62649)
Become Rpa Master In Ms Power Automate Desktop (In 30 Days) - Panter - 10.11.2022
![[Bild: r4nb7ogomcsya8s3kcvvbegcq1.jpg]](https://abload.de/img/r4nb7ogomcsya8s3kcvvbegcq1.jpg)
Become Rpa Master In Ms Power Automate Desktop (In 30 Days)
Last updated 9/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 8.88 GB | Duration: 25h 41m
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
![[Bild: becomerpamasterinmspoojdiq.jpg]](https://abload.de/img/becomerpamasterinmspoojdiq.jpg)
Download from RapidGator
Download from Rapidgator:
Download from DDownload