Power Automate for Beginners: Build Cloud Flows with AI

Explore how flow type is defined by trigger type in Power Automate cloud flows—automated, instant, and scheduled—each responding to events, user actions, or time.

Add input parameters to an instant cloud flow, letting a push-button trigger accept audience name and reply-by date to customize the email subject and content.

Learn to run instant cloud flows from the Power Automate mobile app, entering inputs like audience name and date, and confirm execution on your device, with SharePoint setup ahead.

Create a SharePoint site with a document library and a CSV-based list, mapping fields and adjusting columns. Use a flow to email product details, then replicate the approach in Excel.

Create instant cloud flows in Power Automate from a SharePoint list item to send product emails. Capture recipient, amount, due date, and notes from user input and the list item.

Explore implementing a scheduled cloud flow in Power Automate using a recurrence trigger, configuring hourly intervals, start times, time zones, testing, and on/off controls.

Explore automated cloud flows in Power Automate for SharePoint list changes, using triggers that fire on item creation and send email actions capturing properties like title and expiry date.

Explore variables and arrays in Power Automate flow, including six actions that work with variables and initialize variable, and choose types—boolean, integer, float, string, object, and array—within this beginner course.

Initialize and set string variables in an instant cloud flow, defining a name and an initial value, then reassign with set variable and append to the email body.

Learn to work with numeric variables in Power Automate, including integers and floats, and use expressions to sum trigger inputs.

Explore boolean variables and simple add and greater-than actions in Power Automate cloud flows, and compare the modern and classic designers for building and testing expressions.

Learn to work with array variables in Power Automate, initialize and append items to arrays, understand zero-based indexing, and manage string arrays for data from external sources.

Demonstrate how to use the apply to each loop in Power Automate to iterate over a cities array, sending one email per city and then composing a single all-cities email.

Define object variables in Power Automate using JSON with properties like name, age, height, and hair color, then access them via expressions to build dynamic emails.

Connect to a SharePoint list and fetch a single item with the get item action, then add product name, description, and price to an email flow.

Fetch all SharePoint list items with get items as an array, then use apply to each in a manual Power Automate flow to email all products in one message.

Learn to filter SharePoint list items with a condition inside an apply to each, select products under 20, append them to a string, and email the results.

Learn to use OData filters with SharePoint in Power Automate to retrieve items with unit price less than or equal to 20, using internal field names and sorting by title.

Create and manage SharePoint list items using Power Automate, adding a product category as a choice and using create item in an instant cloud flow while handling custom category values.

Update a SharePoint list item with the Update item action in Power Automate by supplying a product id and new description, including tips on the modern designer.

Lookup the item by title using a get items with an OData filter, obtain its ID, and update the item description with that ID.

Learn to delete a single SharePoint list item by ID, then scale to delete multiple items by category using get items and apply to each in Power Automate, with testing.

Create an automated cloud flow that triggers on a SharePoint list item deletion and sends a notification email, noting the item properties while checking the recycle bin, second stage.

Explore how to access and work with files in a SharePoint document library from Flow, using get items or get files, and retrieve file content for email delivery.

Create a flow that uses the create file action to save a text file in a SharePoint library folder, driven by user-provided file name and content.

Create a cloud flow that triggers on incoming Office 365 Outlook emails and saves the subject and rich-text body to a SharePoint list named email archive, using a high-importance filter.

Master flow control in Power Automate by exploring conditions, apply to each, switch, scope, and terminate, and learn how run after properties and approvals guide decisions.

Explore when to use a condition versus a switch in power automate by updating personal care prices with a $2 increase via get items, apply to each, and update item.

Master switch in Power Automate flows to adjust unit prices by category, excluding nulls, applying case-specific updates for personal care, lighting, and defaults, with designer caveats.

Explore how to add scope to a Power Automate flow and group actions, then compare sequential versus parallel execution using branches to optimize delays in a SharePoint item workflow.

Learn to add parallel branches in a Power Automate flow, speeding execution by running scopes in parallel and merging branches after tasks complete, keeping branch actions independent.

