Become RPA Master in MS Power Automate Desktop (in 30 days)

Focused View

Learning Technologies

25:40:30

167 View

1 - Introduction

1 - Welcome to the course.mp4

01:22

2 - Microsoft Power Automate Cloud

2 - What is Microsoft Power Automate.mp4

08:39

3 - How to Signup and signin for Power Automate.mp4

13:11

3 - Power Automate User accounts and Pricing

4 - Get Started with Accounts.mp4

11:42

5 - Pricing Model.mp4

12:04

6 - PayAsYouGo Licensing Model New.mp4

14:43

4 - Lets Start Power Automate Desktop

7 - Power Automate Desktop is now FREE for Windows 10 users.mp4

10:19

8 - How to Download and Install Power Automate Desktop.mp4

09:54

9 - Quick Look Power Automate Desktop application.mp4

10:27

10 - Microsoft Power Automate Versus Microsoft Power Automate Desktop.mp4

13:53

5 - Variables Actions

11 - How to Set Variable Truncate Number Get Random Numbers.mp4

13:49

12 - How to Increase Variable Decrease Variable.mp4

07:32

13 - Desktop Flow for Set varable Truncate & Get Rand Numbers Inc & Dec Variable.html

13 - SetVarTruncateNumberGetRandNumbersincanddecvar-1-0-0-1.zip

14 - CreateNewlistAdditemRemoveitemfromListclearlist-1-0-0-1.zip

14 - How to Create New List Add Item to List Remove Item From List Clear List.mp4

12:07

15 - How to Work with Remove Duplicate items from List Reverse List Shuffle List.mp4

08:03

15 - RemoveDuplicateitems-Reverse-ShuffleList-1-0-0-1.zip

16 - How to Work with Merge Lists Subtract Lists Find Common List items.mp4

12:04

16 - MergeListsSubtractListsFindCommonListitems-1-0-0-1.zip

6 - Conditional Actions

17 - Learn Conditional Actions Theoretical.mp4

04:58

18 - How to work with Conditional Actions Practical Use case.mp4

05:08

19 - Working with Conditional Actions If and Else.mp4

05:43

20 - Working with Conditional Actions If Else If Switch Case Default Case.mp4

08:02

21 - Working with If File Folder Exists and If Process Conditional Actions.mp4

10:59

7 - Loop Actions

22 - Learn and Work with Loops Loop Loop Condition Next loop & Exit loop.mp4

13:25

23 - Learn and Work with For Each Loop.mp4

04:31

8 - Database Actions

24 - Open and Close SQL Connection Execute SQL Statement.mp4

13:46

25 - Database Actions with Stored Procedure.mp4

15:59

9 - Excel Automation

26 - Employee.xlsx

26 - Employee-Selection.xlsx

26 - LaunchExcelReadDatafromExcelCloseExcel-1-0-0-1.zip

26 - Launch Excel Read from Excel Close Excel.mp4

20:41

27 - WritetoExcelWorksheet-1-0-0-1.zip

27 - Write to Excel Worksheet.mp4

11:35

28 - AddNewWorksheet-1-0-0-1.zip

28 - How to Add New Worksheet.mp4

04:37

29 - How to Set Active Excel Worksheet.mp4

06:19

29 - SetActiveExcelWorksheet-1-0-0-1.zip

30 - GetFirstFreeColumnRowFromExcelWorksheet-1-0-0-1.zip

30 - How to work with Get First free Column Row from Excel Worksheet action.mp4

08:45

31 - Employee.xlsx

31 - GetfirstfreerowoncolumnfromExcelWorksheet-1-0-0-1.zip

31 - How to work with Get first free row on column from Excel Worksheet.mp4

11:20

32 - Employee.xlsx

32 - Employee-Selection.xlsx

32 - ExcelAutomationdesktopFlows-1-0-0-2.zip

32 - Sample Desktop flows for Excel Automation.html

10 - Advanced Excel

33 - GetActiveExcelWorksheet-1-0-0-1.zip

33 - How to Get Active Excel Worksheet.mp4

04:37

34 - GetAllexcelworksheets-1-0-0-1.zip

34 - How to Get All Excel Worksheets.mp4

03:58

35 - DeleteExcelWorksheet-1-0-0-1.zip

35 - How to work with Delete Excel Worksheet.mp4

04:40

36 - How to work with Rename Excel Worksheet.mp4

08:21

36 - RenameExcelWorksheet-1-0-0-1.zip

37 - InsertColumnInsertRowtoExcelWorksheet-1-0-0-1.zip

