Power Apps Tips 📱
#PowerPlatformTip 159: ‘Force a Direct File Download in Power Apps with Launch’
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 ...
#PowerPlatformTip 158: ‘Return Flow Data to Power Apps with ParseJSON (No Premium)’
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...
#PowerPlatformTip 152: ‘Build a Time Picker with One Line using Sequence()’
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:...
#PowerPlatformTip 151: ‘Manage All Your SharePoint Lists in One Model-Driven App with Virtual Tables’
Stop juggling dozens of SharePoint lists across separate views and apps. Dataverse virtual tables expose your production lists in Dataverse without copying d...
#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, ski...
#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 136: ‘Patch Coalesce Upsert’
Learn how to use Patch() with Coalesce() in Power Apps to perform creates and updates in a single call, simplifying your code.
#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 134: ‘Optimize Canvas Apps with YAML’
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...
#PowerPlatformTip 132: ‘Office Files Viewer in PowerApps’
Display Office files like PDFs or Word documents directly in PowerApps without external workflows or third-party tools.
#PowerPlatformTip 131: ‘ForAll & Patch Optimization in PowerApps’
Optimize Power Apps performance by using ForAll and Patch for bulk updates, reduce API calls, speed up batch processing, and handle missing IDs efficiently.
#PowerPlatformTip 130: ‘Build Apps Faster with YAML’
Use YAML snippets to integrate pre-designed UI components into Power Apps, enabling faster development without design expertise.
#PowerPlatformTip 127: ‘Special User-Informations in PowerApps Studio’
Automatically switch between test and production user emails in PowerApps Studio using environment detection for secure, automated app testing and deployment.
#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 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 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 107: ‘Last Item from SharePointList’
Efficiently retrieve the latest item from a SharePoint list in PowerApps using delegable sorting and the First function for reliable, scalable data access.
#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 ...
#PowerPlatformTip 113: ‘Combine Multiple Data Sources’
Simplify merging static and dynamic data in Power Apps by ungrouping mixed data sources into a single flat table for improved management.
#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 110: ‘Protect SharePoint Data’
Use a SharePoint custom permission level to block direct access to lists and enforce interactions through Power Apps for improved data security.
#PowerPlatformTip 108: ‘Double-Click Magic in PowerApps’
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
#PowerPlatformTip 103: ‘Quick Setup Guide’
Quickly configure dropdowns and ComboBoxes in PowerApps using SharePoint or Dataverse Lookup and Choice columns for rapid, reliable data selection.
#PowerPlatformTip 101: ‘Centralized Data Handling’
Centralize data management in Power Apps using global variables and Named Formulas to simplify updates, reduce redundancy, and boost app maintainability.
#PowerPlatformTip 93: ‘Add RowNumbers’
Enhance PowerApps galleries and data sets with dynamic row numbering, improve user experience, data management, and navigation using simple, real-time techni...
#PowerPlatformTip 91: ‘IF Function in Formulas’
Streamline Power Apps formulas by using direct conditions instead of the IF function, write cleaner, more efficient code and boost app performance with best ...
#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 ...
#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 Platf...
#PowerPlatformTip 87: ‘Licensing, Sharing Canvas Apps with Guests’
Understand PowerApps licensing for sharing Canvas Apps with external guests, ensure compliance, seamless collaboration, and the right licenses for Dataverse ...
#PowerPlatformTip 86: ‘Free Power Apps Icons’
Enhance Power Apps with free, customizable SVG icons from Matthew Devaney and SVGRepo, improve UI design, user experience, and app branding with easy integra...
#PowerPlatformTip 85: ‘Delay Output’
Improve Power Apps performance and reduce data traffic by enabling Delay Output in TextInput fields, optimize updates, enhance user experience, and streamlin...
#PowerPlatformTip 84: ‘Tabbing in Dynamic Forms’
Solve Tab key issues in Power Apps dynamic forms by using the Sequence function for gallery binding, improve accessibility, usability, and user experience in...
#PowerPlatformTip 82: ‘Automated Code Commenting’
Use AI and ChatGPT to automatically generate code comments for Power Apps formulas, improve maintainability, collaboration, and productivity with clear, insi...
#PowerPlatformTip 81: ‘Fast DataSource Updates’
Efficiently update large data sets in Power Apps by using ClearCollect, UpdateIf, and Patch for high-performance batch processing and streamlined data manage...
#PowerPlatformTip 80: ‘Rapid Dynamic Forms with AI’
Create dynamic forms in Power Apps using AI and JSON, leverage galleries for flexible input, automate schema generation, and streamline data collection witho...
#PowerPlatformTip 79: ‘Retrieve Record Details Post-Update’
Retrieve details of newly created or updated records in Power Apps using Patch or Form.LastSubmit, access record IDs instantly for seamless workflow automati...
#PowerPlatformTip 78: ‘Efficient Control Reset’
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...
#PowerPlatformTip 76: ‘PowerApps Sharing with Guests’
Easily share PowerApps with external guests using Microsoft Teams Groups for unified access, streamlined management, and secure backend integration with Shar...
#PowerPlatformTip 73: ‘Quick Switch to Maker Mode’
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...
#PowerPlatformTip 72: ‘PowerApps with Google Maps API’
Integrate Google Maps with PowerApps to deliver interactive mapping, real-time GPS, and location services, no premium license required. Learn how to embed ma...
#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, stre...
#PowerPlatformTip 69: ‘Optimize Loading with Fullscreen Reference’
Speed up Power Apps loading by using App.width and App.height for fullscreen dimensions, improve performance, user experience, and deliver faster app startup...
#PowerPlatformTip 68: ‘Utilize the best of both worlds: Power Apps and Power Apps 4 Teams’
Combine Power Apps studio and Power Apps 4 Teams by copying controls between them, unlock advanced features, user-friendly design, and boost productivity wit...
#PowerPlatformTip 67: ‘App-to-App Redirection’
Seamlessly redirect users from old to new Power Apps using the Launch function, improve user experience, manage migrations, and ensure smooth app transitions...
#PowerPlatformTip 66: ‘Load Data Source Structure’
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...
#PowerPlatformTip 64: ‘Comparing Lookup vs. First(Filter)’
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...
#PowerPlatformTip 63: ‘Mastering the Lookup Function’
Master the Lookup function in Power Apps for advanced data retrieval. Compare Lookup with Filter and First, and learn best practices for efficient, accurate ...
#PowerPlatformTip 62: ‘UpdateIf’
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...
#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 57: ‘Mastering PATCH’
Master the Patch function in Power Apps to update data efficiently. Learn advanced techniques for bulk updates, error handling, and optimizing app performanc...
#PowerPlatformTip 55: ‘Picking colors’
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...
#PowerPlatformTip 54: ‘Use Galleries’
Design consistent, flexible, and data-driven menus in Power Apps using the Gallery control. Improve UI, simplify maintenance, and enhance user experience wit...
#PowerPlatformTip 53: ‘Launch function’
Open URLs, launch apps, and integrate Power Apps with Teams, SharePoint, and more using the Launch function. Enhance user experience with seamless navigation...
#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 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 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...
Power Apps Dynamic Form Schema: Add Controls on the Fly
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...
#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 43: ‘With function’
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
#PowerPlatformTip 42: ‘Dataverse Views’
Use Dataverse Views for targeted filtering and improved performance in PowerApps. Push filters to the server for faster, more efficient apps.
#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 38: ‘Data Refresh’
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
#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 in Power Apps’
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 ...
#PowerPlatformTip 32: ‘Optimize with GroupBy’
Optimize PowerApps performance by loading data once and using GroupBy for dependent filters. Reduce data loads and boost app speed.
#PowerPlatformTip 30: ‘PowerApps: Code Review’
Use AppChecker and the Power Apps Code Review Tool to ensure high-quality, efficient PowerApps solutions. Improve performance and accessibility.
#PowerPlatformTip 28: ‘Fast tips’
Access quick Power Platform tips by adding ‘.de’ to platform URLs. Instantly find curated insights and boost your productivity.
Merge Images in PowerApps Without Flow or Code Components
Discover an amazing PowerApps component that allows you to merge images, add annotations, and overlay drawings without needing Power Automate flows or premiu...
#PowerPlatformTip 23: ‘Filter Blank’
Show all gallery items in PowerApps when filter input is blank using IsBlank in your filter logic. Improve user experience and data access.
#PowerPlatformTip 22: ‘Change Fill & Color’
Change fill and color across a PowerApps Canvas App by centralizing colors in a theme variable and using the formula editor’s Find & Replace.
#PowerPlatformTip 16: ‘PowerApps: Collections Cookbook’
Access ready-to-use PowerApps collection code snippets with the Collections Cookbook. Enhance data manipulation and boost app development productivity.
#PowerPlatformTip 14: ‘Template Screens’
Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation.
#PowerPlatformTip 13: ‘PowerApps4Teams in make.powerapps.com’
Edit PowerApps4Teams apps directly in make.powerapps.com using a URL hack. Save time and boost productivity by bypassing the standard Teams creation process.
#PowerPlatformTip 10: ‘Use all variables in PowerApps’
Master all variable types in PowerApps: Go beyond Set and UpdateContext with With and Param for more dynamic, flexible app 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 2: ‘Transfer PowerApp Ownership’
Transfer Power Apps ownership after a maker leaves, using the CoE Starter Kit admin apps or the Set-AdminPowerAppOwner PowerShell cmdlet. Keep apps governed ...
How to Load Multiple Data Sources into ONE Collection
Learn efficient techniques to combine multiple data sources into a single collection in PowerApps. This guide covers identical data sources, different data s...
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...
How to Implement OnKeyDown/OnKeyPress Behavior in PowerApps Text Input: Creative Control Workarounds by Paulie M
Discover ingenious workarounds for implementing keyboard event handling in PowerApps text inputs using creative control repurposing. Paulie M demonstrates in...
Power Apps: Refresh Is Killing Your App Performance! Here’s an alternative method from Paul O’Flaherty
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...
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...
Power Apps ComboBox DefaultSelectedItems: Set One or Multiple Default Values
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...
The Big 5: Variables and Parameters in PowerApps
Discover the five essential functions for managing variables and parameters in PowerApps. Learn how to use Set, UpdateContext, With, Navigate, and Param to b...
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...