1.
Power Platform and Business Automation

1.1 Power Platform
1.2 Features and Functions of the Power Platform
1.3 Development Cases Using the Power Platform
1.4 The Role of Citizen Developers
1.5 Definition and Function of RPA

2.
Utilizing generative AI

2.1 Digital Transformation
2.2 Generative AI - Copilot
2.3 Prompt Engineering

3.
Power Automate Desktop Basics

3.1 Features and Strengths of PAD
3.1.1 Features and Strengths of PAD
3.1.2 Power Automate Desktop Automation Technology
3.1.3 Power Automate Desktop Use Cases
3.2 Starting PAD
3.2.1 Power Automate Dekstop/Cloud
3.2.2 Types of Licenses
3.2.3 Premium License
3.2.4 Power Automate Architecture for Desktop
3.2.5 Microsoft Membership
3.2.6 Installing Power Automate Desktop
3.2.7 Power Automate Desktop UI
3.2.8 Power Automate Desktop Preferences
3.2.9 Creating a Power Automate Desktop Automation Flow (Message Box Output)
3.3 Recorder
3.3.1 Recorder Concept
3.3.2 Reviewing Recorder Features
3.3.3 Practice - Logging in using the recorder
3.3.4 Practice - Logging in using the task action
3.4 Variables
3.4.1 Basic concept of variables
3.4.2 Types of variables
3.4.3 Variable scope and sensitive display
3.4.4 Practice - Using Variables
3.4.5 Variable expression method and use of operation formulas
3.4.6 Using expressions for variables
3.4.7 Using variables in various properties
3.5 Date/Time
3.5.1 Using Date/Time
3.5.2 Date/Time Actions
3.5.3 Using date/time expressions
3.5.4 Practice - Manipulating Date/Time Data
3.6 Text
3.6.1 Use of Text
3.6.2 Text Actions
3.7 List
3.7.1 Using the list
3.7.2 List Actions
3.7.3 Custom Objects
3.7.4 Practice - Retrieving Data from a Desired Area in a PDF
3.7.5 Practice - Advanced Retrieving Data from a Desired Area in a PDF
3.8 Conditions and Iterations
3.8.1 Using conditional statements
3.8.2 How to express conditional statements
3.8.3 Conditional Statement Action
3.8.4 How to use various conditional statements
3.8.5 Using switch statements
3.8.6 Using loops
3.8.7 Loop Action
3.8.8 How to use various loops
3.9 Files/Folders
3.9.1 File/Folder Automation
3.9.2 File/Folder Operations Actions
3.9.3 Absolute and Relative Paths
3.9.4 Practice - File/Folder Control Using Conditional Statements and Loops
3.9.5 Practice - Creating Various Files Using Conditional and Loop Statements
3.10 Data Table
3.10.1 Concept and Use of Data Tables
3.10.2 How to use various data tables
3.10.3 Data Table Operations Actions
3.11 Excel
3.11.1 Excel Automation
3.11.2 Structure of Excel
3.11.3 Excel Task Actions
3.11.4 Practice - Running, Saving, and Closing Excel
3.11.5 Practice - Reading Excel Data (Text/Table)
3.11.6 Practice - Compiling Excel Data from the National Tax Service
3.11.7 Practice - Cleansing Excel Data from the Road Traffic Authority
3.11.8 Practice - Converting Population Trends to Columns in Excel
3.11.9 Using Excel Macros
3.12 UI/Browser Automation
3.12.1 UI/Browser Automation
3.12.2 UI/Browser Automation - Configuration
3.12.3 UI/Browser Automation - UI Element Inspection
3.12.4 Browser Automation Actions
3.12.5 UI Automation Actions
3.12.6 UI Automation Actions (Images)
3.12.7 Practice - Text Input and Button Clicking
3.12.8 Practice - Clicking the button elements in order
3.12.9 Practice - Extracting Table Data
3.12.10 Practice - Retrieving Data from Dropbox as a List Value
3.12.11 Practice - Inputting and Outputting Data from a Website
3.13 RPA and Web Development
3.13.1 Frontend and Backend
3.13.2 Frontend
3.13.3 HTML
3.13.4 CSS
3.13.5 JavaScript
3.14 Outlook (email)
3.14.1 Outlook Automation
3.14.2 HTML
3.14.3 Email Actions
3.14.4 SMTP and IMAP
3.14.5 Practice - Sending Email Using Outlook
3.14.6 Practice - Receiving Naver Mail
3.14.7 Exercise - Attaching Images in HTML
3.15 Teams
3.15.1 Teams
3.15.2 Teams Task Action ResultsEdit
3.15.3 Teams Task Actions
3.15.4 Teams Practice
3.16 SAP
3.16.1 What is SAP?
3.16.2 Leveraging RPA in SAP
3.16.3 Transactions and Transaction Codes (T-Code)
3.16.4 SAP Work Actions
3.17 Flow Control and Exception Handling
3.17.1 Utilizing Flow Control
3.17.2 Flow Control Actions
3.17.3 The Importance of Exception Handling
3.17.4 Exception Handling - Business Errors | System Errors
3.17.5 Design-time errors, run-time errors
3.17.6 On block error
3.17.7 Task Action Self-Error Handling
3.17.8 View Last Error (LastError)
3.17.9 Practice - Handling Exceptions

