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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.