37 - Insert Column Insert Row to Excel Worksheet.mp4

12:30

11 - Excel as Database Using SQL Queries

38 - EmployeesList.xlsx

38 - Introduction for Excel as Database.mp4

02:41

39 - PreRequisites for OLEDB provider.mp4

01:26

40 - OLEDB Connection String.mp4

02:12

41 - Install Microsoft Access database Engine.mp4

06:40

42 - Topic1ReadExcelFileDataUsingASQLConnection-1-0-0-1.zip

42 - Topic 1 Read Excel File Data Using A SQL Connection From Multiple WorkSheets.mp4

20:21

43 - Topic 2 How to Filter the Records from the excel.mp4

12:49

43 - howtoFiltertheRecordsfromtheexcel-1-0-0-1.zip

44 - GetTop5salaries-1-0-0-1.zip

44 - Topic 3 Get Top 5 salaries by Using SQL Query.mp4

07:18

12 - Data table Variable actions

45 - Introduction to Data table variable actions.mp4

02:40

46 - How to work with Create new Data table variable Action.mp4

10:37

47 - How to create a data table using Set Variable Action.mp4

08:48

47 - createnewdatattable-1-0-0-1.zip

47 - variable.zip

48 - How to add a row to data table using Insert Row into Data table action.mp4

14:02

48 - insertrowintodatatable-1-0-0-1.zip

49 - How to work with Update data table item action.mp4

06:37

49 - updatedatatableitem-1-0-0-1.zip

13 - Files Actions

50 - Learn and Work with Files Actions.mp4

13:07

51 - Read Text from file and Write to Text File.mp4

08:58

52 - Get Filepath Part Action.mp4

02:59

53 - Read from CSV file and Write to CSV File.mp4

11:07

14 - Folder Actions

54 - Learn and Work with Folder Actions.mp4

13:36

55 - Work with Folder Actions Empty Delete Copy Move and Rename Folder.mp4

10:01

15 - Compression Actions

56 - Learn How to Work with Compression Actions Zip and Unzip Files.mp4

13:16

16 - Text Actions

57 - How to work with Append line to Text.mp4

10:29

58 - How to work with Get SubText Action.mp4

08:17

59 - How to work with Pad Text Action.mp4

06:47

60 - How to work with Trim Text Action.mp4

08:02

61 - How to work with Change Text Case Action.mp4

07:26

62 - How to work with Create Random Text Action.mp4

06:02

63 - How to work with Join Text Action Text Actions.mp4

06:05

64 - How to work with Split Text Action Text Actions.mp4

06:13

65 - How to work with Replace Text Action Text Actions.mp4

10:34

66 - How to work with Parse Text Action Text Actions.mp4

10:26

67 - How to work with Escape Text for Regular Expression.mp4

05:10

68 - How to work with Convert Text to Number.mp4

05:55

69 - How to work with Convert Number to Text Action.mp4

05:46

70 - How to work with Convert Text to DateTime Action.mp4

06:53

71 - How to work with Convert DateTime To Text Action.mp4

07:25

17 - Working with Regular Expressions

72 - Understanding Regular Expressions.mp4

03:40

73 - RegEx Global & Case Insensitive Character Sets Ranges Repeating characters.mp4

13:13

74 - RegEx Metacharacters Special & Alternate Characters Starting & End Patterns.mp4

11:05

75 - Real Time Example To Extract Email IDs from Outlook with Regular Expressions.mp4

23:03

76 - Developed Desktop Flows for Regular Expressions.html

76 - RegularExpressions-1-0-0-1.zip

18 - Email Automation GMAIL Features are getting deprecated

77 - Overview of Email Automation.mp4

04:26

78 - How to work with Retrieve Emails Action.mp4

09:41

79 - How to work with Email FiltersRetrieve Emails Actions.mp4

09:53

80 - How to work with Process Emails Action.mp4

12:45

81 - How to work with Send Email Action.mp4

10:29

19 - Outlook Automation

82 - Introduction of Outlook Automation.mp4

04:31

83 - How to work with Retrieve Email Messages from Outlook.mp4

11:24

84 - How to work with Retrieve Email Messages from Outlook Part 2.mp4

12:07

85 - How to work with Sent Email through Outlook.mp4

08:04

86 - How to work with Respond to Outlook Mail Message.mp4

09:43

87 - How to work with Process email Messages in Outlook.mp4

08:13

88 - How to work with Save Outlook email Messages.mp4

10:09

20 - PDF Automation

89 - Introduction of PDF Automation.mp4

02:45

90 - Extract Images from PDF.mp4

