Microsoft Power Automate Flow Foundations A-Z

Explore three triggers in Power Automate flow foundations: button, schedule, and events, with examples like sending emails, running on a schedule, and responding to events.

Create a scheduled flow with a recurring trigger to run every three minutes, sending an email notification, then monitor status and disable to avoid monthly quota limits.

Create an instant flow in Power Automate that triggers when a file is created in OneDrive and sends an email notification.

Monitor Twitter for mentions of Microsoft Flow, including negative tweets, with a tweet monitor flow, then email those tweets to yourself for protecting your brand and supporting customers.

Create a blank flow to capture tweets and email them automatically. Trigger the flow manually, fetch three tweets from Twitter, and send separate emails containing each tweet's text.

Learn how a Twitter trigger collects tweets into an array of objects and uses apply to each to send an email for every tweet in a Power Automate flow.

Discover how dynamic content pulls information from any previous step or trigger and uses it in future actions, such as sending an email with latitude and longitude.

Begin by exploring the basics of power automate flow: variables, data types such as text, numbers, booleans, and arrays, plus expressions and simple data initialization.

Build a basic power automate flow from blank, initialize string, integer, and boolean variables, and increment age. Send an email with dynamic content and rename steps for clarity.

Master lists and arrays in Power Automate Flow Foundations A-Z by initializing or appending to a shopping list array, then email each item using apply to each.

Learn how to use Power Automate flow expressions to transform data, build a flow that emails an expressions example, and use variables to convert a city string to uppercase.

Learn to clean up a shopping list string in Power Automate using expressions such as substring, add, and length to remove the trailing comma and space.

Wrap up shows how flow variables store data across steps using initialize and set variable. Use expressions to convert types, get string length, substrings, contains checks, and time calculations.

Learn to integrate flow with SharePoint by adding and querying list items using OData, a standard across Microsoft products, with a premium flow account (free 90-day SharePoint trial available).

Learn to get a free 90‑day SharePoint account via the Microsoft 365 developer program, add the SharePoint license in the admin center, and create a communication site in 10–15 minutes.

Create a SharePoint shopping list, add columns for quantity, description, and in stock, then add and manage items such as oranges to prepare for flow.

Create a flow to add items to a SharePoint list from a button; configure site, select the list, map title, quantity, description, and stock, then save and test.

Duplicate and enable a flow with a manual trigger, then map form inputs, title, description, quantity, and in stock, to a SharePoint list item.

Delete items from a SharePoint list using a Power Automate flow by configuring a unique item identifier, exposing a flow button input, and validating deletion with a test.

Update shopping list items in a SharePoint list by modifying the item title and description through a Power Automate flow, using get item to preserve required fields.

Explore how OData enables querying and filtering of lists, returning only items that match criteria such as category equals fruit or first name equals Scott for interoperable RESTful access.

Learn how to query SharePoint items in Power Automate flow, using get items with filter queries, and delete matching items with apply to each.

Spot a common SharePoint flow pitfall where spaces in field names break get items queries, and fix it by removing spaces or using underscores; test the flow.

Wrap up by showing how to add, update, delete, and query shopping list items in SharePoint using flows, and handle required fields and spaces in column names.

Explore control flow in Microsoft Power Automate, covering if-else conditions, loop types with their benefits and drawbacks, and switch statements to route multiple actions based on conditions.

Explore if statements in Power Automate flow foundations by building a voting eligibility check that sends email notifications based on age 18 or older, using condition actions and flow paths.

Demonstrate the apply to each loop over an array of names, sending each a random lottery number by email, using current item and rand(min, max), with empty arrays skipping execution.

Use a do until loop to accumulate six lotto numbers by appending random values to an array until its length is six, with a safety guard.

See how a switch statement in Power Automate directs multiple paths based on the day of week, with a default fallback and email actions for Friday and Sunday.

Wraps up control flow by reviewing if-then-else, for each, do until, and switch statements, showing how conditions drive flow paths and item processing.

Explore Twitter data with Microsoft Power Automate flow foundations a-z by scheduling flows, delaying steps, and exporting tweets to Excel for daily social media review.

Explore how to access premium flow features with a free 90-day developer account, and follow setup steps including SharePoint developer setup and accessing Power Automate flow.

Design a Power Automate flow that posts to Twitter only after an approval, using start and wait for an approval and the approvals module to ensure approve or reject decisions.

Automate saving tweets to an Excel file with Power Automate flow, triggering on new tweets and adding rows to a OneDrive Excel table.

Schedule flows to run at set intervals and insert delays between steps, then manually trigger a flow that posts tweet text to Twitter after a delay.

Wrap up essential Power Automate basics: manage Twitter content, approvals, and Excel data with add-to-table, delays, and scheduling, and explore more advanced flow features.

Explore advanced foundational features of flow, including branching two parallel flows, merging back into the same flow, organizing steps with scope, and terminating flows to flag success or error.

Discover how to add parallel branches in a Power Automate flow to run two emails simultaneously on a manual trigger, with each branch executing independently.

Merge parallel branches in a flow so an action runs only after both branches finish, then send an email saying both branches have finished running.

Discover how to use scope to organize complex Power Automate flows by grouping actions, collapsing steps, and expanding for quick, team-friendly editing.

Learn to insert a terminate action in a Power Automate flow to stop at a step, set status (failed, canceled, or succeeded), and halt subsequent actions.

Explore integrating machine learning with flows using filters, including sentiment analysis, image and text recognition, and a custom model to classify animals, plus error handling and notifications.

Explore sentiment analysis in Power Automate, using predefined models to classify text as positive, negative, or neutral for automation workflows.

Build a Power Automate flow called image to text that uploads an image, uses a text recognition model, and emails extracted text by initializing a variable and appending lines.

Learn how to handle errors in a flow when an image to text step fails by adding a parallel branch and sending an email notification.

Create a custom object detection model to recognize cats and dolphins by uploading 15 images per class, tagging them, training, and publishing for flows; test and expect 70-90 percent performance.

Create a Power Automate flow using an animals model to detect cats or dolphins in an image. Iterate results, append detected tags to a string, and email the image content.

Wrap up ai builder features in power automate, covering sentiment analysis of text and image-to-text extraction, with error handling and custom models for image recognition.

Explore advanced features of power automate flow, including api integration, triggering flows from apps, and calling public APIs to exchange data with Twitter, Facebook, Salesforce.

Learn to use Postman to test public APIs, trigger a Power Automate flow, and send requests to endpoints to retrieve data.

Explore HTTP and REST concepts, including GET, POST, PUT, and DELETE, and learn how APIs trigger flows, pass data, and exchange JSON payloads with web apps.

Define JSON as JavaScript object notation, a universal data exchange format; show key-value access and illustrate using JSON with Power Automate flow and HTTP API calls.

Trigger a flow from an http request using a json payload and a content-type header. Generate the request schema, test with Postman, and receive an email notification from the flow.

Wrap up advanced features of Power Automate flow foundations by reviewing get, post, put, and delete methods, API data exchanges, and integrating flows with external apps via API calls.