Microsoft Power Automate Master : from 0 to Expert

Vincenzo guides you through Microsoft Power Automate Master, drawing on ten years of software development and automation, with a practical, hands-on approach across Power Automate, Power Apps, and Power BI.

Master Power Automate from zero to expert through hands-on practice, tackling real-world flows and advanced techniques, with a learner-friendly, self-paced experience and interactive support.

Explore how Power Automate fits into the Power Platform, leveraging low-code tools, ai integration with Copilot Studio, and connected data across Power BI, Power Apps, Power Pages, and more.

Power Automate, a cloud-based service, automates repetitive tasks and streamlines workflows with triggers, flows, connectors, templates, and AI features like keyphrase extraction, text recognition, and sentiment analysis.

Create a SharePoint communication site to broadcast updates and organize internal communications, then configure name, URL, description, owner, language, and time zone before creating the site.

Explore the Power Automate interface, access the portal and make Power Automate, and master the top bar, environments, templates, flows, and approvals for efficient automation.

Build a flow from the forward emails to a channel template in Power Automate to auto-forward messages to a Teams channel in a new Power Automate Mastery team.

Explore the flow details right side: manage connections with Office 365 Outlook and OneDrive for Business, verify active credentials and licensing limits, and configure primary owners and sharing for collaboration.

Navigate the central flow details to see the flow name, primary owner, status, created and modified dates, type, and plan, with guidance on ownership rotation.

Explore how the flow details page run history helps you monitor performance, identify errors, customize columns, and review all runs to make data-driven decisions and optimize Power Automate workflows.

Identify and configure triggers that initiate workflows in power automate when events occur. Learn examples like time, motion sensor, or threshold conditions to automate actions.

Create an automated flow in Power Automate that triggers when a new SharePoint list item is created, sending email notifications with task details like title, assignee, due date, and status.

Learn how variables in power automate act as placeholders that store and manage data during flow execution, enabling dynamic values, running totals, and flexible reuse across steps.

Master the compose action in Power Automate to manipulate, format, and temporarily store data within a flow, using expressions and text operations to calculate, concatenate, and extract JSON data.

Learn how to manage variables in Power Automate flows by initializing variables, using set, increment, and decrement actions, and appending to array or string variables.

Learn best practices for managing variables in Power Automate, including clear naming, minimal usage, proper scope, and avoiding overwrites with dynamic content.

Learn to create an instant flow in Power Automate and initialize an integer variable named my integer to ten. Then perform increment, decrement, multiply, and divide operations with step-by-step verification.

Master string variable manipulation in Power Automate by initializing, concatenating, trimming, replacing, and removing text, with step-by-step debugging using compose actions to ensure accurate transformations.

Initialize and toggle a boolean variable in Power Automate, use it to control flow conditions, reset it as needed, and debug with compose actions.

Learn to initialize and manipulate an array variable in Power Automate, including appending and removing items with filter array, and using compose actions to debug.

Master array manipulation in Power Automate by initializing arrays, accessing elements by index, appending and removing items, and using union and skip for advanced operations, with thorough testing.

Clear an array variable in Power Automate by using the set variable action to assign an empty array, removing all elements efficiently and keeping the flow clean.

Explore object variables in Power Automate, storing complex data as key-value pairs to manage json from APIs and SharePoint within workflows.

Retrieve data from a SharePoint list, parse it with parse JSON, and access nested fields; generate a schema, handle null values, and iterate with apply to each in Power Automate.

Navigate nested JSON structures in Power Automate using dot notation and safe navigation to access properties, while validating structures, handling nulls, and iterating through nested arrays.

Learn to access nested JSON properties in Power Automate by using dot notation, bracket notation, null conditional operator, and safe handling with compose actions and tests.

Master arrays in Power Automate by initializing an empty array, creating an array of objects with children via the compose action, and appending to another array with apply to each.

Access first, last, and custom indices in a Power Automate flow by initializing an array, testing with compose actions, and handling out of bounds errors.

master filtering arrays with multiple conditions in Power Automate using advanced mode and expression language to find adults who are male and over 20.