4.
Power Automate Desktop in Practice

4.1 Run with administrator privileges
4.1.1 Running as Administrator
4.2 [DPA] Machine Configuration and Schedule Execution
4.2.1 Setting up the machine
4.2.2 Executing tasks according to schedule
4.3 [DPA] Sharing Workflows
4.3.1 The Importance of Flow Sharing
4.3.2 File Sharing: Importing Solutions
4.3.3 File Sharing: Exporting a Solution (File)
4.3.4 File Sharing: Importing a Solution (File)
4.3.5 Robin Language
4.4 Running PAD with Windows Task Scheduler
4.4.1 Running PAD with Windows Task Scheduler
4.5 Power Fx
4.5.1 Power Fx
4.5.2 Using Power Fx on PAD
4.6 Switching the Power Automate Desktop Language
4.6.1 Switching Languages
4.7 Using the Picture-in-Picture Feature
4.7.1 Picture in Picture
4.8 Mouse/Keyboard/Clipboard
4.8.1 Mouse/Keyboard/Clipboard Automation
4.8.2 Mouse/Keyboard/Clipboard Actions
4.9 PDF/Compression
4.9.1 PDF and Compression
4.9.1 Compression Action
4.9.2 PDF Actions
4.10 System
4.10.1 System Control Method
4.10.2 System Operation Actions
4.10.3 Workstation Actions
4.11 Regular Expressions
4.11.1 Regular Expressions
4.11.2 Types of regular expression operations
4.11.3 Using Regular Expressions in PAD
4.11.4 Regular Expressions (Specifying Forward/Backward Searches)
4.11.5 Examples of Using Regular Expressions
4.11.6 Frequently Used Regular Expressions
4.12 HTTP (API)
4.12.1 Utilizing HTTP (API)
4.12.2 Practice - Retrieving and Processing Data from the Public Data Portal
4.12.3 Practice - Retrieving Naver News for Specific Keywords Using the Naver API
4.13 Database
4.13.1 Using the Database
4.13.2 SQL Connection Actions
4.13.3 Enabling SQL Connections in MariaDB
4.14 Encryption
4.14.1 Encryption
4.14.2 Encryption Operation Action
4.15 Scripting
4.15.1 Using Scripting
4.15.2 Scripting Actions

5.
supplement

Power Automate RPA: See, Learn, and Apply Right Away
Practical RPA Work Automation: No-Code Implementation - Microsoft Power Automate
Introducing the Power Platform, a core tool for business automation.
Introducing MS Copilot, a generative AI-based business innovation tool.
Rich examples and friendly screenshot guides that you can follow right away in the field.
A systematic roadmap for automation, from the basics to practical application, based on task difficulty.
A variety of automation scenarios that can be immediately applied to various work environments.
Providing a robust, hands-on, hands-on logic design methodology with added realism.