Explore our comprehensive collection of PowerPlatformTip posts organized by topic areas. Whether youâre looking for specific Power Apps solutions, Power Automate workflows, or Power BI insights, our categorized approach helps you quickly find exactly what you need.
đŻ Power Apps Development: Custom application building, canvas apps, model-driven apps
⥠Power Automate Workflows: Process automation, connectors, advanced flows
đ¤ Copilot Studio (Power Virtual Agents): Conversational AI, chatbot development, intelligent automation
đ SharePoint Integration: Lists, libraries, data synchronization
đž Data Management: Dataverse, data modeling, performance optimization
đĄď¸ Security & Governance: User permissions, environment management, compliance
Browse the categories below to discover expert solutions tailored to your specific Power Platform needs.
Bind a connector directly and a 404/422 hard-fails before the AI can react. Wrap the call in a flow that always returns readable JSON, so the agent retries i...
Hand your generic Custom Connector to a Copilot Studio agent as a tool and let generative orchestration pick the endpoint and build the body itself, MCP-styl...
Give a Copilot Studio agent a single instant flow that acts like a mini tool server. One âactionâ input drives a Switch (get / create / update), one generic ...
onPremisesSamAccountName, onPremisesDistinguishedName, extensionAttribute1-15 and the other on-prem AD fields are hidden by default in Microsoft Graph. Add a...
Automate B2B guest onboarding: POST to the Microsoft Graph /invitations endpoint from a flow to add an external user to Microsoft Entra ID (Azure AD) as a gu...
Build a real .ics calendar file from scratch in Power Automate with a single Compose action, then attach it to an email so recipients add the event to Outloo...
The standard Teams connector canât create a private channel. Use Microsoft Graph - POST /teams/{team-id}/channels with membershipType private and an owner in...
Read every column of a SharePoint list via the REST API, filter down to the custom (user-created) fields, and recreate the exact same columns on another site...
Need per-item access control in SharePoint? Break role inheritance and grant a user or group a permission level with two âSend an HTTP request to SharePointâ...
Clicking a SharePoint file link in Power Apps usually opens a preview instead of saving the file. Appending &download=1 to the URL inside Launch() often ...
Return one JSON text output from âRespond to a Power App or flowâ and unpack it in Power Apps with ParseJSON. Nested objects, arrays and typed values in a si...
Stop stitching Excel automations together with dozens of âUpdate a rowâ actions and Apply to each loops. Store one Office Script in OneDrive, call it with th...
Power Automate caps a single message at 100 MB. Turn on âAllow chunkingâ in the actionâs Content transfer settings and supported actions push large files up ...
Your div() returns 0 or drops the decimals? In Power Automate expressions div() truncates when both operands are integers. Wrap both values in float() so div...
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...
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 ...
Need a time picker in Power Apps? Skip the clunky hour/minute controls. A single Sequence() line fills a dropdown with every 15-minute slot from 00:00 to 23:...
Stop juggling dozens of SharePoint lists across separate views and apps. Dataverse virtual tables expose your production lists in Dataverse without copying d...
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 t...
This tip has moved to #PowerPlatformTip 150: JSON & HTML to Markdown with Office Scripts.
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 identi...
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...
Complex Flows with approvals/fallbacks updating lists? Use Dummy Patch on GalleryExample.selected + RefreshHack column for precise single-record refresh, ski...
Passing URLs, JSON data, or text with special characters between systems? Encoding prevents quotes, apostrophes, and special characters from breaking your fl...
Streamline your development workflow with Power Platform Tools, a centralized suite of browser-based utilities for developers. This all-in-one toolbox simpli...
Infinite Approvals lets you build Power Automate approval flows that survive beyond the 30-day timeout limit by safely restarting themselves. You can either ...
With AI Builder credits ending November 1, 2025, and Copilot Credits costing significantly more, organizations need smarter AI processing strategies. Process...
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...
Convert multiline text into an array in Power Automate using split(), ideal for processing lists from Excel, emails or Power Apps.
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...
Use plus addressing in Power Automate, Outlook, and Gmail to tag every automated email with its source for instant traceability.
Use the preauthorized âHTTP with Microsoft Entra IDâ connector in Power Automate to call Microsoft Graph without a custom app registration.
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
Learn how to use Patch() with Coalesce() in Power Apps to perform creates and updates in a single call, simplifying your code.
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.
Optimize Power Apps Canvas Apps with YAML and AI: Get best-practice tips, improve performance and structure, and use AI-powered analysis for more efficient a...
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
Display Office files like PDFs or Word documents directly in PowerApps without external workflows or third-party tools.
Optimize Power Apps performance by using ForAll and Patch for bulk updates, reduce API calls, speed up batch processing, and handle missing IDs efficiently.
Use YAML snippets to integrate pre-designed UI components into Power Apps, enabling faster development without design expertise.
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
Automatically switch between test and production user emails in PowerApps Studio using environment detection for secure, automated app testing and deployment.
Automate user-specific tasks like setting OOO replies and Teams notifications centrally while allowing users to customize messages before scheduled flows run.
Convert CSV data into JSON in Power Automate using only standard actions without premium connectors or external services.
Learn how to use plain text file formats in Power Automateâs Get File Content action to simplify processing by avoiding Base64 decoding.
Efficiently retrieve the highest, lowest, and total item IDs from a SharePoint list in Power Automate for advanced list analytics and data management.
This tip has moved to How to Track the Current Progress of a Flow in PowerApps.
Quickly and efficiently filter SharePoint files in Power Automate by using FileLeafRef (file name), FileRef (full path), and FileDirRef (folder) fields with ...
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
Use VS Code in the browser to provide a flexible, spacious editor for complex Power Platform scripts, formulas, and expressions.
Copy actions or scopes into a Switch or Condition in Power Automate without the errors caused by unresolved dynamic-content references.
Speed up large-item processing in Power Automate by leveraging child flows, database triggers, and strategic âRespond to a PowerApp or flowâ placement.
Quickly overview a comprehensive Solution Design for PowerApps and Power Automate using ChatGPT, Voice-to-Text, and Diagram-GPT.
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
Master JSON structure and schema validation in Power Automate to ensure robust data processing, minimize errors, and optimize automation workflows.
Streamline Power Automate flows by replacing complex Switch and Condition actions with dynamic JSON objects and formulas for faster, more maintainable automa...
Silently manage event attendees in Power Automate using Microsoft Graph API, add guests without notifications and keep attendee lists private for secure even...
Efficiently retrieve the latest item from a SharePoint list in PowerApps using delegable sorting and the First function for reliable, scalable data access.
Access environment variables in PowerApps without a premium license by leveraging Power Automate flows, enable cost-effective, centralized configuration for ...
Send Power Automate approval requests to external recipients using Adaptive Cards or email, enabling secure, flexible workflows beyond your organization.
Simplify merging static and dynamic data in Power Apps by ungrouping mixed data sources into a single flat table for improved management.
Harmonize data formats in Power Apps and Power Automate by trimming spaces, standardizing case, and matching types to prevent comparison and validation errors.
Use Adaptive Cards and Office 365 User Search in Power Automate to dynamically select the next approver, enhancing approval process flexibility.
Use a SharePoint custom permission level to block direct access to lists and enforce interactions through Power Apps for improved data security.
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
Automate Word documents for free using Quick Parts placeholders filled by a standard Power Automate flow, no premium license needed.
Quickly configure dropdowns and ComboBoxes in PowerApps using SharePoint or Dataverse Lookup and Choice columns for rapid, reliable data selection.
Centralize data management in Power Apps using global variables and Named Formulas to simplify updates, reduce redundancy, and boost app maintainability.
Boost productivity by combining ChatGPT and Power Automate, dictate ideas, automate task structuring, and streamline workflows with AI-powered toolkits and f...
Protect sensitive data in Power Automate by enabling Secure Inputs and Secure Outputs, mask confidential information in flow logs, enhance compliance, and se...
Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint, retrieve more data, improve performance, and streaml...
Scrape and store website content in Power Automate using the OneDrive connector, fetch HTML data cost-effectively, automate extraction, and avoid premium con...
Optimize SharePoint queries in Power Automate using OData filter options, improve data filtering, workflow efficiency, and minimize processing for large lists.
How to extract text from a DOCX without tools: Power Automate treats the Word file as a ZIP archive, extracts it and parses document.xml â no third-party con...
Enhance PowerApps galleries and data sets with dynamic row numbering, improve user experience, data management, and navigation using simple, real-time techni...
Discover the best free PDF tools for Power Automate, compare features, integrations, and value to automate document workflows without extra cost.
Streamline Power Apps formulas by using direct conditions instead of the IF function, write cleaner, more efficient code and boost app performance with best ...
Leverage the Power Platform Community Developer Plan for a free, robust environment to build, test, and share Power Apps and Power Automate solutions, ideal ...
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 troub...
Get on-demand expert help and 1:1 coaching from Microsoft MVPs at ThePowerAddicts.com, receive unbiased advice, governance checkups, and targeted Power Platf...
Understand PowerApps licensing for sharing Canvas Apps with external guests, ensure compliance, seamless collaboration, and the right licenses for Dataverse ...
Enhance Power Apps with free, customizable SVG icons from Matthew Devaney and SVGRepo, improve UI design, user experience, and app branding with easy integra...
Improve Power Apps performance and reduce data traffic by enabling Delay Output in TextInput fields, optimize updates, enhance user experience, and streamlin...
Solve Tab key issues in Power Apps dynamic forms by using the Sequence function for gallery binding, improve accessibility, usability, and user experience in...
Organize Power Automate notifications in Microsoft Teams by routing messages to topic-specific group chats, reduce clutter, improve collaboration, and stream...
Use AI and ChatGPT to automatically generate code comments for Power Apps formulas, improve maintainability, collaboration, and productivity with clear, insi...
Efficiently update large data sets in Power Apps by using ClearCollect, UpdateIf, and Patch for high-performance batch processing and streamlined data manage...
Create dynamic forms in Power Apps using AI and JSON, leverage galleries for flexible input, automate schema generation, and streamline data collection witho...
Retrieve details of newly created or updated records in Power Apps using Patch or Form.LastSubmit, access record IDs instantly for seamless workflow automati...
Reset all Power Apps controls at once using a single context variable, streamline your code, improve app efficiency, and simplify UI management for better us...
This tip has moved to #PowerPlatformTip 117: Optimize Parallel Object Processing.
Easily share PowerApps with external guests using Microsoft Teams Groups for unified access, streamlined management, and secure backend integration with Shar...
Enable Concurrency Control in Power Automate to process âFor Eachâ loops in parallel, dramatically improving flow speed, scalability, and automation efficien...
This tip has moved to Run Power Apps Connections with Elevated Permissions via Power Automate.
Instantly switch from play mode to maker mode in Power Apps using a bookmarklet, speed up app editing, boost productivity, and streamline your development wo...
Integrate Google Maps with PowerApps to deliver interactive mapping, real-time GPS, and location services, no premium license required. Learn how to embed ma...
Convert arrays to objects in Power Automate using Select and Replace actions for efficient data transformation, automation, and integration with downstream s...
Manage Teams environments more effectively by switching to powerautomate.com and using a simple URL trick to open PowerApps4Teams in make.powerapps.com, stre...
Speed up Power Apps loading by using App.width and App.height for fullscreen dimensions, improve performance, user experience, and deliver faster app startup...
Combine Power Apps studio and Power Apps 4 Teams by copying controls between them, unlock advanced features, user-friendly design, and boost productivity wit...
Seamlessly redirect users from old to new Power Apps using the Launch function, improve user experience, manage migrations, and ensure smooth app transitions...
Load the structure of a data source into a Power Apps collection to prepare for patch operations, ensure data integrity, and boost app performance with effic...
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
Compare Lookup and First/Filter in Power Apps to choose the best approach for your scenario. Optimize data access, improve performance, and avoid common pitf...
Master the Lookup function in Power Apps for advanced data retrieval. Compare Lookup with Filter and First, and learn best practices for efficient, accurate ...
Update records efficiently in Power Apps with the UpdateIf function. Learn how to perform bulk updates, filter data, and optimize app performance for large d...
Unlock the power of environment variables in Power Platform. Learn how to manage configurations, streamline deployments, and boost app flexibility with best ...
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
Handle dynamic content in Power Automate with confidence. Learn best practices for managing unpredictable data, parsing values, and building robust, error-re...
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 ...
Master the Patch function in Power Apps to update data efficiently. Learn advanced techniques for bulk updates, error handling, and optimizing app performanc...
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Pick and apply colors efficiently in Power Apps. Use this tip to streamline UI design, maintain brand consistency, and speed up app development with color be...
Design consistent, flexible, and data-driven menus in Power Apps using the Gallery control. Improve UI, simplify maintenance, and enhance user experience wit...
Open URLs, launch apps, and integrate Power Apps with Teams, SharePoint, and more using the Launch function. Enhance user experience with seamless navigation...
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...
Easily trace which Power Automate flow triggers another. Use this tip to document, debug, and maintain complex Power Platform automations with confidence.
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...
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...
Easily share Power Automate flows and Power Apps with colleagues. Learn best practices for secure sharing, permissions, and collaboration in the Power Platfo...
Learn how to build dynamic forms in Power Apps without using the traditional Forms control. Create custom, schema-driven forms that can add controls on the f...
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 ...
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure.
Calculate accurate great-circle distances directly in your Power Platform app using the Haversine formula and a ready-made JSON snippet.
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
Use Dataverse Views for targeted filtering and improved performance in PowerApps. Push filters to the server for faster, more efficient apps.
Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling.
Efficiently remove outdated test apps and flows in Power Platform by exporting and reimporting solutions. Declutter your workspace with bulk cleanup.
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
Convert two-column tables to JSON in Power Automate for easier data access. Use Parse JSON for efficient data transformation and automation.
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
Use the PowerApps V2 trigger in Power Automate for enhanced security, precise input control, and flexible flow management. Improve integration and automation.
Coalesce in Power Apps returns the first non-blank value from a list â replace nested If(IsBlank()) checks with one function. Syntax, examples and the Power ...
Optimize PowerApps performance by loading data once and using GroupBy for dependent filters. Reduce data loads and boost app speed.
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
Use AppChecker and the Power Apps Code Review Tool to ensure high-quality, efficient PowerApps solutions. Improve performance and accessibility.
Add custom descriptions in Power Automateâs Parse JSON action to organize and distinguish similar Dynamic Content entries. Improve flow clarity.
Access quick Power Platform tips by adding â.deâ to platform URLs. Instantly find curated insights and boost your productivity.
Enable file overwriting in SharePoint by disabling âAllow Chunkingâ, a simple settings tweak that unlocks the hidden overwrite toggle in Power Automate.
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
How to merge or combine two arrays in Power Automate: union() for unique values, or the join-concat-split pattern to keep duplicates. Copy-paste expressions ...
Discover an amazing PowerApps component that allows you to merge images, add annotations, and overlay drawings without needing Power Automate flows or premiu...
Show all gallery items in PowerApps when filter input is blank using IsBlank in your filter logic. Improve user experience and data access.
Change fill and color across a PowerApps Canvas App by centralizing colors in a theme variable and using the formula editorâs Find & Replace.
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
Change a Power Automate flow owner in place by making it solution-aware. Avoid export/import and keep all connections and run history intact.
Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation.
Download and save public or password-protected files in Power Automate using HTTP requests and file management actions. Ensure secure, automated file handling.
Master data formatting in Power Automate! Use âFormat data by exampleâ, or its Copilot successor, the expression assistant, to generate accurate expressions ...
Access ready-to-use PowerApps collection code snippets with the Collections Cookbook. Enhance data manipulation and boost app development productivity.
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation.
Edit PowerApps4Teams apps directly in make.powerapps.com using a URL hack. Save time and boost productivity by bypassing the standard Teams creation process.
Boost productivity in Power Automate by saving and reusing scopes with the clipboard feature. Streamline flow development and ensure consistency.
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
Master all variable types in PowerApps: Go beyond Set and UpdateContext with With and Param for more dynamic, flexible app development.
Test Power Automate flows before activation: Use the built-in Test feature to catch errors early, improve reliability, and streamline flow development.
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...
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
Reduce variables in Power Automate by using Parse JSON or Compose for static parameters. Keep flows readable and loop concurrency intact, reserve variables f...
Visualize and format JSON data in Power Automate using a browser extension. Simplify data handling, boost productivity, and make complex JSON easy to read.
Unlock advanced filtering in Power Automate: Use Filter Array with custom expressions to streamline flows, boost accuracy, and optimize workflow performance.
Transfer Power Apps ownership after a maker leaves, using the CoE Starter Kit admin apps or the Set-AdminPowerAppOwner PowerShell cmdlet. Keep apps governed ...
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
Master the art of extracting HTML tables from emails using Power Automate with XML processing techniques. Damien Bird demonstrates advanced XPath methods for...
Safeguarding your workflows with Power Automate: Learn comprehensive methods to create and restore backups for your flows using solutions and direct flow man...
Learn efficient techniques to combine multiple data sources into a single collection in PowerApps. This guide covers identical data sources, different data s...
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...
Learn how to enable end users to perform actions with elevated permissions in Power Apps using Power Automateâs impersonation features. Reza Dorrani demonstr...
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...
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...
Discover ingenious workarounds for implementing keyboard event handling in PowerApps text inputs using creative control repurposing. Paulie M demonstrates in...
Explore the differences between Power Automate Flows and SharePoint Automate Rules. Daniel Christian analyzes performance implications and optimal use cases ...
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...
Great demo start, how to refresh used data, which have been updated, best. In such a way that the performance of the app runs optimally. Above all, I found t...
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...
Make a canvas app multilingual without editing every label. Store translations in one data source, load them into a single collection at OnStart based on Lan...
Set DefaultSelectedItems in a Power Apps ComboBox with copy-paste formulas: pre-select one or multiple items for text, Choice, Lookup and Person columns â pl...
Discover the five essential functions for managing variables and parameters in PowerApps. Learn how to use Set, UpdateContext, With, Navigate, and Param to b...
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...
Discover how to print directly from Power Apps using an innovative API workaround. Shane Young demonstrates printing PDFs, labels, barcodes, and more using P...
Bind a connector directly and a 404/422 hard-fails before the AI can react. Wrap the call in a flow that always returns readable JSON, so the agent retries i...
Hand your generic Custom Connector to a Copilot Studio agent as a tool and let generative orchestration pick the endpoint and build the body itself, MCP-styl...
Give a Copilot Studio agent a single instant flow that acts like a mini tool server. One âactionâ input drives a Switch (get / create / update), one generic ...
onPremisesSamAccountName, onPremisesDistinguishedName, extensionAttribute1-15 and the other on-prem AD fields are hidden by default in Microsoft Graph. Add a...
Automate B2B guest onboarding: POST to the Microsoft Graph /invitations endpoint from a flow to add an external user to Microsoft Entra ID (Azure AD) as a gu...
Build a real .ics calendar file from scratch in Power Automate with a single Compose action, then attach it to an email so recipients add the event to Outloo...
The standard Teams connector canât create a private channel. Use Microsoft Graph - POST /teams/{team-id}/channels with membershipType private and an owner in...
Read every column of a SharePoint list via the REST API, filter down to the custom (user-created) fields, and recreate the exact same columns on another site...
Need per-item access control in SharePoint? Break role inheritance and grant a user or group a permission level with two âSend an HTTP request to SharePointâ...
Clicking a SharePoint file link in Power Apps usually opens a preview instead of saving the file. Appending &download=1 to the URL inside Launch() often ...
Return one JSON text output from âRespond to a Power App or flowâ and unpack it in Power Apps with ParseJSON. Nested objects, arrays and typed values in a si...
Stop stitching Excel automations together with dozens of âUpdate a rowâ actions and Apply to each loops. Store one Office Script in OneDrive, call it with th...
Power Automate caps a single message at 100 MB. Turn on âAllow chunkingâ in the actionâs Content transfer settings and supported actions push large files up ...
Your div() returns 0 or drops the decimals? In Power Automate expressions div() truncates when both operands are integers. Wrap both values in float() so div...
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...
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 ...
Need a time picker in Power Apps? Skip the clunky hour/minute controls. A single Sequence() line fills a dropdown with every 15-minute slot from 00:00 to 23:...
Stop juggling dozens of SharePoint lists across separate views and apps. Dataverse virtual tables expose your production lists in Dataverse without copying d...
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 t...
This tip has moved to #PowerPlatformTip 150: JSON & HTML to Markdown with Office Scripts.
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 identi...
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...
Complex Flows with approvals/fallbacks updating lists? Use Dummy Patch on GalleryExample.selected + RefreshHack column for precise single-record refresh, ski...
Passing URLs, JSON data, or text with special characters between systems? Encoding prevents quotes, apostrophes, and special characters from breaking your fl...
Streamline your development workflow with Power Platform Tools, a centralized suite of browser-based utilities for developers. This all-in-one toolbox simpli...
Infinite Approvals lets you build Power Automate approval flows that survive beyond the 30-day timeout limit by safely restarting themselves. You can either ...
With AI Builder credits ending November 1, 2025, and Copilot Credits costing significantly more, organizations need smarter AI processing strategies. Process...
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...
Convert multiline text into an array in Power Automate using split(), ideal for processing lists from Excel, emails or Power Apps.
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...
Use plus addressing in Power Automate, Outlook, and Gmail to tag every automated email with its source for instant traceability.
Use the preauthorized âHTTP with Microsoft Entra IDâ connector in Power Automate to call Microsoft Graph without a custom app registration.
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
Learn how to use Patch() with Coalesce() in Power Apps to perform creates and updates in a single call, simplifying your code.
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.
Optimize Power Apps Canvas Apps with YAML and AI: Get best-practice tips, improve performance and structure, and use AI-powered analysis for more efficient a...
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
Display Office files like PDFs or Word documents directly in PowerApps without external workflows or third-party tools.
Optimize Power Apps performance by using ForAll and Patch for bulk updates, reduce API calls, speed up batch processing, and handle missing IDs efficiently.
Use YAML snippets to integrate pre-designed UI components into Power Apps, enabling faster development without design expertise.
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
Automatically switch between test and production user emails in PowerApps Studio using environment detection for secure, automated app testing and deployment.
Automate user-specific tasks like setting OOO replies and Teams notifications centrally while allowing users to customize messages before scheduled flows run.
Convert CSV data into JSON in Power Automate using only standard actions without premium connectors or external services.
Learn how to use plain text file formats in Power Automateâs Get File Content action to simplify processing by avoiding Base64 decoding.
Efficiently retrieve the highest, lowest, and total item IDs from a SharePoint list in Power Automate for advanced list analytics and data management.
This tip has moved to How to Track the Current Progress of a Flow in PowerApps.
Quickly and efficiently filter SharePoint files in Power Automate by using FileLeafRef (file name), FileRef (full path), and FileDirRef (folder) fields with ...
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
Use VS Code in the browser to provide a flexible, spacious editor for complex Power Platform scripts, formulas, and expressions.
Copy actions or scopes into a Switch or Condition in Power Automate without the errors caused by unresolved dynamic-content references.
Speed up large-item processing in Power Automate by leveraging child flows, database triggers, and strategic âRespond to a PowerApp or flowâ placement.
Quickly overview a comprehensive Solution Design for PowerApps and Power Automate using ChatGPT, Voice-to-Text, and Diagram-GPT.
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
Master JSON structure and schema validation in Power Automate to ensure robust data processing, minimize errors, and optimize automation workflows.
Streamline Power Automate flows by replacing complex Switch and Condition actions with dynamic JSON objects and formulas for faster, more maintainable automa...
Silently manage event attendees in Power Automate using Microsoft Graph API, add guests without notifications and keep attendee lists private for secure even...
Efficiently retrieve the latest item from a SharePoint list in PowerApps using delegable sorting and the First function for reliable, scalable data access.
Access environment variables in PowerApps without a premium license by leveraging Power Automate flows, enable cost-effective, centralized configuration for ...
Send Power Automate approval requests to external recipients using Adaptive Cards or email, enabling secure, flexible workflows beyond your organization.
Simplify merging static and dynamic data in Power Apps by ungrouping mixed data sources into a single flat table for improved management.
Harmonize data formats in Power Apps and Power Automate by trimming spaces, standardizing case, and matching types to prevent comparison and validation errors.
Use Adaptive Cards and Office 365 User Search in Power Automate to dynamically select the next approver, enhancing approval process flexibility.
Use a SharePoint custom permission level to block direct access to lists and enforce interactions through Power Apps for improved data security.
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
Automate Word documents for free using Quick Parts placeholders filled by a standard Power Automate flow, no premium license needed.
Quickly configure dropdowns and ComboBoxes in PowerApps using SharePoint or Dataverse Lookup and Choice columns for rapid, reliable data selection.
Centralize data management in Power Apps using global variables and Named Formulas to simplify updates, reduce redundancy, and boost app maintainability.
Boost productivity by combining ChatGPT and Power Automate, dictate ideas, automate task structuring, and streamline workflows with AI-powered toolkits and f...
Protect sensitive data in Power Automate by enabling Secure Inputs and Secure Outputs, mask confidential information in flow logs, enhance compliance, and se...
Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint, retrieve more data, improve performance, and streaml...
Scrape and store website content in Power Automate using the OneDrive connector, fetch HTML data cost-effectively, automate extraction, and avoid premium con...
Optimize SharePoint queries in Power Automate using OData filter options, improve data filtering, workflow efficiency, and minimize processing for large lists.
How to extract text from a DOCX without tools: Power Automate treats the Word file as a ZIP archive, extracts it and parses document.xml â no third-party con...
Enhance PowerApps galleries and data sets with dynamic row numbering, improve user experience, data management, and navigation using simple, real-time techni...
Discover the best free PDF tools for Power Automate, compare features, integrations, and value to automate document workflows without extra cost.
Streamline Power Apps formulas by using direct conditions instead of the IF function, write cleaner, more efficient code and boost app performance with best ...
Leverage the Power Platform Community Developer Plan for a free, robust environment to build, test, and share Power Apps and Power Automate solutions, ideal ...
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 troub...
Get on-demand expert help and 1:1 coaching from Microsoft MVPs at ThePowerAddicts.com, receive unbiased advice, governance checkups, and targeted Power Platf...
Understand PowerApps licensing for sharing Canvas Apps with external guests, ensure compliance, seamless collaboration, and the right licenses for Dataverse ...
Enhance Power Apps with free, customizable SVG icons from Matthew Devaney and SVGRepo, improve UI design, user experience, and app branding with easy integra...
Improve Power Apps performance and reduce data traffic by enabling Delay Output in TextInput fields, optimize updates, enhance user experience, and streamlin...
Solve Tab key issues in Power Apps dynamic forms by using the Sequence function for gallery binding, improve accessibility, usability, and user experience in...
Organize Power Automate notifications in Microsoft Teams by routing messages to topic-specific group chats, reduce clutter, improve collaboration, and stream...
Use AI and ChatGPT to automatically generate code comments for Power Apps formulas, improve maintainability, collaboration, and productivity with clear, insi...
Efficiently update large data sets in Power Apps by using ClearCollect, UpdateIf, and Patch for high-performance batch processing and streamlined data manage...
Create dynamic forms in Power Apps using AI and JSON, leverage galleries for flexible input, automate schema generation, and streamline data collection witho...
Retrieve details of newly created or updated records in Power Apps using Patch or Form.LastSubmit, access record IDs instantly for seamless workflow automati...
Reset all Power Apps controls at once using a single context variable, streamline your code, improve app efficiency, and simplify UI management for better us...
This tip has moved to #PowerPlatformTip 117: Optimize Parallel Object Processing.
Easily share PowerApps with external guests using Microsoft Teams Groups for unified access, streamlined management, and secure backend integration with Shar...
Enable Concurrency Control in Power Automate to process âFor Eachâ loops in parallel, dramatically improving flow speed, scalability, and automation efficien...
This tip has moved to Run Power Apps Connections with Elevated Permissions via Power Automate.
Instantly switch from play mode to maker mode in Power Apps using a bookmarklet, speed up app editing, boost productivity, and streamline your development wo...
Integrate Google Maps with PowerApps to deliver interactive mapping, real-time GPS, and location services, no premium license required. Learn how to embed ma...
Convert arrays to objects in Power Automate using Select and Replace actions for efficient data transformation, automation, and integration with downstream s...
Manage Teams environments more effectively by switching to powerautomate.com and using a simple URL trick to open PowerApps4Teams in make.powerapps.com, stre...
Speed up Power Apps loading by using App.width and App.height for fullscreen dimensions, improve performance, user experience, and deliver faster app startup...
Combine Power Apps studio and Power Apps 4 Teams by copying controls between them, unlock advanced features, user-friendly design, and boost productivity wit...
Seamlessly redirect users from old to new Power Apps using the Launch function, improve user experience, manage migrations, and ensure smooth app transitions...
Load the structure of a data source into a Power Apps collection to prepare for patch operations, ensure data integrity, and boost app performance with effic...
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
Compare Lookup and First/Filter in Power Apps to choose the best approach for your scenario. Optimize data access, improve performance, and avoid common pitf...
Master the Lookup function in Power Apps for advanced data retrieval. Compare Lookup with Filter and First, and learn best practices for efficient, accurate ...
Update records efficiently in Power Apps with the UpdateIf function. Learn how to perform bulk updates, filter data, and optimize app performance for large d...
Unlock the power of environment variables in Power Platform. Learn how to manage configurations, streamline deployments, and boost app flexibility with best ...
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
Handle dynamic content in Power Automate with confidence. Learn best practices for managing unpredictable data, parsing values, and building robust, error-re...
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 ...
Master the Patch function in Power Apps to update data efficiently. Learn advanced techniques for bulk updates, error handling, and optimizing app performanc...
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Pick and apply colors efficiently in Power Apps. Use this tip to streamline UI design, maintain brand consistency, and speed up app development with color be...
Design consistent, flexible, and data-driven menus in Power Apps using the Gallery control. Improve UI, simplify maintenance, and enhance user experience wit...
Open URLs, launch apps, and integrate Power Apps with Teams, SharePoint, and more using the Launch function. Enhance user experience with seamless navigation...
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...
Easily trace which Power Automate flow triggers another. Use this tip to document, debug, and maintain complex Power Platform automations with confidence.
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...
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...
Easily share Power Automate flows and Power Apps with colleagues. Learn best practices for secure sharing, permissions, and collaboration in the Power Platfo...
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 ...
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure.
Calculate accurate great-circle distances directly in your Power Platform app using the Haversine formula and a ready-made JSON snippet.
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
Use Dataverse Views for targeted filtering and improved performance in PowerApps. Push filters to the server for faster, more efficient apps.
Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling.
Efficiently remove outdated test apps and flows in Power Platform by exporting and reimporting solutions. Declutter your workspace with bulk cleanup.
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
Convert two-column tables to JSON in Power Automate for easier data access. Use Parse JSON for efficient data transformation and automation.
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
Use the PowerApps V2 trigger in Power Automate for enhanced security, precise input control, and flexible flow management. Improve integration and automation.
Coalesce in Power Apps returns the first non-blank value from a list â replace nested If(IsBlank()) checks with one function. Syntax, examples and the Power ...
Optimize PowerApps performance by loading data once and using GroupBy for dependent filters. Reduce data loads and boost app speed.
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
Use AppChecker and the Power Apps Code Review Tool to ensure high-quality, efficient PowerApps solutions. Improve performance and accessibility.
Add custom descriptions in Power Automateâs Parse JSON action to organize and distinguish similar Dynamic Content entries. Improve flow clarity.
Access quick Power Platform tips by adding â.deâ to platform URLs. Instantly find curated insights and boost your productivity.
Enable file overwriting in SharePoint by disabling âAllow Chunkingâ, a simple settings tweak that unlocks the hidden overwrite toggle in Power Automate.
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
How to merge or combine two arrays in Power Automate: union() for unique values, or the join-concat-split pattern to keep duplicates. Copy-paste expressions ...
Show all gallery items in PowerApps when filter input is blank using IsBlank in your filter logic. Improve user experience and data access.
Change fill and color across a PowerApps Canvas App by centralizing colors in a theme variable and using the formula editorâs Find & Replace.
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
Change a Power Automate flow owner in place by making it solution-aware. Avoid export/import and keep all connections and run history intact.
Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation.
Download and save public or password-protected files in Power Automate using HTTP requests and file management actions. Ensure secure, automated file handling.
Master data formatting in Power Automate! Use âFormat data by exampleâ, or its Copilot successor, the expression assistant, to generate accurate expressions ...
Access ready-to-use PowerApps collection code snippets with the Collections Cookbook. Enhance data manipulation and boost app development productivity.
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation.
Edit PowerApps4Teams apps directly in make.powerapps.com using a URL hack. Save time and boost productivity by bypassing the standard Teams creation process.
Boost productivity in Power Automate by saving and reusing scopes with the clipboard feature. Streamline flow development and ensure consistency.
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
Master all variable types in PowerApps: Go beyond Set and UpdateContext with With and Param for more dynamic, flexible app development.
Test Power Automate flows before activation: Use the built-in Test feature to catch errors early, improve reliability, and streamline flow development.
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...
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
Reduce variables in Power Automate by using Parse JSON or Compose for static parameters. Keep flows readable and loop concurrency intact, reserve variables f...
Visualize and format JSON data in Power Automate using a browser extension. Simplify data handling, boost productivity, and make complex JSON easy to read.
Unlock advanced filtering in Power Automate: Use Filter Array with custom expressions to streamline flows, boost accuracy, and optimize workflow performance.
Transfer Power Apps ownership after a maker leaves, using the CoE Starter Kit admin apps or the Set-AdminPowerAppOwner PowerShell cmdlet. Keep apps governed ...
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
Make a canvas app multilingual without editing every label. Store translations in one data source, load them into a single collection at OnStart based on Lan...
Learn how to build dynamic forms in Power Apps without using the traditional Forms control. Create custom, schema-driven forms that can add controls on the f...
Discover an amazing PowerApps component that allows you to merge images, add annotations, and overlay drawings without needing Power Automate flows or premiu...
Master the art of extracting HTML tables from emails using Power Automate with XML processing techniques. Damien Bird demonstrates advanced XPath methods for...
Safeguarding your workflows with Power Automate: Learn comprehensive methods to create and restore backups for your flows using solutions and direct flow man...
Learn efficient techniques to combine multiple data sources into a single collection in PowerApps. This guide covers identical data sources, different data s...
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...
Learn how to enable end users to perform actions with elevated permissions in Power Apps using Power Automateâs impersonation features. Reza Dorrani demonstr...
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...
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...
Discover ingenious workarounds for implementing keyboard event handling in PowerApps text inputs using creative control repurposing. Paulie M demonstrates in...
Explore the differences between Power Automate Flows and SharePoint Automate Rules. Daniel Christian analyzes performance implications and optimal use cases ...
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...
Great demo start, how to refresh used data, which have been updated, best. In such a way that the performance of the app runs optimally. Above all, I found t...
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...
Set DefaultSelectedItems in a Power Apps ComboBox with copy-paste formulas: pre-select one or multiple items for text, Choice, Lookup and Person columns â pl...
Discover the five essential functions for managing variables and parameters in PowerApps. Learn how to use Set, UpdateContext, With, Navigate, and Param to b...
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...
Discover how to print directly from Power Apps using an innovative API workaround. Shane Young demonstrates printing PDFs, labels, barcodes, and more using P...