Learn how terminate ends a flow and how compose captures complex data for debugging in Power Automate. Combine them to track status and error details in history.

Explore run after logic in a manual trigger flow that retrieves a single SharePoint item by product ID, emails the result, and handles success or failure with conditional actions.

Explore approval actions in Power Automate, enabling human input mid‑workflow. Build a SharePoint back order queue, compute total cost, and route under or over 500 for processing or manager approval.

Explore using approval actions in Power Automate Flow, including create and wait for approval, handling multiple approvers with different types, and notifying the requester or recording outcomes.

Build an instant cloud flow in Power Automate that starts and waits for text approval, lets a manager review and adjust the email, and sends the final message upon approval.

Create your first child flow by building a manually triggered flow with a respond action, add an input parameter, and return a greeting that uses the trigger data.

Learn to call a child flow from a parent flow using the Run a Child Flow action, within a solution, because calls outside a solution fail.

Add a SharePoint connection to a child flow, read a product item by id, and append its title to the greeting, then test the parent-child flow.

Learn flow ownership and authoring by setting a primary owner, adding co-owners, and sharing flows for collaboration. Review run permissions, connection permissions, and the license to run a flow.

Configure run permissions for instant cloud flows, assigning run only users or groups via SharePoint lists, libraries, or Active Directory to control who can manually trigger flows.

Discover how to secure cloud flow connections by using run-only credentials vs fixed credentials, borrow permissions safely for SharePoint, and apply system accounts for resource access.

Learn the basics of Power Automate licensing, including seed licenses, standard vs premium connectors (such as Dataverse), and how the license follows the flow runner rather than the owner.

Prepare your Excel file for Power Automate by placing it in SharePoint or OneDrive and converting data to a named Excel table with headers for flow access.

Fire a flow directly from an Excel table row with a selected row trigger in Power Automate. Connect to the default environment and pass product, price, category, and expiry date.

Trigger a Power Automate flow to read a single row from an Excel table on SharePoint and copy it to a SharePoint list, mapping product fields and converting date formats.

Learn to use the list rows present in a table action for Excel in Power Automate and apply OData filters. Handle issues like spaces in column names and null values.

Learn to create, update, and delete Excel table rows with Power Automate flows, including generating unique IDs, updating prices with numeric conversion, and filtering deletions via apply to each.

Explore AI builder in Power Automate to extract business card details from images and automatically add them to an Excel sheet via a cloud flow, using SharePoint libraries and folders.

Learn to speed up Power Automate cloud flows with AI Builder while avoiding dangerous trigger changes, using backups, child flows, and file identifiers to parse AI Builder output into Excel.

Learn to integrate ChatGPT inside Power Automate cloud flows using prompts, create and test prompts in AI prompts hub, and extract items from text with AI builder.

Combine AI prompts in Power Automate to generate text and pass outputs between prompts, then handle approval warnings while automating an animal food request workflow.

Learn to refine Power Automate cloud flows by using AI prompts to generate HTML tags and code, handling newline formatting with replace expressions, variables, and approvals.

Master how to generate structured JSON output from AI prompts and integrate it into Power Automate flows. Learn to design prompts, test outputs, and map data into arrays and tables.

Master AI builder basics for Power Automate, focusing on input, instructions, and output. Use prompts and GPT actions to extract data from business cards, invoices, and receipts with JSON output.

Explore describe it to design it, guiding Copilot to build Power Automate flows by describing outcomes, harnessing AI to follow standards and boost consistency.

Set expectations from artificial intelligence in Power Automate by describing it to design, then build a SharePoint item trigger that emails the creator with the item title in the subject.

Learn to translate ai-assisted design ideas into a working Power Automate flow that triggers from a button, pulls SharePoint items, builds an HTML table, and emails it.

Explore how copilot writes flow expressions to update SharePoint list items, applying an OData filter to add 10% to the unit price for personal care products.

Build a flow that triggers on form submissions, retrieves response details, and posts a notification to a Teams chat with the user's age, location, and education level, guided by copilot.

Explore Copilot in Power Automate cloud flows, compare it with ai builder actions, and use prompts to generate text or json outputs for small to medium flows.