08:26

91 - Extract Text from PDF.mp4

06:15

92 - Extract PDF pages to new PDF.mp4

06:06

93 - Merge PDF Files.mp4

06:41

21 - XML Automation

94 - Read XML From File.mp4

16:00

95 - Execute XPath Expression.mp4

15:32

96 - Get XML Element Attribute.mp4

07:43

97 - Get XML Element value.mp4

06:32

98 - Set XML Element Attribute.mp4

07:29

99 - Set XML Element Value.mp4

05:32

100 - Insert XML Element.mp4

05:50

101 - Write XML to File.mp4

08:58

102 - Remove XML Element attribute.mp4

04:44

103 - Remove XML Element.mp4

05:23

22 - Automate using UI Elements

104 - Working with UI Elements.mp4

13:43

105 - How to Handle Dynamic UI Elements for Web Pages.mp4

13:24

23 - WebBrowser Automation

106 - Introduction of Web Automation.mp4

08:09

107 - Live Application for Browser Automation Web Form Filling.mp4

01:37

108 - Automation With UI Elements.mp4

11:59

109 - Work with Web Form Filling Actions Launch New Browser Close Web Browser.mp4

12:55

110 - Working with Entire Web Form Filling Actions Demo Project Detailed.mp4

19:06

111 - Data Entry Project with Web Form Filling Actions & Excel Automation.mp4

14:01

112 - Web Data Extraction Extract Data from Web Page.mp4

09:34

113 - Web Data Extraction Get details of web page.mp4

11:53

24 - UI Automation

114 - Introduction of UI Automation.mp4

03:13

115 - Form Filling Actions Part 1.mp4

08:07

116 - Form Filling Actions Part 2.mp4

08:03

117 - Get Details of Window UI Automation Data Extraction.mp4

07:21

118 - Get Details of an UI Element in Window UI Automation Data Extraction.mp4

05:35

119 - Get Selected Radio Button in Window UI Automation Data Extraction.mp4

05:20

120 - Get Selected CheckBox in Window UI Automation Data Extraction.mp4

03:38

121 - Extract Data From Window UI Automation Data Extraction.mp4

05:27

25 - Recorders

122 - Web Recorder.mp4

11:27

123 - Desktop Recorder.mp4

05:55

26 - Schedule Share and Monitor Desktop Flows

124 - How to schedule Desktop Flows.mp4

11:43

125 - How to share the Desktop Flows.mp4

07:00

126 - Monitor Desktop Flows.mp4

05:09

27 - Environments Export & Import Desktop Flows

127 - Learn About Power Automate Environments Create & Switching Environments.mp4

13:41

128 - How to Export and Import Desktop Flows.mp4

12:53

28 - OnPremises data gateway

129 - What is onpremises data gateway.mp4

12:13

130 - How to trigger Power Automate desktop Flows from another flow.mp4

10:11

29 - Scripting Actions

131 - Introduction to Scripting Actions.mp4

04:19

132 - How to work with Run VBScript Action.mp4

20:59

133 - How to work with Run JavaScript Action.mp4

06:46

134 - How to work with Run JavaScript Function on web Page Action.mp4

16:41

135 - How to work with Run Python Script Action.mp4

08:16

136 - How to work with Run Powershell Script Action.mp4

11:45

30 - Power Automate Machine Runtime

137 - Introducing Power Automate Machine Runtime App.mp4

05:39

138 - Manage Machines.mp4

09:29

139 - Machine Group.mp4

16:17

140 - How to Trigger a desktop Flow Direct to Machine to run on our machine.mp4

08:44

31 - December 2021 Features

141 - How to Create a copy of Desktop Flow.mp4

02:50

142 - Unified Recorder Web Recorder Desktop Recorder.mp4

11:14

32 - SharePoint Actions Preview

143 - Introduction to SharePoint Actions Preview.mp4

02:38

144 - SharePoint Connection and Connection Reference.mp4

09:28

145 - How to upload a file to SharePoint By using Create a file Action.mp4

11:05

145 - SharePointcreateFileAction-1-0-0-1.zip

146 - How to update a file in SharePoint By using Update file Action.mp4

08:17

146 - SharePointUpdateFile-1-0-0-1.zip

147 - GetFoldermetadatausingpath-1-0-0-1.zip

147 - How to work with Get Folder metadata using path action.mp4

04:57

148 - How to work with List Folder Action.mp4

06:34

148 - SharePointlistfolder-1-0-0-1.zip

149 - GetFilemetadatausingpath-1-0-0-1.zip

