Microsoft Power Automate: Automate Tasks Without Coding

Learn to access Power Automate from 365 apps, navigate environments, and manage assets like flows, apps, pages, and tables, using the left menu with create, templates, and learning resources.

Explore the three cloud flow types in Power Automate—automated, instant, and schedule flows—and their triggers from forms, SharePoint, and Gmail. Learn to run, monitor, and share flows using My Flows.

Create Power Automate flows: an automated flow posts Microsoft Teams notifications for new SharePoint items; a manual flow adds items from user input; a schedule flow creates records every minute.

Discover the flow details page in Power Automate, viewing flow name, owner, status, and run history, then manage connections, resubmit runs, and share with others.

Explore dynamic contents in power automate by referencing properties from earlier steps, and see how available fields change with the selected list, form, or data type.

Explore variables and data types in Power Automate, learning how variables hold temporary values, how initialization fixes data type, and the six data types—strings, integers, floats, booleans, arrays, and objects.

Explore variables and data types in Power Automate by initializing variables, selecting types, and using actions to set, increment, append, and decrement values, including arrays and booleans.

Explore the basics of expressions in Power Automate, learning to access and transform data from previous steps using Excel-like formulas, functions, and dynamic content.

Access array elements in Power Automate by using apply to each and do until, looping over SharePoint list items and extracting individual properties like employee name.

Explore how to use conditional actions in Power Automate to branch flow steps based on criteria, count get items results, and take true or false actions.

Explore how Excel actions in Power Automate interact with Excel Online tables, including creating, listing, and retrieving rows, and why only table-formatted ranges work for row operations.

Read data from an Excel table in Power Automate with get row and list rows actions. Use a key column, filters, and ISO 8601 formatting to retrieve tenant issue records.

Add rows to an Excel table from an array of objects using Power Automate, looping with apply to each and mapping name, price, and quantity to the products table.

Discover how to update and delete Excel rows with Power Automate, using update and delete actions, and apply dynamic updates to multiple records based on filter queries.

Learn to manage Excel tables in Power Automate using get tables and create table actions, reference ranges in A1 notation, and name tables like employees for use in flows.

Explore two Power Automate actions for Excel: create worksheet and get worksheets, enabling you to add an empty sheet or list all available worksheets in a workbook.

Explore Office Scripts and Excel web automation with Power Automate. Learn to record actions, edit TypeScript, and auto fill a travel request template with dynamic data.

Discover known issues and limitations of the Excel connector in Power Automate, including 25MB file size, file locking up to six minutes, single filter queries, and 256-row pagination.

Explore a real-world Microsoft Forms enrollment project linked to an Excel table, enforcing single enrollment per email and a three-seat session cap.

Create a training enrollment form in Microsoft Forms and configure an automated cloud flow in Power Automate that triggers on new form responses and retrieves response details.

Configure conditional logic in Power Automate to enforce session capacity and single enrollment, counting enrolled users with a list rows action and length checks.

Learn to load enrollment data into an Excel table with Power Automate, adding a row and sending outcome notifications from a shared mailbox.

Test the flow end-to-end by submitting enrollment forms, checking session capacity, and validating emails, Excel updates, and dynamic content for approved or rejected enrollments in Power Automate.

Explore how Power Automate exposes raw outputs and JSON data from APIs and HTTP requests, and learn to read headers, body, and dynamic content to build flexible flows.

Use the switch action in Power Automate to evaluate the SharePoint list status and route records to draft, ready to publish, or default branches.

Explore parallel branches and run after configuration in Power Automate, merging data with compose and union after list rows in a table, logging errors with a SharePoint create item action.

Enable concurrency control in apply to each loop to run iterations in parallel and greatly reduce flow runtime. Manage trigger concurrency to limit parallel runs and respect connector throttling.

Explore the filter array action in Power Automate to filter records beyond Excel's limits, using advanced mode and expressions to filter by date (ISO 8601) and type (plumbing).

Use the select action in Power Automate to map selected columns, create a custom month field from dates, and format dates for a user-friendly output.

Turn arrays of objects into HTML tables or CSV files in Power Automate. Use the select action to shape data and embed tables in emails or save them to SharePoint.

Learn how scopes organize complex Power Automate flows by grouping actions like email and password validation, improving readability and error handling with run-after configurations.

Learn to craft filter queries in Power Automate with SharePoint and Dataverse, using eq, gt, or operators and query functions like starts with, while noting Excel limits and premium licensing.

Learn to overcome Power Automate's default data limits by enabling pagination, setting page thresholds up to 100,000, and using do until loops for very large Excel and SharePoint data.

Identify when to start flows in Power Automate using trigger conditions, such as only triggering on tasks created in the urgent planner bucket by matching its bucket ID.

Explore how SharePoint sites use document libraries and lists to organize team information. Learn to create automations, forms, and custom views with Power Automate while managing permissions and version history.

Read data from SharePoint lists in Power Automate using Get items for multiple records. Use Get item for a single record, with filter query and limit columns by view.

Learn to create, update, and delete SharePoint list items using Power Automate, including filtering by department, updating fields like current office, and managing IDs.

Learn to start flows in Microsoft Power Automate from SharePoint list events—item created, updated, or deleted—and use triggers for lists and libraries, including get changes and team notifications.

