power platform · advanced
PL-400 Power Platform Developer — Complete Study Guide
Everything you need to pass the PL-400 exam: technical design decisions, ALM, Power Apps, PCF, plug-ins, custom connectors, platform APIs, Azure Functions, and data integrations — with code, decision tables, and flashcards.
pl-400certificationdataverse
PowerStack Editorial · 45 min read
power bi · advanced
Advanced Power BI: Performance Tuning, Composite Models, and Embedding
Production-grade techniques — Performance Analyzer, aggregations, composite models, deployment pipelines, embedding, and the REST API.
performancecomposite-modelsembedded
Narmer Abader · 13 min read
power bi · intermediate
DAX Essentials: Filter Context, CALCULATE, and Time Intelligence
The mental model that makes DAX click — evaluation context, CALCULATE, iterators like SUMX, and time intelligence patterns.
daxcalculatetime-intelligence
Narmer Abader · 9 min read
power bi · beginner
Power BI Fundamentals: From Install to Your First Report
What Power BI is, how Desktop, Service, and Mobile fit together, and a hands-on walkthrough to build your first interactive report.
fundamentalsgetting-starteddesktop
Narmer Abader · 6 min read
power apps · intermediate
Elevate Your Power Apps Code: A Guide to Cleaner Formulas and Better Maintenance
Learn how small coding practices—like using descriptive names, flattening conditions, and simplifying logic—can make your apps easier to update and less error-prone.
Narmer Abader · 5 min read
power apps · intermediate
Beyond Built-in Charts: Using QuickChart for Custom Visuals in Power Apps
Generate 20+ chart types in Power Apps by embedding QuickChart image URLs—add radar, doughnut, gauge, word cloud, and more to your dashboards.
Narmer Abader · 7 min read
power apps · intermediate
Enhance Your Apps with Over 2,000 Free Fluent UI Icons
A practical guide to using Microsoft's free Fluent Design System icons in Power Apps, including an interactive gallery for browsing over 2,000 icons in multiple colors.
Narmer Abader · 3 min read
power apps · intermediate
Constructing Clean Canvas Apps: A Guide to Power Apps Coding Practices
A practical walkthrough of naming conventions, error handling patterns, and performance strategies to keep your canvas apps scalable and maintainable.
Narmer Abader · 3 min read
power automate · intermediate
Structuring Power Automate Flows for Enterprise Success
Core principles for resilient, maintainable, and efficient cloud flows, distilled from real-world implementations.
Narmer Abader · 3 min read
power apps · intermediate
Filtering SharePoint Lists in Power Apps: Practical Examples and Patterns
Learn how to use the Filter function to query SharePoint list data efficiently across text, number, date, choice, lookup, person, and yes/no columns, with delegation insights.
Narmer Abader · 6 min read
power apps · intermediate
Master Conditional Logic in Power Apps: An Expense Tracker Guide
Explore the true potential of the If function in Power Apps. Through a practical expense approval scenario, learn nested conditions, delegation patterns, and how to choose Switch over IF.
Narmer Abader · 3 min read
power apps · intermediate
Reassigning Power Apps Ownership: Three Methods Every Admin Should Know
When the original app owner leaves the company, use Power Automate, PowerShell, or the CoE Starter Kit to transfer ownership without breaking the app.
Narmer Abader · 4 min read
power automate · intermediate
Embedding Images in Power Automate Emails: A Cross-Client Compatibility Guide
Discover the trade-offs between Content-ID, Base64, and the Microsoft Graph API for embedding images in Power Automate emails. This guide covers which method works best for Outlook, Gmail, and more.
Narmer Abader · 5 min read
power automate · intermediate
How to Bypass the 'File Is Locked' Error When Using Excel and SharePoint in Power Automate
When a flow reads an Excel table and then updates SharePoint file properties, the file remains locked. Here are four independent approaches to work around it—no magic, just smart automation design.
Narmer Abader · 6 min read
power automate · intermediate
Power Automate Select Action: Beyond Basic Column Picking – 5 Advanced Transformations
Transform arrays like a pro: add computed columns, row numbers, convert data types, and extract flat value lists using the Select action's hidden capabilities.
Narmer Abader · 4 min read
power apps · intermediate
Named Formulas in Power Apps: Streamlining Logic and Configuration
Use Power Apps named formulas to create reusable, reactive logic that centralizes data access, user context, and app settings.
Narmer Abader · 5 min read
power apps · intermediate
Hidden Gems: 7 Overlooked Power Apps Functions That Solve Real Problems
Move beyond the basics with seven Power Apps functions that often get ignored—learn how they can simplify your formulas, improve performance, and unlock new possibilities.
Narmer Abader · 7 min read
copilot studio · intermediate
Mastering Table Variables in Copilot Studio: Add, Remove, and Clear via YAML
Discover how the hidden EditTable YAML node lets you dynamically add, remove, or clear table variables directly inside your copilot conversations.
Narmer Abader · 5 min read
power automate · intermediate
Forcing Approval Revocation with the Teams HTTP API
The standard approval connector doesn't expose a cancel method, but a direct HTTP call to the Microsoft Teams Approvals backend makes it possible. Here's a safe, production-ready approach.
Narmer Abader · 3 min read
copilot studio · intermediate
Building an Autonomous Agent for Excel Data Enrichment
Use Copilot Studio to automate the process of reading Excel files from SharePoint, classifying data with internal knowledge, and writing results back.
Narmer Abader · 10 min read
copilot studio · intermediate
Integrate Azure SQL with Copilot Studio for Dynamic Knowledge Retrieval
Connect a Copilot Studio agent to an Azure SQL database using a service principal for secure, shareable access, and fine-tune how your agent interprets structured data with synonyms and a glossary.
Narmer Abader · 7 min read
copilot studio · intermediate
Building a Multi-Input Lookup Agent with Copilot Studio
Handle diverse user inputs gracefully by letting your Copilot Studio agent accept names, emails, or custom codes in a single prompt. Here's how to set it up and route the query logic intelligently.
Narmer Abader · 7 min read
copilot studio · intermediate
Streamline Document Analysis with Copilot Studio File Uploads
Learn how to build a Copilot Studio agent that accepts file uploads directly in a chat window, validates the file type, and uses AI prompts to extract structured information from documents.
Narmer Abader · 5 min read
copilot studio · intermediate
Automate Document Creation from Natural Language Using Copilot Studio
Create a Copilot Studio agent that fills Word templates with data from conversations, enabling instant generation of invoices, quotes, or reports.
Narmer Abader · 11 min read
power apps · intermediate
Power Apps Theming: Build a Consistent UI with a Central Style Collection
Learn how to centralize your app’s color palette, typography, icon set, and control defaults into a reusable style library that keeps every screen on brand.
Narmer Abader · 12 min read
copilot studio · intermediate
Build a Custom MCP Server for Your Copilot Studio Agents
Learn how to create a Python-based MCP server, test it with MCP Inspector, deploy it as an Azure container app, and connect it to Copilot Studio.
python
Narmer Abader · 11 min read
power apps · intermediate
Overcoming the 2,000-Record Collection Limit in Power Apps: Four Proven Methods
Practical techniques for building collections that exceed the standard delegation threshold, including concurrent batch loading, dynamic filtering with ForAll, returning large datasets from Power Automate, and importing static Excel data.
power-automate
Narmer Abader · 7 min read
copilot studio · intermediate
Automate Web Data Extraction with Computer Use Agents in Copilot Studio
Build an agent that uses the Computer Use tool to open websites, pull specific data fields, and send the results via email—no custom API required.
Narmer Abader · 8 min read
power automate · intermediate
Build Arrays Faster in Power Automate: Three Techniques Compared
Collecting items into an array is a routine task in automation. The technique you choose—variables, compose, or the Select action—can drastically influence flow execution time.
Narmer Abader · 4 min read
power apps · intermediate
Automated Member Sync from Entra Security Groups to Dataverse Teams
Eliminate the login requirement for new team members: use a Power Automate flow to force-sync users and update the Dataverse team when they are added to an Entra security group.
power-automatepower-platform-admin
Narmer Abader · 5 min read
copilot studio · intermediate
Building a Generative Orchestration Agent with Copilot Studio: A Step-by-Step Guide
Discover how to create a dynamic, multi-turn Copilot Studio agent that uses generative orchestration to manage attendee lists, confirmations, and availability searches—without rigid conversational flows.
Narmer Abader · 13 min read
power automate · intermediate
Parsing Table Data from PDFs in Power Automate with Azure AI
Leverage Azure AI Document Intelligence's pre-built Layout model to capture structured row-and-column data from PDF invoices, reports, and forms directly inside your Power Automate workflows.
azure-ai
Narmer Abader · 7 min read
power apps · intermediate
Pre-Flight Checks for Power Apps Forms: A Complete Validation Strategy
Stop invalid data at the gate by adding a pre-submission validation layer to your Power Apps forms. Learn how to use context variables and ValidationState to check required text, numeric ranges, date windows, and phone patterns.
Narmer Abader · 9 min read
copilot studio · intermediate
Build a Custom Tool to Inspect Copilot Studio Chat Histories
Create a Power Apps canvas app that connects to Dataverse to search, display, and export Copilot Studio conversation transcripts for audit and troubleshooting.
Narmer Abader · 3 min read
power apps · intermediate
Bringing Power BI Visuals into Your Power Apps Canvas
Bridge the gap between Power Apps' native controls and Power BI's rich visualization engine using embedded tiles and reports.
power-biembeddingcanvas-apps
Narmer Abader · 5 min read
power apps · intermediate
Speed Through Design: The Hidden Shortcut Mastery for Canvas Apps
Go beyond the basics: learn every keyboard command that matters, including the under-documented Alt-click runtime mode that lets you test logic on the fly.
shortcutsproductivitycanvas-apps
Narmer Abader · 15 min read
power apps · intermediate
From Dates to Data: Adding Event Management to Your Power Apps Calendar
Take your static calendar gallery to the next level by enabling users to add, view, edit, and delete events stored in SharePoint.
Narmer Abader · 9 min read
power apps · intermediate
Building and Sharing a Unified Component Library in Power Apps
Stop copy-pasting controls between apps. Learn how to create a centralized component library, import existing components, and push updates to every canvas app in your organization.
Narmer Abader · 6 min read
power apps · intermediate
Build a Custom Weekly Work Log App in Power Apps
Design a flexible time entry system with dynamic rows, inline editing, automatic totals, and SharePoint storage.
Narmer Abader · 8 min read
power platform · intermediate
Fun with Power Apps: Build a Random Cat Holiday Greeter
Combine your love for cats and low-code with this easy Power Apps project. Learn how to use collections, random selection, and galleries to create a festive seasonal app.
power-apps
Narmer Abader · 3 min read
power apps · intermediate
Capture and Store Images in SharePoint from Power Apps: Step-by-Step
Learn how to integrate the Add picture control with Power Automate to let users take or pick a photo, add a description, and upload it to a SharePoint document library.
power-automate
Narmer Abader · 7 min read
power apps · intermediate
Transforming SharePoint List Forms with Power Apps: From Basics to Advanced Customizations
Go beyond the default SharePoint form: learn to replace standard inputs with modern controls, add data validation, and redesign the layout for a better user experience.
Narmer Abader · 6 min read
power apps · intermediate
Dynamic Date Range Filtering in Power Apps Galleries
Learn to filter gallery records by any period — today, next week, last month, or a custom range — with practical Power Fx formulas and a reusable pattern.
Narmer Abader · 3 min read
power apps · intermediate
Implementing a Robust Filter Sidebar in Power Apps
Explore a state-management pattern for canvas app filters that gives users the ability to stage, apply, or discard their changes without disrupting the main data view.
Narmer Abader · 4 min read
power apps · intermediate
Filter Multi-Value SharePoint Columns in Power Apps Without Delegation Warnings
Learn how to use a Power Automate flow to filter SharePoint lists on multi-person, multi-choice, and multi-lookup columns, avoiding the delegation limitation in Power Apps.
power-automate
Narmer Abader · 6 min read
power apps · intermediate
Power Apps Form UX Mastery: Input Restrictions, Validation, and Error Handling
Learn how to enforce data entry rules, validate form fields, manage submission errors, and prevent accidental data loss in canvas apps.
Narmer Abader · 3 min read
power apps · intermediate
Mastering Power Apps Form Modes: Create, Edit, and View Records Seamlessly
Learn how to use a single form in Power Apps to switch between adding, modifying, and displaying records using NewForm, EditForm, ViewForm, and ResetForm.
Narmer Abader · 7 min read
power apps · intermediate
Mastering Power Apps Galleries: A UX-Focused Implementation Guide
Build responsive galleries with proper empty states, smart filtering, scroll resets, and performance-first patterns.
Narmer Abader · 5 min read
power apps · intermediate
Keep Users in the Loop: Building Spinners and Progress Bars in Canvas Apps
A guide to setting user expectations and improving app reliability through well-placed loading indicators, saving animations, and progress bars. Learn how to prevent double taps and reduce perceived latency.
Narmer Abader · 6 min read
power apps · intermediate
Build a File Explorer for SharePoint Document Libraries in Power Apps
Learn to create an interactive Power Apps gallery that displays files and folders from a SharePoint document library, complete with drill‑down navigation, breadcrumb trails, and file launching.
Narmer Abader · 9 min read
power apps · intermediate
Build a Reusable Sidebar Navigation Component
Create a configurable navigation menu with icons, labels, and active screen highlighting, then reuse it across your canvas app.
Narmer Abader · 8 min read
power apps · intermediate
Mastering Patch for SharePoint: A Complete Guide to Every Column Type in Power Apps
Learn how to use the Patch function effectively across all standard SharePoint column types with a practical asset management scenario. Covers text, numbers, dates, people, choices, lookups, images, hyperlinks, currencies, and task outcomes.
Narmer Abader · 3 min read
power apps · intermediate
Patch Every SharePoint Column Type in Power Apps: A Complete Reference
A practical guide with ready-to-use Patch function patterns for all major SharePoint column types, including single and multiple lines of text, choices, people, lookups, hyperlinks, images, currency, yes/no, task outcome, and more.
power-automate
Narmer Abader · 3 min read
power apps · intermediate
From Screen to PDF: Generate, Preview, and Download Documents with Power Apps
Learn how to use the PDF function to capture any control or screen as a PDF, view it, and save a copy locally—all with a standard Power Apps license.
Narmer Abader · 7 min read
power apps · intermediate
Power Apps Email Automation: Send Outlook Messages with Precision
A practical guide to building email capabilities in your canvas apps using the Office 365 Outlook connector, covering recipients, formatting, attachments, and more.
Narmer Abader · 9 min read
power apps · intermediate
Dynamic Numeric and Date Sequences with the SEQUENCE Function
Generate custom number ranges, date series, and alphanumeric patterns in Power Apps using SEQUENCE – with practical examples and performance insights.
Narmer Abader · 3 min read
power apps · intermediate
Keep Your Power Apps Clean: A Naming Standard That Works
Standardize how you name screens, controls, variables, collections, and datasources for better maintainability and team collaboration.
Narmer Abader · 3 min read
power apps · intermediate
Crafting Clean Strings: Essential Power Apps Text Functions for Real-World Data
Master text manipulation in Power Apps with practical examples for splitting, cleaning, formatting, and combining strings. Build your own data transformation toolkit.
Narmer Abader · 7 min read
power automate · advanced
Sustaining Large-Scale Flows: Five Strategies to Outrun API Throttling
Unit tests pass, production fails: your flow dies after a thousand records because APIs say 'slow down.' Learn why and how to fix it with pacing, parallelism control, progressive backoff, batch operations, and custom retry loops.
throttlingrate-limitsretry
Narmer Abader · 14 min read
power automate · intermediate
Power Automate: Unlock Hidden Step Data with actions(), outputs(), and body()
Learn how to retrieve inputs, outputs, status codes, and response bodies from previous steps using these three essential workflow functions.
Narmer Abader · 4 min read