Power Automate Desktop - Essentials RPA Training Course

Explore automations and desktop reporting, learn to leverage actions and features like Big Mo on the hit caller, and develop observations quickly.

Explore how to create, name, edit, and run automations in Power Automate Desktop, use the recorder and tools, and adjust execution and view options.

Explore the action library in Power Automate Desktop, learning action types and how to search by type or keyword. Each action has properties that define its setup for automating tasks.

Learn to use variables in Power Automate Desktop to store and manipulate values, create and rename variables, call them in actions, and manage automatic variable creation.

Learn to capture and map UI elements in Power Automate Desktop, select and click buttons, interact with notepad and other apps, run automation, and review captured elements.

Step through actions to debug automation, use breakpoints to pause before an action, and run from a chosen point to observe behavior, including message boxes.

Explore how to use the recorder in Power Automate Desktop to automate the Windows calculator, capturing desktop actions and generating automated steps that run on web and desktop environments.

Develop automation that simulates a loan application by opening browser websites, inputting data from an Excel file into form fields, submitting, and recording approval or rejection in Excel.

Learn to read data from an Excel file in Power Automate Desktop by opening a new Excel instance, selecting the file, defining start column and row, and marking the header.

Execute a for-each loop over each data table row in Excel, perform loan application actions, input data into fields, submit the loan application, and write results back to Excel, while displaying each row’s email value.

Learn to automate filling web form fields using Power Automate Desktop, mapping Excel data to email, loan amount, and term fields, and submitting loan applications.

Develop an automated workflow to submit loan applications, extract the web page address, and use a conditional check to determine approval by ending with true or false, displaying corresponding messages.

Extracts the loan rate, loan ID, and approval status from a web page, stores them in variables, and writes the results to Excel, handling approved and not approved cases.

Demonstrates automating excel writes in power automate desktop, writing loan rates and loan states using write to excel worksheet actions, counter starting at row two and incrementing after loan applications.

Finish the automation by saving and closing the Excel file, then closing Google's web browser after processing all loan applications, and verify the automation completes successfully.

Build an Outlook automation that sorts emails into Microsoft, eBay, and Amazon folders based on subject keywords, then sends a completion notification.

Create a new flow in Power Automate Desktop to fetch emails from an Outlook inbox, select the account, filter unread messages by subject, and prepare for iterating and moving emails.

Iterate through Outlook emails using a for loop in Power Automate Desktop to extract sender, subject, and body data from each message and manage read/unread status.

Learn to use a switch action to route emails by subject, with cases for Amazon, Microsoft, and eBay and a default path.

Learn to route emails in Outlook by creating variables and a switch, then move messages to specific folders such as Amazon, Microsoft, eBay, or others using Power Automate Desktop.

Explore sending emails in Power Automate Desktop with Gmail or Outlook actions, configure accounts and recipients, and organize mail using for each loops and switch cases.

Create an automation in Power Automate Desktop to capture stock data from Philby's website. Filter by technology sector, extract ticker, company name, industry, and price, and export to Excel.

Open website automation using Power Automate Desktop to launch Chrome, navigate Philby's site, and click links and elements to access the stock screen and apply filters.

Define filters in Power Automate Desktop by configuring dropdowns for market cap and sector, and selecting options by name or index to set return on equity.

Automate extracting stock data from webpages using Power Automate Desktop, capturing tickers, company names, industry, market cap, and price across multiple pages into Excel.

Automate data entry by downloading a spreadsheet and inputting records into shifting farm fields on the screen, ensuring correct field mapping after each submission.

Automate the starting challenge by downloading the Excel file, reading range A1:G11 with headers into a data table named challenge data, then launching Chrome to begin the site workflow.

Automate input data on form fields from an Excel data table using Power Automate Desktop, looping through rows to map fields and submit the web form.

Create custom XPath selectors to identify form fields uniquely in automation, using stable properties like class or name, and build dynamic XPath for fields such as first name and email.

Power Automate Desktop users can boost automation speed by reducing run delay, disabling page-load waits, and using faster typing modes for web page text fields.

Explore automating spec extraction from PDA files and exporting each specification from each PDA file to a text file, with test files provided for hands-on practice.

Create a new flow, fetch files from a folder, and iterate to extract pdf text and save it as a text file, displaying the full path of each file.

Extract text from each pdf file by looping through items, using the extract text from pdf action, and storing the results in a variable for verification.

Extract PDF text and write it to a text file in Power Automate Desktop, naming the output after the PDF and using save and variable actions.

This final project overview guides you through automating a fictional bookstore: scrape book titles and prices across pages, export to Excel, fill a form, and email the file via Outlook.

Build and demonstrate automation with Power Automate Desktop that opens websites, extracts titles and prices, enters data into a form, exports to Excel, and emails the file via Outlook.

Explore a YouTube channel offering weekly tutorials across different RPA platforms, with subscriptions for updates and notifications. Follow on LinkedIn for RPA content and the creator's personal and professional journey.