Explanation

Power Automate is Microsoft’s workflow automation platform. It can connect Excel with services such as:

  • Outlook
  • OneDrive
  • SharePoint
  • Teams
  • Forms
  • Excel
  • Other supported services

Basic Workflow

Trigger → Action → Action → Result

Example

Every Monday

      ↓

Get Excel Data

      ↓

Run Office Script

      ↓

Create Report

      ↓

Send Outlook Email

Types of Flows

  • Automated cloud flow
  • Scheduled cloud flow
  • Instant cloud flow

Practice

Design a workflow that runs every Monday and prepares a weekly sales report.

PreviousNext