Learn to build a power automate flow that sorts a people array by age in ascending and descending order, then extracts only the ages for concise output.

merge two arrays in Power Automate using the union function to remove duplicates and produce a single array. ensure consistent object structure and compose actions for reliable deduplication.

Validate that merging arrays with union yields 13 unique elements, then count with length using compose actions, and follow best practices for array size checks in Power Automate.

Learn how to merge two arrays without removing duplicates in Power Automate flows, using compose actions and append to array variable to build a final merged array.

Power Automate uses the intersection function to identify common elements between two arrays, stored in two compose actions as the common items output.

Master retrieving the first n elements of an array in Power Automate using the take function, with compose actions and dynamic counts for efficient pagination.

Explore the theoretical foundations of conditions in Power Automate and how simple and complex conditions drive dynamic, data-driven workflows.

Master the if else construct in power automate to define conditions, choose true or false actions, and implement practical scenarios like sales orders and user approvals with best practices.

Learn to design nested if-else logic in workflows, using outer and inner conditions for multi-level criteria, with practical examples like discounts and multi-stage approvals.

Explore how to use logical operators (and/or) in Power Automate to evaluate multiple conditions, combining tests into a single decision block for all-true or at least one true condition.

Build a Power Automate flow that triggers on creation to email the assigned to email when SharePoint project task status is in-progress, with a null check to prevent missing data.

Explore the is not equal to operator in Power Automate, learning its case sensitive comparisons to trigger actions and enforce conditions across security, access, and subscription scenarios.

Learn to build a Power Automate flow that notifies on new SharePoint project tasks when status is not completed, using the is not equal to operator and assignment checks.

Explore the contains operator in Power Automate, performing case-sensitive substring checks for domain validation, keywords, and key features to drive data filtering and error handling.

Explore does not contain operator in Power Automate and how it validates inputs by ensuring a substring is absent, with case sensitive checks in emails, feedback, and descriptions.

Create a Power Automate flow that notifies assignees only for new SharePoint tasks whose titles do not contain non-urgent, using an automated cloud flow and conditional checks.

Learn to use the greater than operator in Power Automate to compare numbers, decimals, and dates in conditionals, with examples like age over 18, budget over 500, and due dates.

Apply the is greater than or equal to operator in Power Automate to enforce thresholds in eligibility, budgets, and scores, plus best practices for data types and testing.

Create an automated Power Automate flow that triggers on new SharePoint tasks, checks status is not completed and an assignee exists, and sends an email notification.

Master the is less than operator in Power Automate to drive conditional logic. Apply it to scenarios like age verification, inventory thresholds, and salary checks.

Create a power automate flow using the is less than condition to notify assignees of tasks due within three days in the SharePoint project tasks list, for items not completed.

Apply the is less than or equal to operator in Power Automate to thresholds such as age discounts for 12 and under, budget limits at 10,000, and grades at 70.

Power Automate flow uses is less than or equal to operator to email the assigned user for tasks due today or within three days in a SharePoint Project Tasks list.

Discover how the starts with operator in Power Automate checks if strings begin with a prefix, with case sensitivity and input validation, across email, product codes, and file names.

Build an automated Power Automate flow that notifies assignees when a SharePoint task title starts with urgent, the status is not completed, and the assignee email is present.

Explore the does not start with operator in Power Automate to validate string prefixes, enforce input rules, and filter data with case-sensitive checks across product codes, usernames, and URLs.

Learn to use the does not start with condition in Power Automate to email new SharePoint tasks that don’t start with optional, while filtering by status and assignee.

Learn how the ends with operator checks string suffixes to validate file extensions, domains, and URLs in Power Automate, with case sensitivity and practical flow examples.

Master the does not end with operator in Power Automate to validate input formats and filter data by case sensitive suffix checks. Explore practical file, email, and URL examples.

Master the switch action in Power Automate, evaluating one variable against predefined cases with a default. Improve readability and efficiency over if-else in scenarios like order status and user roles.

Practice using switch in Power Automate to send customized emails based on a SharePoint project tasks priority (high, medium, low) when a new task is created.