Corporate Trainings

We design value into profit by developing solutions to your problems!

Contact Us Form

POWER AUTOMATE Training

Power Automate Duration: 10 Hours

Power Automate is an online workflow service that automates actions across the most common apps and services.

Program Objectives

In this module, you will:

  • Create a flow that automatically saves email attachments
  • Learn how to create a button flow to send yourself a reminder.

Course Curriculum

Module 1:Getting Started With Power Automate

  • Using Power Automate templates
  • Getting familiar with Environment
  • Understanding type of flows
  • Creating flow using template
  • Creating flow from scratch using flow designer
  • Creating flow using Manual trigger
  • Creating recurring flow
  • Creating Auto trigger flow
  • Creating flow using Describing
  • Editing a Power Automate flow
  • Publish flow in Power Automate
  • Run a flow
  • Troubleshoot flows
  • Turn off, Disable or delete a Power Automate

Module 2:Automation Using Excel

  • Open Excel files and attach a process to an already opened file.
  • Use the Excel group of actions to read data from and write data to an Excel file.
  • Create and edit worksheets.
  • Save and close Excel files.

Module 3:Automation Using Emails

  • Monitoring email
  • Setting up a flow for incoming emails
  • Searching for email with specific subject and perform automation
  • Build a cloud flow that's triggered in Outlook
  • Trigger email if records gets added in Excel
  • Trigger email if forms get submitted
  • Trigger email if One drive or Sharepoint file updated etc.

Module 4:Automation Using MS Form

  • Save record on excel file on submission
  • Trigger email notification post submission of MS form
  • Trigger email with responses or attachment to anyone post submission of MS form
  • Using condition to trigger report
  • Generate PDF of the records and share via email
  • Sending email based on MS form field input

Module 5:Creating Approval Workflow

  • Integration with MS teams
  • Build an approval request
  • Build a flow that processes an approval request
  • Assigning approval to workflows
  • Testing the absence process
  • Adding reminders





Module 6:Desktop Flows

  • Learn how to use Power Automate to create a new desktop flow.
  • Record actions that are performed in a desktop-based application.
  • Perform a test run of the new desktop flow.
  • Run a basic desktop flow in unattended mode.
  • Use the recorder to generate actions automating local Windows UI-based tasks

Module 7:Web Automation/Web Scraping

  • Learn how to configure browser automation actions.
  • Learn how to extract data from web pages.
  • Create a flow that extracts gainer stocks from the MSN website

Module 8:Scheduling

  • Scheduling a flow (excel report, One drive file, Sharepoint file or run any flows)

Module 9:Logic

  • Adding Conditions
  • Designing Switches
  • Using Apply To Each
  • Configuring Do Until Logic
  • Adding A Scope

Module 10:Power Automate In Power BI

  • Auto Refresh
  • Picking Data
  • Notify If Numbers / Value Reaches thresold
  • Update excel table from Power BI

Mode of Training

Online
On-Premise



Industry Best Data Analytics Trainers

With Zaptas, you’re trained by the industry’s finest. Our trainers are seasoned experts who combine deep technical knowledge with a practical, results-driven approach, helping participants gain confidence and excel in their roles.

Tailored Data Analytics Course Curriculum

A tailored course curriculum is customized to meet specific learner needs, industry requirements, and skill levels, ensuring relevant, practical content that maximizes engagement, learning outcomes, and real-world application.

Access to Data Analytics training E-learning videos

Access to e-learning platforms provides flexible, online education through a variety of courses across industries. Learners can study at their own pace, from anywhere, with tools for interactive learning and certification.

Post Training Support

Post-training support includes follow-up resources, mentorship, online, offline communities, troubleshooting help, webinars, and access to additional materials, ensuring continued learning, skill application, and professional development after completing a course or program.

responsive

we design value into profit

our customers are always happy!