149 - How to work with Get File metadata using path action.mp4

05:26

150 - GetFilecontentusingpath-1-0-0-1.zip

150 - How to work with Get File content using path action.mp4

09:08

151 - How to work with Delete File action.mp4

07:23

151 - Sharepointdeletefile-1-0-0-1.zip

33 - Project 1 HR Use case Employee Onboarding Process

152 - Employee-onboarding-Process.xlsx

152 - Part 1 Demo for Employee Onboarding Process Employee ID & Email Generation.mp4

12:36

153 - Part 2Desktop Flow for Browser Web Automation for Employee Onboarding process.mp4

12:01

154 - Employee-onboarding-Process.xlsx

154 - Part 3 Desktop Flow for Excel Automation for Employee Onboarding process.mp4

23:20

155 - EmployeeOnboardingProcess-1-0-0-4.zip

155 - Part 4 Desktop Flow for Email Automation.mp4

11:30

34 - Project 2 WorkItem Management Integration With Azure DevOps

156 - Introduction to WorkItem Management.mp4

01:05

157 - Demo WorkItem Management.mp4

06:58

157 - Project-Management.xlsx

157 - WorkItemManagementProject-1-0-0-1.zip

157 - azure-devops-rest-api-urls.zip

158 - Set Up and Configure Azure DevOps Rest API.mp4

01:36

159 - Personal Access Token.mp4

03:19

160 - Test Azure DevOps Rest API.mp4

03:24

161 - Components for Azure DevOps Rest API.mp4

03:49

162 - Create a desktop Flow to invoke Azure DevOps Ret API.mp4

11:01

163 - Add Workitems to Azure Boards Dynamically.mp4

22:35

164 - Update Workitems.mp4

13:29

165 - WIQL WorkItem Query Language.mp4

13:26

35 - Project 3 RPA Challenge with Dynamic UI Elements for Web form Filling

166 - Usecase for RPA challenge.mp4

02:09

167 - Demo for RPA Challenge.mp4

02:05

168 - Steps to Solve RPA challenge.mp4

00:33

169 - How to Capture UI Elements.mp4

04:01

170 - How to handle dynamic UI elements on a web page.mp4

06:55

171 - Create a desktop flow for web form filling with dynamic UI elements.mp4

06:38

172 - Read Excel data and populate on web page.mp4

11:23

173 - Create Subflow for RPA challenge.mp4

04:17

174 - Error Handling.mp4

04:30

175 - Complete & Final Run for RPA Challenge.mp4

02:14

176 - RPA Challenge Source Code Developed Desktop Flow.html

176 - RPA-Challenge-1-0-0-1.zip

176 - challenge.xlsx

36 - Interview Questions and Answers

177 - Power Automate Desktop Interview Questions Series 1.mp4

08:49

178 - Power Automate Desktop Interview Questions Series 2.mp4

08:25

37 - Congratulations

179 - Congratulations.mp4

00:20

Description

This Course is designed with 28+ hours & 4 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*

Who is this for?

Beginners of RPA

Beginners of Microsoft Power Automate Desktop

Learners of Microsoft Power Automate

What You Need to Know?

No Programing Knowledge / Coding Knowledge Required

Better to have basic understanding on MS Excel, Outlook, SQL Database

No Prerequisites are Required.

More details

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 Desktop
2) How to Install Power Automate Desktop
3) CreateÂ a simple Desktop Flow
4) 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 Loops
7) working with Excel Automation
8) working with Database Automation
9) Working with File Actions
10)Â Working with Folder Actions
11) Work with Compression Actions (Zip and Unzip Files)
12) Work with Text Actions
13) Working with Date and Time Actions
14) working with Email Automation Actions
15) working with Outlook Automation Actions
16) working with web recorder
17) working with web Automation Actions
18) working with UI Automation Actions
19) working with Desktop recorder
20) working withÂ PDF Automation Actions
21) working with XML Automation Actions
WeÂ willÂ learn Every action step by step with basic examples.
Who this course is for:
Beginners of RPA
Beginners of Microsoft Power Automate Desktop
Learners of Microsoft Power Automate

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power Automate

Learning Technologies

Instructor's Courses

I am RPA developer on BluePrism, Automation Anywhere , UiPath , Microsoft Power Automate and Microsoft Power Automate Desktop and also a youtuber.I have more than 12 years of experience in Microsoft technologies.I have created more than 500 + online videos on all RPA tools.The main responsibilities of as a RPA developer are to design, develop, and implement software robots, or bots, to work alongside humans to enhance business process efficiency.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.