Cheat sheets · 12
Power Platform cheat sheets and checklists
The pages to keep open while you build. Each one has a button to print it or save it as a PDF.
Power Apps
Delegation cheat sheet: what works on SharePoint, Dataverse and SQL Server
Which Power Apps functions and operators run on the data source, and which quietly stop at 500 rows, for SharePoint, Dataverse and SQL Server, with the delegable rewrite for each common trap.
Power Automate
OData filter query cheat sheet for SharePoint, Dataverse and SQL Server
Copy-ready filter queries for Get items (SharePoint), List rows (Dataverse) and Get rows (SQL Server): operators, text, dates, lookups and choices, what each source doesn't support, and the errors that mean your syntax is off.
Power Automate
Power Automate expressions cheat sheet: functions with examples
Power Automate expressions list by job: text, arrays, logic, conversion, dates and step references, each with syntax and an example, plus null-safe ? and the traps.
Power BI
Power BI DAX cheat sheet: the functions you use, with examples
A Power BI DAX cheat sheet: SUMX, CALCULATE, ALL, SWITCH, DIVIDE, RELATED, time intelligence, RANKX and VAR, each with its syntax, meaning, an example and the traps.
Power BI
Power BI permissions cheat sheet: workspace roles, apps, Read and Build
Who can see, edit, share and build on what. Workspace roles side by side, the four semantic model permissions, how apps and sharing grant access, what RLS does and doesn't restrict, and answers to the questions people ask every week.
Power BI
Power BI refresh failed? A checklist from first look to fix
Power BI refresh failed? Check credentials, the gateway, privacy levels, time-outs and size, then the schedule, in that order, with the fix for each.
Dataverse
Dataverse access cheat sheet: privileges, access levels and 'missing privilege' errors
How Dataverse decides whether someone can see or change a row, what each privilege and access level really grants, and the fix for every common access error, from 'missing privilege' to 'can't open the environment'.
Power Pages
Power Pages Web API cheat sheet: setup, site settings, the wildcard change and error codes
Everything to make /_api calls work: the site settings per table, why Webapi/<table>/fields = * stopped working on 14 September 2026 and how to fix it, the CSRF token wrapper, table permissions, what the Web API can't do, and every status and error code with its fix.
Power Pages
Power Pages data security checklist: table permissions, web roles and sign-in
A pre-launch and troubleshooting checklist for Power Pages: the access types and privileges in table permissions, the settings that leave data open to anonymous visitors, and the fixes for common sign-in and permission errors.
Governance & admin
Data policy (DLP) checklist: design, roll out and support Power Platform data policies
How Power Platform data policies decide what makers can connect, the rules that surprise admins (combined policies, unblockable connectors, HTTP and child flows), a safe rollout checklist, and what to do when a policy suspends a flow.
Apps & integration
Azure Functions .NET in-process model ends on 10 November 2026: the migration checklist
Support for the Azure Functions .NET in-process model ends on 10 November 2026. This migration checklist finds the apps that still use it, converts the project, packages, Program.cs, bindings and logging to the isolated worker model, and deploys through a staging slot without an outage.
Networking & VMs
Power Platform virtual network support: the pre-flight checklist for regions, subnets and delegation
Power Platform virtual network support lets plug-ins and connectors reach private Azure resources through a subnet you delegate. Check these before you switch it on: Managed Environments, the paired Azure regions, subnet size, which connectors are supported, DNS, and what happens to calls to the public internet.