The full
library.
223 tutorials and growing — filter by product, difficulty, or topic to find what you need.
Structuring Power Automate Flows for Enterprise Success
Core principles for resilient, maintainable, and efficient cloud flows, distilled from real-world implementations.
From Breaking to Resilient: Three Error-Handling Strategies in Power Automate
Build flows that gracefully handle failures and automatically notify you with run details.
Embedding Images in Power Automate Emails: A Cross-Client Compatibility Guide
Discover the trade-offs between Content-ID, Base64, and the Microsoft Graph API for embedding images in Power Automate emails. This guide covers which method works best for Outlook, Gmail, and more.
How to Bypass the 'File Is Locked' Error When Using Excel and SharePoint in Power Automate
When a flow reads an Excel table and then updates SharePoint file properties, the file remains locked. Here are four independent approaches to work around it—no magic, just smart automation design.
Power Automate Select Action: Beyond Basic Column Picking – 5 Advanced Transformations
Transform arrays like a pro: add computed columns, row numbers, convert data types, and extract flat value lists using the Select action's hidden capabilities.
From Raw Strings to Structured Data: A Guide to Power Automate Text Functions
Step beyond simple reference lists and learn how to build a real-world text parsing pipeline using Power Automate's complete string toolkit.
Forcing Approval Revocation with the Teams HTTP API
The standard approval connector doesn't expose a cancel method, but a direct HTTP call to the Microsoft Teams Approvals backend makes it possible. Here's a safe, production-ready approach.
ServiceNow–Power Automate Integration: Authenticated Connection Setup
Set up a reliable service account in ServiceNow and configure Power Automate with Basic or OAuth2 authentication to automate cross-platform workflows.
Automated Excel Report Generation from SharePoint Lists with Power Automate
Build a dynamic flow that creates an Excel file from any SharePoint list without predefining columns, using the SharePoint REST API and Excel connector.
Automate Contract Sorting in SharePoint with Azure AI and Power Automate
Use a custom classifier built with Azure AI Document Intelligence to automatically tag uploaded legal documents with their contract type and confidence score.
Multi-Step Approval Chaining in Power Automate
Set up a sequential approval process that sends documents to reviewers one after another, with automatic status tracking and audit logs in SharePoint.
Architecting Long-Running Approvals in Power Automate (No 30-Day Limit)
Separate approval creation from outcome collection with two cooperating flows to support indefinite wait periods.
Streamline Invoice Processing with AI Builder and Power Automate
Automatically extract invoice details from email attachments, evaluate confidence, and manage exceptions with minimal human effort.
Build Arrays Faster in Power Automate: Three Techniques Compared
Collecting items into an array is a routine task in automation. The technique you choose—variables, compose, or the Select action—can drastically influence flow execution time.
How to Extract 50,000 Excel Rows in Seconds Using Power Automate and Graph API
Bypass the sluggish Excel Online connector and pull huge datasets directly via Microsoft Graph API — complete with data flattening and schema mapping.
Automate Excel Reporting: Populate Templates from JSON Data
Learn how Power Automate can fill single cells and expand table rows in an Excel template, enabling dynamic report generation without manual edits.
Build Eye-Catching HTML Table Emails with Power Automate
Learn how to automatically create a styled HTML table from SharePoint data and embed it in an email, using basic Power Automate actions and a pinch of CSS.
Beyond the 5000 Limit: Fetching SharePoint List Items with Pagination in Power Automate
Learn how to retrieve more than 5000 items from SharePoint using Power Automate's built-in pagination or the REST API for even larger datasets.
Keep Critical Credentials Hidden in Power Automate Runs
Stop leaking secrets in flow execution logs by combining Azure Key Vault with secure input/output settings.
Sync Oversized SharePoint Documents to Copilot Studio Knowledge via Power Automate
Bypass the 7 MB SharePoint limit by programmatically uploading files directly to your agent’s knowledge store.
Sending SharePoint Files for Review: Power Automate Approval Attachments
Attach files directly to your Power Automate approvals. Master the distinct patterns needed for SharePoint Document Libraries and List Item Attachments.
Update Email Subjects Post-Delivery Using Power Automate and Graph API
Power Automate offers no standard action to change a received email’s subject. Instead, leverage the Microsoft Graph API through the built-in HTTP request action to modify the subject line without premium licensing.
Simplify File Sharing with Power Automate Links
Generate secure, granular sharing links for your SharePoint files—from anonymous access to specific users—all within automated workflows.
Extract Live Web Data into Structured Records with AI Prompts
Learn how to combine an HTTP action with a custom GPT prompt to scrape server-rendered web pages and transform the content into actionable Dataverse or SharePoint data.
Parsing Table Data from PDFs in Power Automate with Azure AI
Leverage Azure AI Document Intelligence's pre-built Layout model to capture structured row-and-column data from PDF invoices, reports, and forms directly inside your Power Automate workflows.
Power Automate: Excel Table Row Filtering Beyond ODATA – Text, Numbers, Dates
Filter Excel table rows in Power Automate with ODATA for text, but learn reliable workarounds for numeric and date columns that refuse to cooperate.
Extract Approval Comments and Store Them in SharePoint via Power Automate
Approval comments come back as an array in Power Automate. This guide shows how to convert them into a clean multi‑line string and save them to a SharePoint list.
Bypassing Outlook's 25-Email Limit with Power Automate
The standard 'Get Emails (V3)' action limits you to 25 items. Use the 'Send an HTTP request' action with the Microsoft Graph API to fetch hundreds of emails efficiently.
Automating Manager Approval Requests with Power Automate
Streamline leave-request approvals by automatically routing the request to each employee's manager, using either the Office 365 directory or a custom manager lookup list.
Automated Email Categorization with Power Automate and Graph API
Apply custom Outlook categories to incoming messages based on conditions, using a simple PATCH request to the Microsoft Graph.