How To Use Microsoft Power Automate? Step By Step Guide For Beginners

Microsoft Power Automate is a cloud based service that allows users to create automated workflows between their favorite applications and services to synchronize files, get notifications, and collect data. It acts as a digital glue, allowing non technical individuals to automate repetitive tasks and business processes without writing code.

Power Automate operates on a simple structural logic: If something happens (Trigger), then execute an action (Action).

• Triggers: The specific event that kicks off a workflow (e.g., receiving an email from a specific client or uploading a file to OneDrive).
• Actions: The subsequent steps the workflow performs automatically (e.g., copying an attachment, posting a message to Teams, or sending an approval request).
• Connectors: Pre built bridges that allow different applications to talk to each other. Microsoft offers over 1,000 native and third party connectors (including Salesforce, Google Workspace, Dropbox, and Slack).

The Three Main Pillars of Flow Types

1. Cloud Flows (Digital Process Automation – DPA): Workflows running entirely in the cloud. These are broken into Automated (triggered by events), Scheduled (run at specific times), and Instant (triggered manually with a button click).
2. Desktop Flows (Robotic Process Automation – RPA): Software robots that automate legacy on-premises applications, mouse clicks, and terminal screens that lack standard cloud APIs.
3. AI Builder Integration: Pre trained machine learning models embedded natively into workflows to perform smart tasks like extracting data from invoices or analyzing customer sentiment.

Pros and Cons

You can learn how to connect Claude Cowork to your Google Workspace using step by step guide.

Step by Step Guide for Beginners

This guide walks through creating your first Cloud Flow from scratch to achieve a classic beginner automation: extracting email attachments from Outlook and automatically saving them to a OneDrive folder.

Step 1: Access the Platform

1. Open your web browser and navigate to the Microsoft Power Automate Portal.
2. Log in using your corporate, school, or personal Microsoft 365 account credentials.

Step 2: Choose Your Creation Method

1. Click on the Create tab located in the left hand navigation sidebar.
2. Under “Start from blank”, select Automated cloud flow.
3. Name your flow (e.g., Save Email Attachments to OneDrive).

Step 3: Define the Trigger

1. In the trigger search box, type Outlook.
2. Find and select the trigger named When a new email arrives (V3).
3. Click Create to launch the flow designer interface.
4. In the trigger settings card, expand the advanced options and set Include Attachments to Yes.

Step 4: Add the Action

1. Click the + New step button directly beneath your trigger card.
2. In the action search box, type OneDrive.
3. Select the action named Create file (OneDrive for Business).

Step 5: Map the Dynamic Data

1. Click into the Folder Path field and select the folder icon to choose where attachments should live.
2. Click into the File Name field. A “Dynamic content” pop-up box will appear. Select Attachments Name from the list.
3. Note: Power Automate will automatically wrap your action in an “Apply to each” loop container. This is expected, as it ensures the flow loops through every single attachment found in that email.
4. Click into the File Content field and select Attachments Content from the dynamic content pop-up box.

Step 6: Test and Deploy

1. Look at the top right corner and click Save.
2. Click Test, choose Manually, and then click Test again.
3. Send a test email to your own inbox containing a sample file attachment.
4. Watch the designer window view. Green checkmarks will appear on the cards indicating that your workflow succeeded.

How To Use Desktop Flows (RPA)?

Desktop Flows (Robotic Process Automation – RPA) are software robots that automate repetitive, manual tasks on your physical or virtual computer. While Cloud Flows handle digital tasks behind the scenes via APIs, Desktop Flows act like a human operator: they record and mimic your mouse clicks, keyboard strokes, and data entry across legacy desktop software, websites, and terminal screens that completely lack modern APIs

How Desktop Flows Work

Desktop Flows operate through the Power Automate for Desktop application installed on your PC. The system uses two primary mechanisms to execute tasks:

• UI Automation: The robot identifies specific user interface elements (like buttons, text boxes, and dropdown menus) by their code structure to interact with them reliably.
• Image Recognition / Coordinates: If an application is too old or running inside a remote desktop session (like Citrix), the robot uses visual anchoring or specific screen coordinates to click and type.

Key Architectural Components

1. Attended RPA: The automation runs on your local machine while you are logged in. It requires human interaction to start, or prompts the user for real time input during execution.
2. Unattended RPA: The automation runs completely independently on a remote server or virtual machine without human presence. It triggers automatically from cloud events, even if the workstation is locked.
3. UI Elements Repository: A centralized registry within the flow that saves the exact structural definitions of the buttons and fields the robot interacts with, making maintenance easy if an application’s layout changes.

You can learn how to use ClickUp Brain for workflow automation using guide for beginners.

Step by Step Guide: Building Your First Desktop Flow

This guide walks through creating a local automation that opens a web browser, navigates to a specific website, extracts a pricing number, and writes it directly into a local Excel file.

Step 1: Install and Launch Power Automate for Desktop

1. Download and install the Power Automate for Desktop app from the Microsoft Store or the official Microsoft website.
2. Open the application and log in using your Microsoft account.
3. Click the + New flow button in the top left corner, name it Web Price Extractor, and click Create.

Step 2: Open or Create the Target Excel File

1. In the left hand Actions panel, search for Excel.
2. Drag and drop the Launch Excel action into the central workspace.
3. Set the parameter “Launch Excel” to and open the following document.
4. Enter the document path to a blank Excel sheet saved on your desktop, then click Save.

Step 3: Launch the Browser and Navigate

1. In the actions panel, search for Launch new Chrome (or Edge).
2. Drag it into the workspace directly beneath the Excel action.
3. Set the “Initial URL” to the webpage you want to monitor (e.g., a stock tracker or e-commerce item). Click Save.

Step 4: Extract Data Using the Web Recorder

1. Look at the top toolbar and click the Web recorder icon (a browser window with a red dot).
2. Select your target browser instance and click Next. A small recording widget will appear.
3. Navigate to your target webpage. Hover your mouse over the specific price or text data you want to extract.
4. Right click the text, hover over Extract element value, and choose Text.
5. Click Finish on the recorder widget. Power Automate will automatically generate all the necessary browser scraping actions in your workspace.

Step 5: Write the Extracted Data into Excel

1. Search for the Write to Excel worksheet action in the left panel and drag it to the bottom of your flow.
2. Set “Excel instance” to the variable generated in Step 2 (usually %ExcelInstance%).
3. Set “Value to write” to the variable generated by your web recorder (usually %AttributeValue%).
4. Specify the Column as 1 and Row as 1 to place it in cell A1. Click Save.

Step 6: Close and Save the Documents

1. Drag the Close Excel action to the very end of your workspace.
2. Set “Before closing Excel” to Save document. Click Save.
3. Click the Run icon (the green play button) at the top of the screen to watch your mouse and browser execute the task automatically.