Power Automate Tips ⚙️
#PowerPlatformTip 154 – ‘Preserve Author, Editor & Dates on Copied SharePoint Files’
When you have to copy-and-delete a SharePoint file, it loses its original Created By, Modified By and timestamps. One ‘Send an HTTP request to SharePoint’ ME...
#PowerPlatformTip 153 – ‘Rename a SharePoint File with Power Automate’
The SharePoint connector has no ‘Rename file’ action — but you don’t need one. A single ‘Send an HTTP request to SharePoint’ call that MERGEs the FileLeafRef...
#PowerPlatformTip 150 – ‘JSON & HTML to Markdown with Office Scripts’
Turn JSON arrays and HTML into clean Markdown right inside a flow — with pure code, no AI. Two small Office Scripts do the formatting, Power Automate passes ...
#PowerPlatformTip 149 – ‘Approvals to a Shared Mailbox’
Sending a Power Automate approval to a shared mailbox looks fine – until someone clicks. The ‘Start and wait for an approval’ task is bound to a single ident...
#PowerPlatformTip 148 – ‘Limit Apply to Each with take()’
Stop burning hundreds of flow runs while testing loops. The take() expression lets you limit your Apply to Each loop to exactly the first X items from any ar...
#PowerPlatformTip 147 – Dummy Patch After Complex Flows
Complex Flows with approvals/fallbacks updating lists? Use Dummy Patch on GalleryExample.selected + RefreshHack column for precise single-record refresh – sk...
#PowerPlatformTip 146 – Encode & Decode Functions
Passing URLs, JSON data, or text with special characters between systems? Encoding prevents quotes, apostrophes, and special characters from breaking your fl...
#PowerPlatformTip 145 – ‘Power Platform Tools’
Streamline your development workflow with Power Platform Tools, a centralized suite of browser-based utilities for developers. This all-in-one toolbox simpli...
#PowerPlatformTip 144 – Infinite Approvals beyond 30 days
Infinite Approvals lets you build Power Automate approval flows that survive beyond the 30-day timeout limit by safely restarting themselves. You can either ...
#PowerPlatformTip 143 – Reduce AI Costs with Thumbnail-First Document Processing
With AI Builder credits ending November 1, 2025, and Copilot Credits costing significantly more, organizations need smarter AI processing strategies. Process...
#PowerPlatformTip 142 – Automate Outlook Categories
Learn how to automatically set categories for Outlook meetings using a standard, non-premium Power Automate action. Save time and stay organized with this si...
#PowerPlatformTip 141 – Text to Array
Convert multiline text into an array in Power Automate using split() — ideal for processing lists from Excel, emails or Power Apps.
#PowerPlatformTip 140 – Free Invoice OCR (Process 500 PDFs/Month for €0)
Build a Power Automate flow that reads and summarises up to 500 PDF invoices every month - completely free with Adobe, Cloudmersive, or Azure plus Azure AI L...
#PowerPlatformTip 139 – ‘Plus Address Tracking’
Use plus addressing in Power Automate, Outlook, and Gmail to tag every automated email with its source for instant traceability.
#PowerPlatformTip 138 – ‘Graph API via HTTP with Microsoft Entra ID’
Use the preauthorized ‘HTTP with Microsoft Entra ID’ connector in Power Automate to call Microsoft Graph without a custom app registration.
#PowerPlatformTip 135 – ‘One Flow, Many Users’
Use Power Apps and Adaptive Cards to let everyone in your company trigger flows in their own context – without Outlook permission chaos or flow duplication.
#PowerPlatformTip 133 – ‘SharePoint Updates with Power Automate – No Required Fields Needed’
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
#PowerPlatformTip 129 – ‘Case-sensitive SharePoint Filtering’
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
#PowerPlatformTip 128 – ‘Dynamic Data Retrieval’
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
#PowerPlatformTip 126 – ‘User Context for Automated Tasks’
Automate user-specific tasks like setting OOO replies and Teams notifications centrally while allowing users to customize messages before scheduled flows run.
#PowerPlatformTip 125 – ‘Convert CSV to JSON’
Convert CSV data into JSON in Power Automate using only standard actions without premium connectors or external services.
#PowerPlatformTip 124 – ‘Recognize Plain Text File Formats’
Learn how to use plain text file formats in Power Automate’s Get File Content action to simplify processing by avoiding Base64 decoding.
#PowerPlatformTip 123 – ‘Get Lowest / Highest SharePoint ID & TotalCount’
Efficiently retrieve the highest, lowest, and total item IDs from a SharePoint list in Power Automate for advanced list analytics and data management.
#PowerPlatformTip 122 – ‘Track Flow Progress in PowerApps’
Monitor Power Automate flow progress in PowerApps by creating a StateLog and using a timer to fetch real-time updates.
#PowerPlatformTip 121 – ‘Filtering SharePoint File Fields with OData’
Quickly and efficiently filter SharePoint files in Power Automate by using FileLeafRef (file name), FileRef (full path), and FileDirRef (folder) fields with ...
#PowerPlatformTip 120 – ‘PowerAutomate – Text Processing 2.0’
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
#PowerPlatformTip 119 – ‘Web-Based Editing with VS Code’
Use VS Code in the browser to provide a flexible, spacious editor for complex Power Platform scripts, formulas, and expressions.
#PowerPlatformTip 118 – ‘Copy Actions in Switch/Condition’
Copy actions or scopes into a Switch or Condition in Power Automate without the errors caused by unresolved dynamic-content references.
#PowerPlatformTip 117 – ‘Optimize Parallel Object Processing’
Speed up large-item processing in Power Automate by leveraging child flows, database triggers, and strategic ‘Respond to a PowerApp or flow’ placement.
#PowerPlatformTip 116 – ‘AI Automated Solution Design’
Quickly overview a comprehensive Solution Design for PowerApps and Power Automate using ChatGPT, Voice-to-Text, and Diagram-GPT.
#PowerPlatformTip 115 – ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
#PowerPlatformTip 104 – ‘Efficient JSON Handling’
Master JSON structure and schema validation in Power Automate to ensure robust data processing, minimize errors, and optimize automation workflows.
#PowerPlatformTip 100 – ‘Bypassing Complexity in PowerAutomate’
Streamline Power Automate flows by replacing complex Switch and Condition actions with dynamic JSON objects and formulas for faster, more maintainable automa...
#PowerPlatformTip 102 – ‘Event Coordination’
Silently manage event attendees in Power Automate using Microsoft Graph API—add guests without notifications and keep attendee lists private for secure event...
#PowerPlatformTip 105 – ‘PowerApps – EnvironmentVariables Without Premium’
Access environment variables in PowerApps without a premium license by leveraging Power Automate flows—enable cost-effective, centralized configuration for a...
#PowerPlatformTip 114 – ‘Send Approvals to External Recipients’
Send Power Automate approval requests to external recipients using Adaptive Cards or email, enabling secure, flexible workflows beyond your organization.
#PowerPlatformTip 112 – ‘Consistent Data Formats’
Harmonize data formats in Power Apps and Power Automate by trimming spaces, standardizing case, and matching types to prevent comparison and validation errors.
#PowerPlatformTip 111 – ‘Adaptive Cards for Dynamic Approvals’
Use Adaptive Cards and Office 365 User Search in Power Automate to dynamically select the next approver, enhancing approval process flexibility.
#PowerPlatformTip 109 – ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
#PowerPlatformTip 106 – ‘Word & Quick Parts’
Automate Word documents for free using Quick Parts placeholders filled by a standard Power Automate flow — no premium license needed.
#PowerPlatformTip 99 – ‘Timesaver Toolkits – ChatGPT and Flow’
Boost productivity by combining ChatGPT and Power Automate—dictate ideas, automate task structuring, and streamline workflows with AI-powered toolkits and fl...
#PowerPlatformTip 98 – ‘Secure Inputs / Secure Outputs’
Protect sensitive data in Power Automate by enabling Secure Inputs and Secure Outputs—mask confidential information in flow logs, enhance compliance, and sec...
#PowerPlatformTip 97 – ‘Enhanced Pagination’
Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint—retrieve more data, improve performance, and streamli...
#PowerPlatformTip 96 – ‘Scraping Web Data with Standard Connectors’
Scrape and store website content in Power Automate using the OneDrive connector—fetch HTML data cost-effectively, automate extraction, and avoid premium conn...
#PowerPlatformTip 95 – ‘Optimized SharePoint Queries’
Optimize SharePoint queries in Power Automate using OData filter options—improve data filtering, workflow efficiency, and minimize processing for large lists.
#PowerPlatformTip 94 – ‘Extract Text from DOCX’
Extract text from DOCX files in Power Automate using native actions—eliminate third-party dependencies and streamline document processing and integration.
#PowerPlatformTip 92 – ‘Free PDF Tools in PowerAutomate’
Discover the best free PDF tools for Power Automate—compare features, integrations, and value to automate document workflows without extra cost.
#PowerPlatformTip 90 – ‘Power Platform Community Developer Plan’
Leverage the Power Platform Community Developer Plan for a free, robust environment to build, test, and share Power Apps and Power Automate solutions—ideal f...
#PowerPlatformTip 89 – ‘Code View (Peek Code)’
Use Code View in Power Automate to inspect action expressions in a read-only format—gain insight, debug flows, and understand logic for more effective troubl...
#PowerPlatformTip 88 – ‘Expert Help When You Need It Most – ThePowerAddicts.com’
Get on-demand expert help and 1:1 coaching from Microsoft MVPs at ThePowerAddicts.com—receive unbiased advice, governance checkups, and targeted Power Platfo...
#PowerPlatformTip 83 – ‘Organize Power Automate Chat Messages’
Organize Power Automate notifications in Microsoft Teams by routing messages to topic-specific group chats—reduce clutter, improve collaboration, and streaml...
#PowerPlatformTip 77 – ‘Optimize Parallel Object Processing’
Boost Power Automate performance by enabling parallel object processing—use child flows or database triggers to overcome concurrency limits and accelerate la...
#PowerPlatformTip 75 – ‘Boost Efficiency with Concurrency Control’
Enable Concurrency Control in Power Automate to process ‘For Each’ loops in parallel, dramatically improving flow speed, scalability, and automation efficien...
#PowerPlatformTip 74 – ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows—enable secure actions beyond user rights, leveraging impersonation and ad...
#PowerPlatformTip 71 – ‘Array to Object’
Convert arrays to objects in Power Automate using Select and Replace actions for efficient data transformation, automation, and integration with downstream s...
#PowerPlatformTip 70 – ‘Managing Teams with PowerApps!’
Manage Teams environments more effectively by switching to powerautomate.com and using a simple URL trick to open PowerApps4Teams in make.powerapps.com—strea...
#PowerPlatformTip 61 – ‘Power of Environment Variables’
Unlock the power of environment variables in Power Platform. Learn how to manage configurations, streamline deployments, and boost app flexibility with best ...
#PowerPlatformTip 59 – ‘Handle Dynamic Content’
Handle dynamic content in Power Automate with confidence. Learn best practices for managing unpredictable data, parsing values, and building robust, error-re...
#PowerPlatformTip 58 – ‘HTTP Actions’
Automate web requests in Power Automate with HTTP actions. Learn how to connect to APIs, send and receive data, and integrate external services for advanced ...
#PowerPlatformTip 52 – ‘DV4T: Budget-Friendly Choice’
Save on licensing costs and boost performance by using Dataverse for Teams as a robust, scalable data platform for Power Apps and Power Automate. Learn how t...
#PowerPlatformTip 51 – ‘Which Flow Calls Which Flow’
Easily trace which Power Automate flow triggers another. Use this tip to document, debug, and maintain complex Power Platform automations with confidence.
#PowerPlatformTip 50 – ‘Use TemplateApp’
Kickstart your Power Platform projects with Template Apps. Discover how to use, customize, and deploy ready-made solutions to save time and accelerate app de...
#PowerPlatformTip 49 – ‘Do-Until’
Automate repetitive tasks in Power Automate with the Do Until loop. Learn how to build robust flows that wait for conditions, retry actions, and handle dynam...
#PowerPlatformTip 48 – ‘Sharing of Flows & Power Apps’
Easily share Power Automate flows and Power Apps with colleagues. Learn best practices for secure sharing, permissions, and collaboration in the Power Platfo...
#PowerPlatformTip 47 – ‘Batch-Method within SharePoint’
Accelerate bulk SharePoint list operations in Power Automate using the SharePoint REST batch method. Create, update, or delete up to 1,000 items per call to ...
#PowerPlatformTip 45 – ‘Use Scopes’
Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure.
#PowerPlatformTip 44 – ‘Calculate the Distance’
Calculate accurate great-circle distances directly in your Power Platform app using the Haversine formula and a ready-made JSON snippet.
#PowerPlatformTip 41 – ‘Standard tables in Dataverse’
Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling.
#PowerPlatformTip 40 – ‘Delete Apps / Flows’
Efficiently remove outdated test apps and flows in Power Platform by exporting and reimporting solutions. Declutter your workspace with bulk cleanup.
#PowerPlatformTip 37 – ‘Table to JSON’
Convert two-column tables to JSON in Power Automate for easier data access. Use Parse JSON for efficient data transformation and automation.
#PowerPlatformTip 36 – ‘Static Result’
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
#PowerPlatformTip 35 – ‘Concurrent Control’
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
#PowerPlatformTip 34 – ‘PowerApps V2’
Use the PowerApps V2 trigger in Power Automate for enhanced security, precise input control, and flexible flow management. Improve integration and automation.
#PowerPlatformTip 33 – ‘Coalesce’
Use Coalesce in PowerApps and Power Automate to simplify handling blank values and reduce nested If statements. Improve formula efficiency.
#PowerPlatformTip 29 – ‘ParseJSON Description’
Add custom descriptions in Power Automate’s Parse JSON action to organize and distinguish similar Dynamic Content entries. Improve flow clarity.
#PowerPlatformTip 27 – ‘Overwrite existing files’ (The Settings Hack)
Enable file overwriting in SharePoint by disabling ‘Allow Chunking’ – a simple settings tweak that unlocks the hidden overwrite toggle in Power Automate.
#PowerPlatformTip 24 – ‘Merge arrays or tables’
Merge arrays or tables in Power Automate while preserving duplicates using concat and split functions. Simplify data manipulation workflows.
#PowerPlatformTip 21 – ‘Use Triggeroutput’
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
#PowerPlatformTip 20 – ‘Change Flow-Owner’
Change a Power Automate flow owner in place by making it solution-aware. Avoid export/import and keep all connections and run history intact.
#PowerPlatformTip 19 – ‘Resize files’
Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation.
#PowerPlatformTip 18 – ‘Download & Save Files’
Download and save public or password-protected files in Power Automate using HTTP requests and file management actions. Ensure secure, automated file handling.
#PowerPlatformTip 17 – ‘Format data by example’
Master data formatting in Power Automate! Use ‘Format data by example’ — or its Copilot successor, the expression assistant — to generate accurate expression...
#PowerPlatformTip 15 – ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
#PowerPlatformTip 12 – ‘Components for PowerAutomate’
Boost productivity in Power Automate by saving and reusing scopes with the clipboard feature. Streamline flow development and ensure consistency.
#PowerPlatformTip 11 – ‘Trigger Condition’
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
#PowerPlatformTip 9 – ‘Test Your Flow Before Activation’
Test Power Automate flows before activation: Use the built-in Test feature to catch errors early, improve reliability, and streamline flow development.
#PowerPlatformTip 8 – ‘Automate Backups & Restores for Flows, Apps & Solutions’
Power Automate has no one-click restore for a deleted or broken flow. Automate exporting and importing your flows, apps and solutions so you always have a ba...
#PowerPlatformTip 7 – ‘UNION and FilterArray’
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
#PowerPlatformTip 6 – ‘formatDateTime in utcNow’
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
#PowerPlatformTip 5 – ‘Less Variables’
Reduce variables in Power Automate by using Parse JSON or Compose for static parameters. Keep flows readable and loop concurrency intact—reserve variables fo...
#PowerPlatformTip 4 – ‘JSON Viewer’
Visualize and format JSON data in Power Automate using a browser extension. Simplify data handling, boost productivity, and make complex JSON easy to read.
#PowerPlatformTip 3 – ‘Advanced Filtering Array’
Unlock advanced filtering in Power Automate: Use Filter Array with custom expressions to streamline flows, boost accuracy, and optimize workflow performance.
Extract HTML Table from Email in Power Automate – Advanced XML Processing Techniques by Damien Bird
Master the art of extracting HTML tables from emails using Power Automate with XML processing techniques. Damien Bird demonstrates advanced XPath methods for...
How to Restore and Create a Backup from a Flow
Safeguarding your workflows with Power Automate: Learn comprehensive methods to create and restore backups for your flows using solutions and direct flow man...
Return an Array from PowerAutomate to PowerApps (Split Method without Premium)
Basically, there are already some posts and videos on this topic. However, I would like to point out a great post incl. app for generating the function by Br...
Run Power Apps Connections with Elevated Permissions via Power Automate – Impersonate Flow Actions from Reza Dorrani
Learn how to enable end users to perform actions with elevated permissions in Power Apps using Power Automate’s impersonation features. Reza Dorrani demonstr...
How to Track the Current Progress of a Flow in PowerApps
Learn how to track Power Automate flow progress in real-time within your PowerApps using a StateLog table and timer controls. Complete solution with download...
Fill and Sign a Word Document with Power Apps and Power Automate without using any premium actions from Paulie M
Simply convert a Word into a zip file, replace the data a little and convert it back into a zip file -> Ingenious way to create a Word file without premiu...
Power Automate Flows vs Automate Rules – Performance and Efficiency Comparison by Daniel Christian
Explore the differences between Power Automate Flows and SharePoint Automate Rules. Daniel Christian analyzes performance implications and optimal use cases ...
How to Send a 1:1 Message via Power Automate in Teams – Direct Personal Messaging Solution
Learn how to send direct 1:1 messages via Power Automate in Microsoft Teams using your own account instead of the flow bot. Perfect for personal communicatio...
PowerApps PDF Viewer SharePoint Document Library without Flow from Reza Dorrani
A great video, which replaces all the cumbersome workarounds via PowerAutomate. Here you learn how to simply ‘manipulate’ data and thus directly view PDF fil...
How to Restore an Earlier Version of Your Flow (Power Automate) from John Liu
Discover PowerStudio.app, an exciting platform for building and tracking flows at scale. Learn how to restore flow versions with built-in version history fun...
Power Apps Print Directly to a Printer with an API – PDFs, Labels, Barcodes, and More with Flow from Shane Young
Discover how to print directly from Power Apps using an innovative API workaround. Shane Young demonstrates printing PDFs, labels, barcodes, and more using P...