Explore how to read properties from SharePoint files and folders in Power Automate, using actions like get folder metadata, get files properties, and get file metadata to build flows.

Read file content from a SharePoint library using get file content, explore json and excel data, and learn when to infer content type for attachments or file conversions.

Create and update SharePoint document library files with Power Automate using create file and update file actions, specifying file name and content, for text, excel, and json data.

Learn to move, copy, and delete SharePoint files with Power Automate, from a source to a destination folder, handling name conflicts and renaming via http or create-file methods.

Learn how to start flows from SharePoint file events: create, modify, or delete, using non-deprecated triggers, set site and library filters, and understand version history and its limitations.

start flows from a selected item or file in SharePoint using manual triggers in Power Automate and create Planner tasks, noting the folder limitation and default environment requirement.

Explore SharePoint actions in Power Automate, including add/get/delete attachments, checkout and check in, create a document set, grant access, extract folders, and http requests for versatile SharePoint tasks.

Use Power Automate to retrieve emails from Outlook with the Get emails action, choosing Office 365 Outlook for work accounts, apply filters, and convert HTML bodies to text for testing.

Discover how to automate emails with the Outlook connector, sending from a shared mailbox, attaching SharePoint files, and configuring subject, body, importance, CC/BCC, and attachment options.

Automate email-driven workflows with Power Automate by triggering on new emails, filtering by subject keywords, extracting the order id from the body, and logging results to an Excel table.

Monitor a mailbox and save each email attachment to a SharePoint library using create file, for each attachment, and get attachment to retrieve content bytes.

use the send email with options action to attach custom buttons in messages, enabling user responses via a single email with configurable subject, header text, and option texts.

Learn to access calendars and events in Power Automate using the Outlook connector, including get calendars, get calendar view of events, and get event actions.

Learn to automate Outlook calendar events with Power Automate by creating, updating, and deleting events, using actions like find meeting times to schedule available slots and manage attendees.

Build an automated flow triggered by a new Outlook event to automatically respond to invites, declining meetings when the subject contains the word meeting.

Explore Outlook actions in Power Automate, including assigning categories, creating contacts, drafting messages, and using get rooms, reply to emails, automatic replies, http requests, and MCP server actions.

Automate a finance workflow with outlook and sharepoint connectors to process invoice payment requests and confirmations by email, generate incremental IDs, update excel records, save attachments, and create calendar events.

Build a Power Automate cloud flow that monitors a shared mailbox, converts HTML to text, and loads invoice data into Excel, with initial PDF and ID variables and 1000-item pagination.

Learn to parse payment emails in Power Automate, extract vendor name, invoice number, and amount from the body, then filter Excel records and update the paid status on confirmation.

Identify attachments in the email message, count pdfs, and if exactly one pdf exists, retrieve its content into the pdf content variable; otherwise, notify the vendor and terminate the flow.

Automate Excel records by extracting amount and due date from emails, then add or update the table based on vendor and invoice number, with a sequential ID.

Automate calendar events from new or updated invoices in Excel, including record ID in the subject and eastern time, save attachments to SharePoint, and delete paid invoices on confirmation.

Test and debug a power automate flow by running multiple scenarios, fixing expression errors, and updating Excel records, SharePoint files, and calendar events from invoice PDFs.

Explore how to integrate power automate with microsoft teams to automate notifications and follow ups, manage teams, channels, chats, and shared files across departments, project teams, and cross-functional groups.

Learn how to read data from Microsoft Teams using Power Automate: list teams, view team details, list tags and channels, get channel details, list members, and retrieve messages and replies.

Create a team from scratch in Power Automate, add members, create a channel, assign a Project Lead tag, post a welcome message, and verify IT policies.

Discover how to post messages in team chats and channels with Power Automate, including bot or user posting, and a simple create-chat workaround for individual chats.

Post a message with options to a single Teams recipient via a flow bot, defining a headline, message body, optional summary, and notify setting.

Learn to collect complex user inputs in microsoft teams using adaptive cards, including free text, dates, and checkboxes, with json payloads and an action set in power automate.

Automate welcoming new team members in Microsoft Teams by triggering a flow when a member is added, then post a greeting using a get a mention token from a user.

Learn to start flows from received messages in Microsoft Power Automate, detect urgent keywords, and automatically create to-do tasks from group or individual chats.

Explore Power Automate triggers and actions for Microsoft Teams, including selected message triggers, mentions, adaptive cards, reactions, posting cards in chat or channel, and http requests.

Explore date and time functions in Power Automate, using UTC now to capture the moment and perform time calculations. Learn to extract date parts, format timestamps, and convert time zones.

Explore formatting date and time in Power Automate using the format datetime function. Learn standard and custom formats, locales, and how to embed format and time in your flows.

Learn to convert timestamps between time zones in Power Automate using convert from UTC, convert to UTC, and convert time zone functions, with formatting options and real-world examples.

Explore start of hour, day, and month in Power Automate to capture the first moment of a timestamp, and craft a custom start of year expression for date-based calculations.

Learn to compute start of the quarter from a timestamp in Power Automate using calendar quarters, with nested ifs and compose steps to yield the first moment of the quarter.

Learn to manipulate dates in power automate with add days, add time, subtract time, and get future or past time, using timestamps and current time.

Compare two timestamps in flows using conditions and date difference to determine which is earlier or later, including start-of-day normalization and measuring days, hours, and minutes.