Power Automate Tips & Tutorials | PowerPlatformTip
Practical, tested Power Automate solutions — cloud flows, expressions, connectors, HTTP requests and error handling. Newest first.
Power Automate is Microsoft’s low-code automation tool for building cloud flows that connect apps and services, and desktop flows (RPA) that drive the UI of legacy apps with no API. Typical use cases: routing approvals, sending notifications when a record changes, syncing data between SharePoint, Dataverse or SQL, and calling external APIs over HTTP. The tips below cover the parts that actually trip people up in real projects: writing and debugging expressions, error handling with Scope/Catch, working around connector limits, and getting HTTP requests right the first time.
⚙️ Cloud flow or desktop flow? Read Cloud Flows vs Desktop Flows. Also compare trigger types and standard vs premium vs custom connectors.
🖥️ Automating an app that has no API? Read Computer use (CUA) in Copilot Studio, AI-driven UI automation vs classic RPA.
Power Apps · Power Automate · SharePoint · Dataverse · Copilot Studio · AI & Copilot
- #PowerPlatformTip 168: 'Collect Failed Action Details with the result() Function' Oct 08, 2026
- #PowerPlatformTip 167: 'Date Math Without a dateDiff() - the ticks() Trick' Sep 25, 2026
- #PowerPlatformTip 193: 'Export a Power Automate Flow When the Export Option Is Missing' Sep 24, 2026
- #PowerPlatformTip 166: 'Check if a Person Is Out of Office Before an Approval' Sep 17, 2026
- #PowerPlatformTip 169: 'Run a For-a-Selected-Item Flow from Any List with a Column Button' Sep 10, 2026
- #PowerPlatformTip 174: 'Self-Healing Connector Actions in Copilot Studio - Retry & Remember' Sep 03, 2026
- #PowerPlatformTip 173: 'Let Copilot Studio Build the Call - Your Connector as an AI Tool' Aug 27, 2026
- #PowerPlatformTip 170: 'One Flow, Many Tools – a Switch Router for Copilot Studio Agents' Aug 20, 2026
- #PowerPlatformTip 165: 'Read On-Prem AD Attributes via the User Profile and $select' Aug 13, 2026
- #PowerPlatformTip 164: 'Add External Users to Microsoft Entra ID (Azure AD) with Power Automate' Aug 06, 2026
- #PowerPlatformTip 163: 'Create an ICS Calendar File in Power Automate' Jul 23, 2026
- #PowerPlatformTip 162: 'Create a Private Teams Channel from a Flow' Jul 09, 2026
- #PowerPlatformTip 161: 'Clone a SharePoint List's Custom Columns to Another Site' Jun 25, 2026
- #PowerPlatformTip 160: 'Set SharePoint Item Permissions with Power Automate' Jun 11, 2026
- #PowerPlatformTip 158: 'Return Flow Data to Power Apps with ParseJSON (No Premium)' May 14, 2026
- #PowerPlatformTip 157: 'Run Office Scripts from Power Automate – 25 Everyday Excel Automations' Apr 30, 2026
- #PowerPlatformTip 156: 'Handle Files up to 1 GB with Chunking in Power Automate' Apr 16, 2026
- #PowerPlatformTip 155: 'Float Before Div for Correct Decimals in Power Automate' Apr 02, 2026
- #PowerPlatformTip 154: 'Preserve Author, Editor & Dates on Copied SharePoint Files' Mar 19, 2026
- #PowerPlatformTip 153: 'Rename a SharePoint File with Power Automate' Mar 05, 2026
- #PowerPlatformTip 150: 'JSON & HTML to Markdown with Office Scripts' Jan 22, 2026
- #PowerPlatformTip 149: 'Approvals to a Shared Mailbox' Jan 15, 2026
- #PowerPlatformTip 148: 'Limit Apply to Each with take()' Jan 08, 2026
- #PowerPlatformTip 147: Dummy Patch After Complex Flows Dec 18, 2025
- #PowerPlatformTip 146: Encode & Decode Functions Dec 04, 2025
- #PowerPlatformTip 145: 'Power Platform Tools' Nov 01, 2025
- #PowerPlatformTip 144: Infinite Approvals beyond 30 days Oct 15, 2025
- #PowerPlatformTip 143: Reduce AI Costs with Thumbnail-First Document Processing Oct 01, 2025
- #PowerPlatformTip 142: Automate Outlook Categories Aug 26, 2025
- #PowerPlatformTip 141: Text to Array Aug 19, 2025
- #PowerPlatformTip 140: Free Invoice OCR (Process 500 PDFs/Month for €0) Aug 01, 2025
- #PowerPlatformTip 139: 'Plus Address Tracking' Jul 01, 2025
- #PowerPlatformTip 138: 'Graph API via HTTP with Microsoft Entra ID' Jun 25, 2025
- #PowerPlatformTip 135: 'One Flow, Many Users' Apr 01, 2025
- #PowerPlatformTip 133: 'SharePoint Updates with Power Automate, No Required Fields Needed' Jan 22, 2025
- #PowerPlatformTip 129: 'Case-sensitive SharePoint Filtering' Nov 06, 2024
- #PowerPlatformTip 128: 'Dynamic Data Retrieval' Oct 31, 2024
- #PowerPlatformTip 126: 'User Context for Automated Tasks' Oct 08, 2024
- #PowerPlatformTip 125: 'Convert CSV to JSON' Sep 25, 2024
- #PowerPlatformTip 124: 'Recognize Plain Text File Formats' Sep 18, 2024
- #PowerPlatformTip 123: 'Get Lowest / Highest SharePoint ID & TotalCount' Sep 11, 2024
- #PowerPlatformTip 121: 'Filtering SharePoint File Fields with OData' Aug 21, 2024
- #PowerPlatformTip 120: 'PowerAutomate, Text Processing 2.0' Aug 13, 2024
- #PowerPlatformTip 119: 'Web-Based Editing with VS Code' Aug 02, 2024
- #PowerPlatformTip 118: 'Copy Actions in Switch/Condition' Jul 23, 2024
- #PowerPlatformTip 117: 'Optimize Parallel Object Processing' Jul 16, 2024
- #PowerPlatformTip 116: 'AI Automated Solution Design' Jul 09, 2024
- #PowerPlatformTip 115: 'AI OCR Models' Jun 22, 2024
- #PowerPlatformTip 104: 'Efficient JSON Handling' Jun 20, 2024
- #PowerPlatformTip 100: 'Bypassing Complexity in PowerAutomate' Jun 18, 2024
- #PowerPlatformTip 102: 'Event Coordination' Jun 12, 2024
- #PowerPlatformTip 105: 'PowerApps, EnvironmentVariables Without Premium' Jun 04, 2024
- #PowerPlatformTip 114: 'Send Approvals to External Recipients' May 17, 2024
- #PowerPlatformTip 112: 'Consistent Data Formats' May 01, 2024
- #PowerPlatformTip 111: 'Adaptive Cards for Dynamic Approvals' Apr 24, 2024
- #PowerPlatformTip 109: 'Use TimeOut' Apr 11, 2024
- #PowerPlatformTip 106: 'Word & Quick Parts' Mar 05, 2024
- #PowerPlatformTip 99: 'Timesaver Toolkits, ChatGPT and Flow' Jan 08, 2024
- #PowerPlatformTip 98: 'Secure Inputs / Secure Outputs' Dec 27, 2023
- #PowerPlatformTip 97: 'Enhanced Pagination' Dec 22, 2023
- #PowerPlatformTip 96: 'Scraping Web Data with Standard Connectors' Dec 21, 2023
- #PowerPlatformTip 95: 'Optimized SharePoint Queries' Dec 19, 2023
- #PowerPlatformTip 94: 'Extract Text from DOCX' Dec 13, 2023
- #PowerPlatformTip 92: 'Free PDF Tools in PowerAutomate' Dec 08, 2023
- #PowerPlatformTip 90: 'Power Platform Community Developer Plan' Dec 04, 2023
- #PowerPlatformTip 89: 'Code View (Peek Code)' Nov 30, 2023
- #PowerPlatformTip 88: 'Where to Get Expert Power Platform Help' Nov 27, 2023
- #PowerPlatformTip 83: 'Organize Power Automate Chat Messages' Oct 24, 2023
- #PowerPlatformTip 75: 'Boost Efficiency with Concurrency Control' Aug 29, 2023
- #PowerPlatformTip 71: 'Array to Object' Aug 08, 2023
- #PowerPlatformTip 70: 'Managing Teams with PowerApps!' Jul 27, 2023
- #PowerPlatformTip 61: 'Power of Environment Variables' Jun 15, 2023
- #PowerPlatformTip 59: 'Handle Dynamic Content' Jun 08, 2023
- #PowerPlatformTip 58: 'HTTP Actions' Jun 06, 2023
- #PowerPlatformTip 52: 'DV4T: Budget-Friendly Choice' May 11, 2023
- #PowerPlatformTip 51: 'Which Flow Calls Which Flow' May 09, 2023
- #PowerPlatformTip 50: 'Use TemplateApp' May 04, 2023
- #PowerPlatformTip 49: 'Do-Until' May 02, 2023
- #PowerPlatformTip 48: 'Sharing of Flows & Power Apps' Apr 27, 2023
- #PowerPlatformTip 47: 'Batch-Method within SharePoint' Apr 25, 2023
- #PowerPlatformTip 45: 'Use Scopes' Apr 18, 2023
- #PowerPlatformTip 44: 'Calculate the Distance' Apr 13, 2023
- #PowerPlatformTip 41: 'Standard tables in Dataverse' Apr 04, 2023
- #PowerPlatformTip 40: 'Delete Apps / Flows' Mar 30, 2023
- #PowerPlatformTip 37: 'Table to JSON' Mar 21, 2023
- #PowerPlatformTip 36: 'Static Result' Mar 16, 2023
- #PowerPlatformTip 35: 'Concurrent Control' Mar 14, 2023
- #PowerPlatformTip 34: 'PowerApps V2' Mar 09, 2023
- #PowerPlatformTip 33: 'Coalesce in Power Apps' Mar 07, 2023
- #PowerPlatformTip 29: 'ParseJSON Description' Feb 15, 2023
- #PowerPlatformTip 27: 'Overwrite existing files' (The Settings Hack) Feb 09, 2023
- #PowerPlatformTip 24: 'Merge Arrays or Tables in Power Automate' Jan 31, 2023
- #PowerPlatformTip 21: 'Use Triggeroutput' Jan 19, 2023
- #PowerPlatformTip 20: 'Change Flow-Owner' Jan 17, 2023
- #PowerPlatformTip 19: 'Resize files' Jan 12, 2023
- #PowerPlatformTip 18: 'Download & Save Files' Jan 10, 2023
- #PowerPlatformTip 17: 'Format data by example' Jan 05, 2023
- #PowerPlatformTip 15: 'try-catch-finally' Dec 24, 2022
- #PowerPlatformTip 12: 'Components for PowerAutomate' Dec 21, 2022
- #PowerPlatformTip 11: 'Trigger Condition' Dec 20, 2022
- #PowerPlatformTip 9: 'Test Your Flow Before Activation' Dec 18, 2022
- #PowerPlatformTip 8: 'Automate Backups & Restores for Flows, Apps & Solutions' Dec 17, 2022
- #PowerPlatformTip 7: 'UNION and FilterArray' Dec 16, 2022
- #PowerPlatformTip 6: 'formatDateTime in utcNow' Dec 15, 2022
- #PowerPlatformTip 5: 'Less Variables' Dec 14, 2022
- #PowerPlatformTip 4: 'JSON Viewer' Dec 13, 2022
- #PowerPlatformTip 3: 'Advanced Filtering Array' Dec 12, 2022
- Extract an HTML Table from an Email in Power Automate, with XPath, from Damien Bird Nov 10, 2022
- How to Restore and Create a Backup from a Flow Aug 30, 2022
- Return an Array from PowerAutomate to PowerApps (Split Method without Premium) May 23, 2022
- Run Power Apps Actions with Elevated Permissions via Power Automate, from Reza Dorrani May 18, 2022
- How to Track the Current Progress of a Flow in PowerApps May 18, 2022
- Fill and Sign a Word Document with Power Apps and Power Automate, without Premium Actions, from Paulie M Apr 27, 2022
- Power Automate Flows vs Automate Rules: Performance and Efficiency Comparison by Daniel Christian Mar 09, 2022
- How to Send a 1:1 Message via Power Automate in Teams: Direct Personal Messaging Solution Oct 13, 2021
- Power Apps PDF Viewer for a SharePoint Document Library, without a Flow, from Reza Dorrani Jun 11, 2021
- How to Restore an Earlier Version of Your Flow (Power Automate), from John Liu Dec 30, 2020
- Power Apps: Print Directly to a Printer with an API, from Shane Young Dec 10, 2020