#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...
Power Platform Solution Tags 🏷️
Find exactly what you’re looking for with our comprehensive PowerPlatformTip tag system. Our expert-curated tags help you quickly locate specific solutions, techniques, and implementation patterns for your Power Platform projects.
Popular Solution Tags
🔍 Technical Implementation: JSON, API Integration, Custom Connectors, PCF Controls
⚡ Performance & Optimization: Bulk Updates, Data Loading, Query Optimization, Caching
🔗 Integration Patterns: SharePoint, SQL Server, Excel, Teams, Office 365
🛡️ Security & Governance: User Management, Environment Switching, Permissions, Compliance
📊 Data Operations: Field Mapping, Data Validation, Import/Export, Synchronization
🎯 User Experience: Form Design, Navigation, Mobile Optimization, Accessibility
How to Use Tags
Each tag represents a specific technology, feature, or implementation pattern. Click any tag below to see all related posts, or use multiple tags to narrow your search for precise solutions.
Looking for something specific? Try our category-based browsing or explore all posts chronologically.
- PowerPlatformTip 93
- PowerApps 69
- PowerAutomate 69
- SharePoint 30
- Power Automate 25
- Power Platform 24
- PowerPlatform 20
- Performance 18
- Automation 18
- powerapps 14
- power automate 12
- Productivity 12
- YouTube 10
- productivity 10
- JSON 10
- PowerFx 10
- automation 9
- Power Apps 9
- Marcel Lehmann 8
- Dataverse 8
- Workflow 7
- Security 6
- User Experience 6
- Collections 5
- power platform 5
- Collaboration 5
- Optimization 5
- Canvas Apps 5
- AI 5
- REST 5
- HTTP 5
- Solutions 4
- powerautomate 4
- performance 4
- Permissions 4
- Governance 4
- Best Practices 4
- Patch 4
- Integration 4
- Approvals 4
- Outlook 4
- UserContext 4
- Restore 3
- Reza Dorrani 3
- Teams 3
- Efficiency 3
- Data Management 3
- HTML 3
- efficiency 3
- Testing 3
- dataverse 3
- UI Design 3
- Workflow Optimization 3
- Gallery Control 3
- Error Handling 3
- MicrosoftGraph 3
- App Development 3
- Low Code 3
- Flow 3
- ChatGPT 3
- OData 3
- AdaptiveCards 3
- ParseJSON 3
- Shane Young 2
- ComboBox 2
- Controls 2
- Lookup 2
- Paulie M 2
- TextInput 2
- No Premium 2
- StateLog 2
- Impersonation 2
- ClearCollect 2
- Backup 2
- Flow Management 2
- OneDrive 2
- filterarray 2
- expressions 2
- variables 2
- best practices 2
- data-manipulation 2
- app-development 2
- FilterArray 2
- file-management 2
- solutions 2
- gallery 2
- filtering 2
- SVG 2
- Component 2
- tips 2
- parsejson 2
- formulas 2
- data integrity 2
- Batch Processing 2
- Schema 2
- Deployment 2
- Customization 2
- Documentation 2
- Debugging 2
- Dataverse for Teams 2
- Launch Function 2
- Flexibility 2
- Monitoring 2
- Patch Function 2
- Bulk Update 2
- API Integration 2
- Troubleshooting 2
- UpdateIf 2
- Data Filtering 2
- App Performance 2
- Guest Access 2
- Microsoft Teams 2
- Concurrency 2
- Workflow Automation 2
- Dynamic Forms 2
- Expressions 2
- Cloudmersive 2
- Excel 2
- DataValidation 2
- AIBuilder 2
- OCR 2
- DocumentProcessing 2
- FileLeafRef 2
- CSV 2
- YAML 2
- BestPractices 2
- GraphAPI 2
- Expression 2
- OfficeScripts 2
- Printing 1
- PDF 1
- Labels 1
- Barcodes 1
- API 1
- John Liu 1
- PowerStudio 1
- Flow Versioning 1
- Version History 1
- Variables 1
- Parameters 1
- AppDesign 1
- DefaultSelectedItems 1
- Tables 1
- PDF Viewer 1
- Document Library 1
- Paul O'Flaherty 1
- Refresh 1
- UpdateContext 1
- DirectMessage 1
- Communication 1
- UserAccount 1
- Messaging 1
- Daniel Christian 1
- AutomateRules 1
- APIOptimization 1
- KeyboardEvents 1
- UserInterface 1
- ControlWorkarounds 1
- InteractionDesign 1
- Word Documents 1
- ZIP Files 1
- Flow Progress 1
- Timer Control 1
- GUID 1
- ElevatedPermissions 1
- Arrays 1
- Split Method 1
- Data Sources 1
- AddColumns 1
- Damien Bird 1
- XML 1
- XPath 1
- EmailProcessing 1
- DataExtraction 1
- powerplatform 1
- community 1
- support 1
- templateapps 1
- ownership 1
- admin 1
- governance 1
- coe-toolkit 1
- advanced-mode 1
- workflow-optimization 1
- json 1
- browser-extension 1
- data-handling 1
- parse json 1
- flow optimization 1
- date-formatting 1
- utcnow 1
- flow-optimization 1
- union 1
- Test 1
- error-prevention 1
- dynamic-apps 1
- best-practices 1
- trigger-condition 1
- flow-efficiency 1
- components 1
- clipboard 1
- flow-reuse 1
- url-hack 1
- powerapps4teams 1
- templates 1
- canvas-apps 1
- error-handling 1
- flow-reliability 1
- logging 1
- collections 1
- code-snippets 1
- data-formatting 1
- copilot 1
- file-download 1
- http-request 1
- image-resizing 1
- flow-owner 1
- permissions 1
- triggeroutputs 1
- error handling 1
- notifications 1
- canvas apps 1
- themes 1
- ui customization 1
- color 1
- isblank 1
- user input 1
- Image Merge 1
- Annotations 1
- No Code 1
- GitHub 1
- arrays 1
- tables 1
- data manipulation 1
- concat 1
- newsletter 1
- insights 1
- updates 1
- learning 1
- cloud skills challenge 1
- microsoft learn 1
- certification 1
- sharepoint 1
- file overwrite 1
- file management 1
- chunking 1
- settings hack 1
- quick tips 1
- dynamic content 1
- json schema 1
- code review 1
- appchecker 1
- quality assurance 1
- learning resources 1
- tutorials 1
- sharepoint integration 1
- groupby 1
- data management 1
- optimization 1
- coalesce 1
- v2 trigger 1
- security 1
- flow management 1
- concurrency control 1
- sequential processing 1
- static result 1
- flow testing 1
- table to json 1
- data transformation 1
- data refresh 1
- user experience 1
- fetchxml 1
- dynamics 365 1
- advanced queries 1
- delete apps 1
- cleanup 1
- standard tables 1
- data modeling 1
- views 1
- with function 1
- code readability 1
- maintainability 1
- DistanceCalculation 1
- Geolocation 1
- Haversine 1
- LocationServices 1
- MarcelLehmann 1
- Scopes 1
- PowerToys 1
- Windows 1
- Developer Tools 1
- REST API 1
- Bulk Operations 1
- DynamicForms 1
- Technology 1
- Sharing 1
- Teamwork 1
- Do Until 1
- Loop 1
- Retry Logic 1
- Dynamic Processes 1
- Flow Control 1
- Template App 1
- App Templates 1
- Flow Triggers 1
- Maintenance 1
- Data Platform 1
- Cost Savings 1
- SharePoint Migration 1
- Relational Data 1
- App Integration 1
- Deep Linking 1
- Navigation 1
- Teams Integration 1
- SharePoint Integration 1
- Menu Design 1
- Consistency 1
- Data-driven UI 1
- Microsoft Edge 1
- CSS Overview 1
- Colors 1
- Corporate Design 1
- Center of Excellence 1
- CoE 1
- Administration 1
- Data Update 1
- Advanced Techniques 1
- HTTP Actions 1
- Web Requests 1
- External Services 1
- Data Exchange 1
- Dynamic Content 1
- Data Parsing 1
- Robust Flows 1
- Challenges 1
- Environment Variables 1
- Configuration 1
- Large Datasets 1
- LookupFunction 1
- First 1
- Filter 1
- Data Access 1
- PowerDocu 1
- Apps 1
- Flows 1
- Data Source Structure 1
- Data Integrity 1
- App Redirection 1
- Migration 1
- App Transition 1
- Power Apps 4 Teams 1
- Hybrid App Development 1
- Fullscreen 1
- App Loading 1
- App.width 1
- App.height 1
- Teams Management 1
- Environment Management 1
- PowerApps4Teams 1
- Data Transformation 1
- Array to Object 1
- Select Action 1
- Replace Action 1
- Google Maps 1
- Mapping 1
- Location Services 1
- GIS 1
- No Premium License 1
- Maker Mode 1
- Bookmarklet 1
- App Editing 1
- Elevated Permissions 1
- Data Connections 1
- Concurrency Control 1
- Parallelism 1
- Flow Optimization 1
- Child Flows 1
- Access Management 1
- Microsoft Graph 1
- Parallel Processing 1
- Child Flow 1
- Database Trigger 1
- Control Reset 1
- App Efficiency 1
- UI Management 1
- Context Variables 1
- Record Retrieval 1
- Form.LastSubmit 1
- Data Integration 1
- DataSource Updates 1
- Code Commenting 1
- Maintainability 1
- Teams Notifications 1
- Chat Organization 1
- Flow Bot 1
- Adaptive Cards 1
- Notification Management 1
- Accessibility 1
- Tab Key 1
- UI/UX 1
- Sequence Function 1
- App Usability 1
- Delay Output 1
- Data Traffic 1
- Free Icons 1
- SVGRepo 1
- App Branding 1
- Licensing 1
- Microsoft 365 1
- Expert Help 1
- Coaching 1
- Microsoft MVP 1
- Support 1
- Code View 1
- Flow Logic 1
- Developer Plan 1
- Free Environment 1
- Community Plan 1
- IF Function 1
- Boolean Logic 1
- Formula Optimization 1
- PDF Tools 1
- Free Tools 1
- Document Automation 1
- Adobe PDF Services 1
- Encodian 1
- Muhimbi 1
- Row Numbers 1
- Galleries 1
- DOCX 1
- Text Extraction 1
- Document Processing 1
- Query Optimization 1
- Web Scraping 1
- Data Extraction 1
- No Premium Connectors 1
- Pagination 1
- Data Retrieval 1
- Secure Inputs 1
- Secure Outputs 1
- Data Security 1
- Compliance 1
- Workflow Security 1
- Flow Logs 1
- Task Automation 1
- Voice Input 1
- URL Encoding 1
- NamedFormulas 1
- GlobalVariables 1
- Choices 1
- Word 1
- QuickParts 1
- DocumentAutomation 1
- DoubleClick 1
- Timer 1
- UserExperience 1
- Timeout 1
- Approval 1
- ErrorHandling 1
- LongRunningTasks 1
- Microsoft365 1
- DataConsistency 1
- Ungroup 1
- DataIntegration 1
- ExternalApprovals 1
- EnvironmentVariables 1
- NoPremium 1
- Delegation 1
- SortByColumns 1
- EventManagement 1
- Calendar 1
- No-Code 1
- Dynamic Data 1
- AzureDocumentIntelligence 1
- CostSavings 1
- SolutionDesign 1
- ParallelProcessing 1
- ChildFlows 1
- Switch 1
- Condition 1
- CopyActions 1
- DynamicContent 1
- VSCode 1
- PowerTools 1
- TextProcessing 1
- Connector 1
- FileRef 1
- FileDirRef 1
- FlowProgress 1
- ListAnalytics 1
- PlainText 1
- OneDriveForBusiness 1
- DataTransformation 1
- ScheduledFlow 1
- StudioMode 1
- AppSecurity 1
- DynamicDataRetrieval 1
- CaseSensitivity 1
- PowerAppsTools 1
- Components 1
- ForAll 1
- BatchProcessing 1
- OfficeFiles 1
- FileViewer 1
- NoCode 1
- UpdateItem 1
- FieldMapping 1
- Coalesce 1
- Upsert 1
- FolderPermissions 1
- ListSettings 1
- MicrosoftEntraID 1
- PlusAddress 1
- Email 1
- MailTracking 1
- AzureAI 1
- AdobePDF 1
- Invoices 1
- Split 1
- Array 1
- DataProcessing 1
- CopilotCredits 1
- CostOptimization 1
- HTTPRequests 1
- JSONHandling 1
- ODataFilters 1
- ApplyToEach 1
- SharedMailbox 1
- Markdown 1
- VirtualTables 1
- ModelDrivenApp 1
- Sequence 1
- TimePicker 1
- Metadata 1
- Math 1
- Percentage 1
- float 1
- Files 1
- Limits 1
- CitizenDeveloper 1
- Launch 1
- FileDownload 1
- CanvasApps 1
- Consulting 1
- SchemaXml 1
- MicrosoftTeams 1
- Channels 1
PowerPlatformTip
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
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...
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
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’...
#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 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
#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 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 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 t...
#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 identi...
#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, 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 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 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
#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 133: ‘SharePoint Updates with Power Automate, No Required Fields Needed’
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
#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 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 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 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 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 even...
#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 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 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 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 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 109: ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
#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 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 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 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#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 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#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 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 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
#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 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 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 expressions ...
#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 15: ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
#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 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...
PowerApps
#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 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 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 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
#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 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 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...
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.
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 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 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...
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 Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
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...
PowerAutomate
#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
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...
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
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’...
#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 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
#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 t...
#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 identi...
#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, 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 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 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 even...
#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 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 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 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 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 expressions ...
#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...
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...
Power Automate
#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 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 f...
#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 se...
#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 streaml...
#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 con...
#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 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 troub...
#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 stream...
#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 l...
#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 a...
#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, stre...
#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.
Power Platform
#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 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 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 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 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 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 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 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 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#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 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
#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 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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
PowerPlatform
#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 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 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...
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...
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...
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...
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 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...
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 Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
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...
Performance
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
#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 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 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 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 97: ‘Enhanced Pagination’
Overcome default item limits in Power Automate by enabling enhanced pagination for Excel and SharePoint, retrieve more data, improve performance, and streaml...
#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 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 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 l...
#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 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 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 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 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 ...
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 ...
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...
Automation
#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...
#PowerPlatformTip 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
#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 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 120: ‘PowerAutomate, Text Processing 2.0’
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
#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 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 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 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 l...
#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 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 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#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 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 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 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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
powerapps
#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’
Use Coalesce in PowerApps and Power Automate to simplify handling blank values and reduce nested If statements. Improve formula efficiency.
#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.
#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 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 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 ...
power automate
#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 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 f...
Productivity
#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 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 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 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 troub...
#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 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 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 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 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#PowerPlatformTip 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
YouTube
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...
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...
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 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 ...
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 Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
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...
productivity
#PowerPlatformTip 28: ‘Fast tips’
Access quick Power Platform tips by adding ‘.de’ to platform URLs. Instantly find curated insights and boost your productivity.
#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 expressions ...
#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 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 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 6: ‘formatDateTime in utcNow’
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
#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 1: ‘Explore Community Resources’
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
JSON
#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 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 t...
#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 128: ‘Dynamic Data Retrieval’
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
#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 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 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 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...
PowerFx
#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 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 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 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 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 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 108: ‘Double-Click Magic in PowerApps’
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
#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.
automation
#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 35: ‘Concurrent Control’
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
#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 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 15: ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
#PowerPlatformTip 11: ‘Trigger Condition’
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
Power Apps
#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 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 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...
Marcel Lehmann
#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 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 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 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 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...
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...
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...
Dataverse
#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 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 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 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 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...
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...
Workflow
#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 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 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 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 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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Security
#PowerPlatformTip 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
#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 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
#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...
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...
User Experience
#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 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 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 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...
Collections
#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 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 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 ...
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...
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 platform
#PowerPlatformTip 39: ‘Mastering FetchXML’
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
#PowerPlatformTip 31: ‘Microsoft Power Platform: Learning Resources’
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
#PowerPlatformTip 28: ‘Fast tips’
Access quick Power Platform tips by adding ‘.de’ to platform URLs. Instantly find curated insights and boost your productivity.
#PowerPlatformTip 26: ‘Microsoft Cloud Skills Challenge’
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
#PowerPlatformTip 25: ‘Weekly tips, insights and updates’
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
Collaboration
#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 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 stream...
#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 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 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...
Optimization
#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 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 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 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 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...
Canvas Apps
#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 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 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 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...
AI
#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 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 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 f...
#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 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...
REST
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
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...
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
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’...
#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 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.
HTTP
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
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’...
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
#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 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.
Solutions
#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 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#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...
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...
powerautomate
#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 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.
performance
#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 38: ‘Data Refresh’
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
#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.
Permissions
#PowerPlatformTip 160: ‘Set SharePoint Item Permissions with Power Automate’
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’...
#PowerPlatformTip 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
#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 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...
Governance
#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 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 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Best Practices
#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 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#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 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Patch
#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 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 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 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...
Integration
#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 streaml...
#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 con...
#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.
Approvals
#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 identi...
#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 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 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.
Outlook
#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 identi...
#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 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 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.
UserContext
#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 identi...
#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 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.
Restore
#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...
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...
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...
Reza Dorrani
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...
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...
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...
Teams
#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 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.
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...
Efficiency
#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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
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 ...
Data Management
#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 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...
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...
HTML
#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 t...
#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 con...
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...
efficiency
#PowerPlatformTip 36: ‘Static Result’
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
#PowerPlatformTip 33: ‘Coalesce’
Use Coalesce in PowerApps and Power Automate to simplify handling blank values and reduce nested If statements. Improve formula efficiency.
#PowerPlatformTip 7: ‘UNION and FilterArray’
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
Testing
#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 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 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.
dataverse
#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 39: ‘Mastering FetchXML’
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
UI Design
#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 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 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Workflow Optimization
#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 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
#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 ...
Gallery Control
#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 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 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...
Error Handling
#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 l...
#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 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...
MicrosoftGraph
#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 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 even...
#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 ...
App Development
#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 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...
Low Code
#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 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 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...
Flow
#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 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 f...
#PowerPlatformTip 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
ChatGPT
#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 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 f...
#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...
OData
#PowerPlatformTip 129: ‘Case-sensitive SharePoint Filtering’
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
#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 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.
AdaptiveCards
#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 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 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.
ParseJSON
#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 128: ‘Dynamic Data Retrieval’
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
#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.
Shane Young
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
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...
ComboBox
#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.
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
Controls
#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...
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
Lookup
#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...
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
Paulie M
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...
TextInput
#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...
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...
StateLog
#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.
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...
Impersonation
#PowerPlatformTip 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
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...
ClearCollect
#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...
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...
Backup
#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...
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...
Flow Management
#PowerPlatformTip 45: ‘Use Scopes’
Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure.
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...
OneDrive
#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 con...
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...
filterarray
#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 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.
expressions
#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 expressions ...
#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.
variables
#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 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 f...
best practices
#PowerPlatformTip 31: ‘Microsoft Power Platform: Learning Resources’
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
#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 f...
data-manipulation
#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 7: ‘UNION and FilterArray’
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
app-development
#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 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.
FilterArray
#PowerPlatformTip 129: ‘Case-sensitive SharePoint Filtering’
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
#PowerPlatformTip 11: ‘Trigger Condition’
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
file-management
#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.
solutions
#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 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.
gallery
#PowerPlatformTip 38: ‘Data Refresh’
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
#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.
filtering
#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 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.
SVG
#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...
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...
Component
#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.
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...
tips
#PowerPlatformTip 28: ‘Fast tips’
Access quick Power Platform tips by adding ‘.de’ to platform URLs. Instantly find curated insights and boost your productivity.
#PowerPlatformTip 25: ‘Weekly tips, insights and updates’
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
parsejson
#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 29: ‘ParseJSON Description’
Add custom descriptions in Power Automate’s Parse JSON action to organize and distinguish similar Dynamic Content entries. Improve flow clarity.
formulas
#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 33: ‘Coalesce’
Use Coalesce in PowerApps and Power Automate to simplify handling blank values and reduce nested If statements. Improve formula efficiency.
data integrity
#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.
Batch Processing
#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 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 ...
Schema
#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.
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...
Deployment
#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 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...
Customization
#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 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...
Documentation
#PowerPlatformTip 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
#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.
Debugging
#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 troub...
#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.
Dataverse for Teams
#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 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...
Launch Function
#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 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...
Flexibility
#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 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...
Monitoring
#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 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Patch Function
#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 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...
Bulk Update
#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 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...
API Integration
#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 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 ...
Troubleshooting
#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 troub...
#PowerPlatformTip 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
UpdateIf
#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 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...
Data Filtering
#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 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...
App Performance
#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 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...
Guest Access
#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 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...
Microsoft Teams
#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 stream...
#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...
Concurrency
#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 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 l...
Workflow Automation
#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 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...
Dynamic Forms
#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 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...
Expressions
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
#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 troub...
Cloudmersive
#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 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.
Excel
#PowerPlatformTip 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
#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 streaml...
DataValidation
#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 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.
AIBuilder
#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 115: ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
OCR
#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 115: ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
DocumentProcessing
#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 115: ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
FileLeafRef
#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 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 ...
CSV
#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.
YAML
#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 130: ‘Build Apps Faster with YAML’
Use YAML snippets to integrate pre-designed UI components into Power Apps, enabling faster development without design expertise.
BestPractices
#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 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...
GraphAPI
#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...
#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.
Expression
#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 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.
OfficeScripts
#PowerPlatformTip 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
#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 t...
Printing
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...
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...
Labels
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...
Barcodes
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...
API
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...
John Liu
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...
PowerStudio
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...
Flow Versioning
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...
Version History
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...
Variables
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...
Parameters
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...
AppDesign
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...
DefaultSelectedItems
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
Tables
Power Apps Combo Box DefaultSelectedItems from Shane Young
Learn how to properly set DefaultSelectedItems in PowerApps ComboBox controls using tables, lookups, and manually-created records. A comprehensive guide by S...
PDF Viewer
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...
Document Library
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...
Paul O'Flaherty
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...
Refresh
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...
UpdateContext
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...
DirectMessage
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...
Communication
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...
UserAccount
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...
Messaging
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...
Daniel Christian
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 ...
AutomateRules
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 ...
APIOptimization
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 ...
KeyboardEvents
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...
UserInterface
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...
ControlWorkarounds
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...
InteractionDesign
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...
Word Documents
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...
ZIP Files
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...
Flow Progress
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...
Timer Control
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...
GUID
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...
ElevatedPermissions
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...
Arrays
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...
Split Method
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...
Data Sources
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...
AddColumns
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...
Damien Bird
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...
XML
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...
XPath
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...
EmailProcessing
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...
DataExtraction
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...
powerplatform
#PowerPlatformTip 1: ‘Explore Community Resources’
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
community
#PowerPlatformTip 1: ‘Explore Community Resources’
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
support
#PowerPlatformTip 1: ‘Explore Community Resources’
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
templateapps
#PowerPlatformTip 1: ‘Explore Community Resources’
Discover the Microsoft Power Platform Community: Get expert support, find ready-to-use sample apps, and boost your productivity with shared resources and sol...
ownership
#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 ...
admin
#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 ...
governance
#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 ...
coe-toolkit
#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 ...
advanced-mode
#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.
workflow-optimization
#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.
json
#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.
browser-extension
#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.
data-handling
#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.
parse json
#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 f...
flow optimization
#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 f...
date-formatting
#PowerPlatformTip 6: ‘formatDateTime in utcNow’
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
utcnow
#PowerPlatformTip 6: ‘formatDateTime in utcNow’
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
flow-optimization
#PowerPlatformTip 6: ‘formatDateTime in utcNow’
Format dates in Power Automate with utcNow: Skip extra functions, simplify flows, and boost efficiency with direct date formatting.
union
#PowerPlatformTip 7: ‘UNION and FilterArray’
Merge and filter arrays in Power Automate: Use UNION and FilterArray for efficient data manipulation, deduplication, and smarter workflows.
Test
#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.
error-prevention
#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.
dynamic-apps
#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.
best-practices
#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.
trigger-condition
#PowerPlatformTip 11: ‘Trigger Condition’
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
flow-efficiency
#PowerPlatformTip 11: ‘Trigger Condition’
Create precise trigger conditions in Power Automate using Filter Array and advanced expressions to streamline your flow and boost efficiency.
components
#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.
clipboard
#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.
flow-reuse
#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.
url-hack
#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.
powerapps4teams
#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.
templates
#PowerPlatformTip 14: ‘Template Screens’
Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation.
canvas-apps
#PowerPlatformTip 14: ‘Template Screens’
Accelerate Power Apps development with pre-built template screens for common functions. Save time, boost productivity, and streamline app creation.
error-handling
#PowerPlatformTip 15: ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
flow-reliability
#PowerPlatformTip 15: ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
logging
#PowerPlatformTip 15: ‘try-catch-finally’
Implement the try-catch-finally pattern in Power Automate for robust error handling, improved flow reliability, and automated cleanup.
collections
#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.
code-snippets
#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.
data-formatting
#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 expressions ...
copilot
#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 expressions ...
file-download
#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.
http-request
#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.
image-resizing
#PowerPlatformTip 19: ‘Resize files’
Easily resize large images in Power Automate using SharePoint thumbnails and file management actions. Streamline image processing and automation.
flow-owner
#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.
permissions
#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.
triggeroutputs
#PowerPlatformTip 21: ‘Use Triggeroutput’
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
error handling
#PowerPlatformTip 21: ‘Use Triggeroutput’
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
notifications
#PowerPlatformTip 21: ‘Use Triggeroutput’
Use triggerOutputs() in Power Automate to notify flow starters, extract header info, and handle errors for robust automation.
canvas apps
#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.
themes
#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.
ui customization
#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.
color
#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.
isblank
#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.
user input
#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.
Image Merge
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...
Annotations
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...
No Code
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...
GitHub
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...
arrays
#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.
tables
#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.
data manipulation
#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.
concat
#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.
insights
#PowerPlatformTip 25: ‘Weekly tips, insights and updates’
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
updates
#PowerPlatformTip 25: ‘Weekly tips, insights and updates’
Subscribe to Power Platform newsletters for weekly tips, insights, and updates. Stay informed on the latest Power Platform developments.
learning
#PowerPlatformTip 26: ‘Microsoft Cloud Skills Challenge’
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
cloud skills challenge
#PowerPlatformTip 26: ‘Microsoft Cloud Skills Challenge’
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
microsoft learn
#PowerPlatformTip 26: ‘Microsoft Cloud Skills Challenge’
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
certification
#PowerPlatformTip 26: ‘Microsoft Cloud Skills Challenge’
Boost your Power Platform skills with the Microsoft Cloud Skills Challenge - free, gamified Microsoft Learn modules with leaderboards and prizes.
file overwrite
#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.
file management
#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.
chunking
#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.
settings hack
#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.
quick tips
#PowerPlatformTip 28: ‘Fast tips’
Access quick Power Platform tips by adding ‘.de’ to platform URLs. Instantly find curated insights and boost your productivity.
dynamic content
#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.
json schema
#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.
code review
#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.
appchecker
#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.
quality assurance
#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.
learning resources
#PowerPlatformTip 31: ‘Microsoft Power Platform: Learning Resources’
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
tutorials
#PowerPlatformTip 31: ‘Microsoft Power Platform: Learning Resources’
Access comprehensive Microsoft Power Platform learning resources, tutorials, and best practices for all skill levels, including SharePoint integration.
groupby
#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.
data management
#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.
optimization
#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.
coalesce
#PowerPlatformTip 33: ‘Coalesce’
Use Coalesce in PowerApps and Power Automate to simplify handling blank values and reduce nested If statements. Improve formula efficiency.
v2 trigger
#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.
security
#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.
flow management
#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.
concurrency control
#PowerPlatformTip 35: ‘Concurrent Control’
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
sequential processing
#PowerPlatformTip 35: ‘Concurrent Control’
Enable Concurrency Control in Power Automate to run flows sequentially, prevent data duplication, and ensure data integrity. Optimize automation reliability.
static result
#PowerPlatformTip 36: ‘Static Result’
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
flow testing
#PowerPlatformTip 36: ‘Static Result’
Use Static Result in Power Automate to simulate action outcomes during testing, preserve data, and speed up flow development.
table to json
#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.
data transformation
#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.
data refresh
#PowerPlatformTip 38: ‘Data Refresh’
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
user experience
#PowerPlatformTip 38: ‘Data Refresh’
Use a Boolean variable to selectively refresh PowerApps gallery data, improving performance and user experience without reloading all data.
fetchxml
#PowerPlatformTip 39: ‘Mastering FetchXML’
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
dynamics 365
#PowerPlatformTip 39: ‘Mastering FetchXML’
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
advanced queries
#PowerPlatformTip 39: ‘Mastering FetchXML’
Master FetchXML for advanced data queries in Dataverse and Dynamics 365. Retrieve complex data with powerful XML-based queries.
delete apps
#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.
cleanup
#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.
standard tables
#PowerPlatformTip 41: ‘Standard tables in Dataverse’
Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling.
data modeling
#PowerPlatformTip 41: ‘Standard tables in Dataverse’
Use standard tables in Dataverse for common business processes to ensure consistency, interoperability, and efficient data modeling.
views
#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.
with function
#PowerPlatformTip 43: ‘With function’
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
code readability
#PowerPlatformTip 43: ‘With function’
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
maintainability
#PowerPlatformTip 43: ‘With function’
Use the With function in PowerApps to group variable declarations and simplify complex formulas for improved code readability and maintainability.
DistanceCalculation
#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.
Geolocation
#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.
Haversine
#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.
LocationServices
#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.
MarcelLehmann
#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.
Scopes
#PowerPlatformTip 45: ‘Use Scopes’
Organize Power Automate flows with Scopes for better error handling, flow management, and reusable templates. Enhance troubleshooting and structure.
PowerToys
#PowerPlatformTip 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Windows
#PowerPlatformTip 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
Developer Tools
#PowerPlatformTip 46: ‘PowerToys’
Boost Power Platform productivity on Windows with Microsoft PowerToys. Learn how FancyZones, PowerToys Run, Keyboard Manager, Color Picker, Text Extractor, a...
REST API
#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 ...
Bulk Operations
#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 ...
DynamicForms
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...
Technology
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...
Teamwork
#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...
Do Until
#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...
Loop
#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...
Retry Logic
#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...
Dynamic Processes
#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...
Flow Control
#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...
Template App
#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...
App Templates
#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...
Flow Triggers
#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.
Maintenance
#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.
Data Platform
#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...
Cost Savings
#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...
Relational Data
#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...
App Integration
#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...
Deep Linking
#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...
Teams Integration
#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...
Consistency
#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...
Data-driven UI
#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...
Microsoft Edge
#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...
CSS Overview
#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...
Colors
#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...
Corporate Design
#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...
Center of Excellence
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
CoE
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Administration
#PowerPlatformTip 56: ‘Empowering Tools in CoE’
Empower your Power Platform Center of Excellence (CoE) with essential tools. Discover how to streamline governance, monitoring, and administration for scalab...
Data Update
#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...
Advanced Techniques
#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...
HTTP Actions
#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 ...
Web Requests
#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 ...
External Services
#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 ...
Data Exchange
#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 ...
Dynamic Content
#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...
Data Parsing
#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...
Robust Flows
#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...
Challenges
#PowerPlatformTip 60: ‘Power Platform Challenges’
Tackle Power Platform challenges with proven strategies. Explore solutions for common issues, optimize workflows, and boost productivity with expert Power Pl...
Environment Variables
#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 ...
Configuration
#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 ...
Large Datasets
#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...
LookupFunction
#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 ...
First
#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...
Filter
#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...
Data Access
#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...
PowerDocu
#PowerPlatformTip 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
Apps
#PowerPlatformTip 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
Flows
#PowerPlatformTip 65: ‘Automate Documentation with PowerDocu’
Automate documentation in Power Platform with PowerDocu. Generate up-to-date documentation for apps and flows, improve governance, and save time with this es...
Data Source Structure
#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...
Data Integrity
#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...
App Redirection
#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...
Migration
#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...
App Transition
#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...
Power Apps 4 Teams
#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...
Hybrid App Development
#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...
Fullscreen
#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...
App Loading
#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...
App.width
#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...
App.height
#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...
Teams Management
#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...
Environment Management
#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...
PowerApps4Teams
#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...
Data Transformation
#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...
Array to Object
#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...
Select Action
#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...
Replace Action
#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...
Google Maps
#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...
Mapping
#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...
Location Services
#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...
GIS
#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...
Maker Mode
#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...
Bookmarklet
#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...
App Editing
#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...
Elevated Permissions
#PowerPlatformTip 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
Data Connections
#PowerPlatformTip 74: ‘Elevated Permissions’
Run PowerApps data connections with elevated permissions using Power Automate flows, enable secure actions beyond user rights, leveraging impersonation and a...
Concurrency Control
#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...
Parallelism
#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...
Flow Optimization
#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...
Child Flows
#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...
Access Management
#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...
Microsoft Graph
#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...
Parallel Processing
#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 l...
Child Flow
#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 l...
Database Trigger
#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 l...
Control Reset
#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...
App Efficiency
#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...
UI Management
#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...
Context Variables
#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...
Record Retrieval
#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...
Form.LastSubmit
#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...
Data Integration
#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...
DataSource Updates
#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...
Code Commenting
#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...
Maintainability
#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...
Teams Notifications
#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 stream...
Chat Organization
#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 stream...
Flow Bot
#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 stream...
Adaptive Cards
#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 stream...
Notification Management
#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 stream...
Accessibility
#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...
Tab Key
#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...
UI/UX
#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...
Sequence Function
#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...
App Usability
#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...
Delay Output
#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...
Data Traffic
#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...
Free Icons
#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...
SVGRepo
#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...
App Branding
#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...
Licensing
#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 ...
Microsoft 365
#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 ...
Expert Help
#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...
Coaching
#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...
Microsoft MVP
#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...
Support
#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...
Code View
#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 troub...
Flow Logic
#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 troub...
Developer Plan
#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 ...
Free Environment
#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 ...
Community Plan
#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 ...
IF Function
#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 ...
Boolean Logic
#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 ...
Formula Optimization
#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 ...
PDF Tools
#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.
Free Tools
#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.
Document Automation
#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.
Adobe PDF Services
#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.
Encodian
#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.
Muhimbi
#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.
Row Numbers
#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...
Galleries
#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...
DOCX
#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.
Text Extraction
#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.
Document Processing
#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.
Query Optimization
#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.
Web Scraping
#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 con...
Data Extraction
#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 con...
Pagination
#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 streaml...
Data Retrieval
#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 streaml...
Secure Inputs
#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 se...
Secure Outputs
#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 se...
Data Security
#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 se...
Compliance
#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 se...
Workflow Security
#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 se...
Flow Logs
#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 se...
Task Automation
#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 f...
Voice Input
#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 f...
URL Encoding
#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 f...
NamedFormulas
#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.
GlobalVariables
#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.
Choices
#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.
Word
#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.
QuickParts
#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.
DocumentAutomation
#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.
DoubleClick
#PowerPlatformTip 108: ‘Double-Click Magic in PowerApps’
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
Timer
#PowerPlatformTip 108: ‘Double-Click Magic in PowerApps’
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
UserExperience
#PowerPlatformTip 108: ‘Double-Click Magic in PowerApps’
Distinguish single and double clicks in PowerApps to trigger different functionalities, bringing desktop-like efficiency without clutter.
Timeout
#PowerPlatformTip 109: ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
Approval
#PowerPlatformTip 109: ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
ErrorHandling
#PowerPlatformTip 109: ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
LongRunningTasks
#PowerPlatformTip 109: ‘Use TimeOut’
Extend action timeouts and add error handling to ensure long-running Power Automate tasks complete without disruption.
Microsoft365
#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.
DataConsistency
#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.
Ungroup
#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.
DataIntegration
#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.
ExternalApprovals
#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.
EnvironmentVariables
#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 ...
Delegation
#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.
SortByColumns
#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.
EventManagement
#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 even...
Calendar
#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 even...
No-Code
#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...
Dynamic Data
#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...
AzureDocumentIntelligence
#PowerPlatformTip 115: ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
CostSavings
#PowerPlatformTip 115: ‘AI OCR Models’
Compare AI Builder and Azure Document Intelligence in Power Platform for cost-effective, flexible AI OCR document processing.
SolutionDesign
#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.
ParallelProcessing
#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.
ChildFlows
#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.
Switch
#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.
Condition
#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.
CopyActions
#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.
DynamicContent
#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.
VSCode
#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.
PowerTools
#PowerPlatformTip 120: ‘PowerAutomate, Text Processing 2.0’
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
TextProcessing
#PowerPlatformTip 120: ‘PowerAutomate, Text Processing 2.0’
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
Connector
#PowerPlatformTip 120: ‘PowerAutomate, Text Processing 2.0’
Use PowerTools for advanced text extraction and manipulation directly within Power Automate flows.
FileRef
#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 ...
FileDirRef
#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 ...
FlowProgress
#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.
ListAnalytics
#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.
PlainText
#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.
OneDriveForBusiness
#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.
DataTransformation
#PowerPlatformTip 125: ‘Convert CSV to JSON’
Convert CSV data into JSON in Power Automate using only standard actions without premium connectors or external services.
ScheduledFlow
#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.
StudioMode
#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.
AppSecurity
#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.
DynamicDataRetrieval
#PowerPlatformTip 128: ‘Dynamic Data Retrieval’
Use Parse JSON with dynamic keys in Power Automate to flexibly retrieve data without complex conditions.
CaseSensitivity
#PowerPlatformTip 129: ‘Case-sensitive SharePoint Filtering’
Combine OData filtering with Filter array in Power Automate for precise, case-sensitive SharePoint queries.
PowerAppsTools
#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.
Components
#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.
ForAll
#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.
BatchProcessing
#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.
OfficeFiles
#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.
FileViewer
#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.
NoCode
#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.
UpdateItem
#PowerPlatformTip 133: ‘SharePoint Updates with Power Automate, No Required Fields Needed’
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
FieldMapping
#PowerPlatformTip 133: ‘SharePoint Updates with Power Automate, No Required Fields Needed’
Update specific SharePoint fields in Power Automate without HTTP requests or required fields.
Coalesce
#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.
Upsert
#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.
FolderPermissions
#PowerPlatformTip 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
ListSettings
#PowerPlatformTip 137: ‘SharePoint Lists Folder Permissions’
Enable folder-based permissions in SharePoint lists to streamline access control without building item-by-item Power Automate flows.
MicrosoftEntraID
#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.
PlusAddress
#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 139: ‘Plus Address Tracking’
Use plus addressing in Power Automate, Outlook, and Gmail to tag every automated email with its source for instant traceability.
MailTracking
#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.
AzureAI
#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...
AdobePDF
#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...
Invoices
#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...
Split
#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.
Array
#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.
DataProcessing
#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.
CopilotCredits
#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...
CostOptimization
#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...
HTTPRequests
#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...
JSONHandling
#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...
ODataFilters
#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...
ApplyToEach
#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...
Markdown
#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 t...
VirtualTables
#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...
ModelDrivenApp
#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...
Sequence
#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:...
TimePicker
#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:...
Metadata
#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...
Math
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
Percentage
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
float
#PowerPlatformTip 155: ‘Float Before Div for Correct Decimals in Power Automate’
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...
Files
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
Limits
#PowerPlatformTip 156: ‘Handle Files up to 1 GB with Chunking in Power Automate’
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 ...
CitizenDeveloper
#PowerPlatformTip 157: ‘Run Office Scripts from Power Automate – 25 Everyday Excel Automations’
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...
Launch
#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 ...
FileDownload
#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 ...
CanvasApps
#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 ...
Consulting
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
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...
SchemaXml
#PowerPlatformTip 161: ‘Clone a SharePoint List’s Custom Columns to Another Site’
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...
MicrosoftTeams
#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...
Channels
#PowerPlatformTip 162: ‘Create a Private Teams Channel from a Flow’
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...