References that build faster
Cheat sheets, interactive helpers, and standards for Power Platform development — Power Fx, expressions, HTML email, HTTP, and the conventions that keep a solution maintainable.
Adaptive Cards
Author Adaptive Cards that render as native UI in Teams, Outlook, and bots. A live card designer with a JSON editor and starter gallery, plus filterable cheat sheets for every element, container, input, and action — and the rules for posting cards from Power Automate and embedding them in Outlook actionable messages.
Power Fx Cheat Sheet
A working reference for Power Fx — the low-code formula language behind Power Apps, cards, and Copilot Studio. Text, logic, tables, error handling, people, choices, theming, offline storage, reusable components, and the delegation rules that decide whether a formula scales.
Expressions & JSON Cheat Sheet
The Workflow Definition Language (WDL) expressions behind cloud flows — string, collection, logical, date, encoding, and reference functions, plus JSON handling, array/date/JSON cookbooks, and the gotchas that burn everyone. Filter the playground to find a function fast.
Regex Reference
Regular expressions in Power Fx — the IsMatch, Match, and MatchAll functions behind validation and text extraction in canvas apps, model-driven apps, Copilot Studio, and Power Pages. Match options, the Match enum, a full syntax cheat sheet, the cross-platform subset Power Fx actually allows, plus copy-paste validation and parsing recipes.
HTTP Requests & APIs
A deep reference for the HTTP action and Power Automate’s API surface — authentication (OAuth, Key Vault, Managed Identity, certificates, SAS), OData querying, file handling, inbound webhooks, async polling, throttling and $batch, plus a copy-paste cookbook for Graph, SharePoint, Dataverse and Azure DevOps. Includes a request builder that scaffolds the action JSON with query params, auth presets and a cURL equivalent.
JSON Schema for Parse JSON
The JSON Schema dialect behind the Parse JSON action and the "When a HTTP request is received" trigger — types, properties, required, items, and the nullable patterns that stop Parse JSON failing at runtime. Paste a sample payload into the generator to get a ready-to-use schema, with switches for required arrays and a "never fails" nullable mode.
HTML Email Toolkit
Build emails that survive Outlook. A live preview gallery, a battle-tested responsive boilerplate, VML bulletproof buttons, responsive + accessibility + deliverability guidance, and the rules for sending rich HTML from Power Automate’s “Send an email (V2)” action.
Power BI / DAX Cheat Sheet
A working reference for DAX and the Power BI model behind it — aggregations, iterators, CALCULATE and filter context, time intelligence, variables, window functions, calculation groups, Power Query (M), and the data-modeling and performance rules that decide whether a report scales. Every cheat table is searchable.
Connectors Reference
A field guide to Power Automate & Power Apps connectors — what a connector actually is, triggers vs actions, standard vs premium (and what that costs you in licensing), polling vs webhook triggers and their wake-up intervals, connections and connection references for ALM, custom and on-premises connectors, plus the limits that bite in production: Power Platform request allocations, connector throttling and 429s, message size, timeouts, recurrence and concurrency limits.
Best Practices & Standards
The standards that separate a demo from a production automation — error handling, reliability, performance, testing, monitoring, security, governance, and the standards that keep an estate maintainable — distilled into rules you can apply on every flow.
Governance & DLP
How to keep a Power Platform estate safe and supportable as it scales past one maker — data loss prevention (DLP) policies and connector classification, Managed Environments, environment strategy and environment groups, the CoE Starter Kit, and the tenant-level admin controls (tenant isolation, IP firewall, sharing limits, auditing) that draw the trust boundaries around your data.
Naming Conventions & ALM
Consistent names and a clean solution/environment strategy are what let a Power Platform estate scale past one maker. Naming patterns for every component type, plus a practical, source-controlled ALM pipeline — pac CLI, Azure DevOps, GitHub Actions, deployment settings, versioning, and rollback.
Dataverse Developer Reference
A working reference for Microsoft Dataverse — the relational, secure data platform under Power Apps, Power Automate, and Dynamics 365. Tables and column types, relationships, the OData v4 Web API, OData query options, FetchXML, the plug-in event pipeline and SDK, and the security-role model (privileges, access levels, business units, teams).
Copilot Studio Cheat Sheet
A working reference for Microsoft Copilot Studio — building agents with topics, generative vs classic orchestration, Power Fx in the conversation, variables and entities, knowledge sources and grounding, tools and actions, authentication, channels, ALM, and the analytics that tell you whether it works.
SharePoint Patterns
A working reference for building on SharePoint Online — the REST/OData API surface, list-item CRUD with the right headers, querying and expanding lookup/person fields, surviving the 5,000-item list view threshold with column indexing, throttling and $batch, unique permissions and role assignments, document-library file handling (including chunked large-file upload), and the Power Automate SharePoint connector patterns that pull it all together.
Power Automate Desktop Patterns
A working reference for Power Automate Desktop (PAD) — the RPA engine for Windows. Variables and the % notation, data types and structures, control flow, error handling, UI/browser/Excel automation, cloud orchestration, plus the FlowLibs copy-paste designer syntax that pairs with the PAD skills.
Every guide is generated from one structured dataset, so the same references can power the FlowLibs MCP server for AI assistants.