Collection Builder
Generate a complete, delegation-aware ClearCollect formula with calculated fields — ready to paste directly into your app.
You are a senior Power Apps developer. I need help building a collection in a Canvas App. Context: - Data source: [SharePoint / Dataverse / SQL] - Table name: [table name] - Columns: [list columns] - Goal: [what the collection should represent] Requirements: - Use ClearCollect - AddColumns if needed - Include calculated fields - Optimize for performance (avoid delegation issues if possible) - Use proper Power Fx syntax with semicolons Return: - Full working formula (ready to paste) - Brief explanation of each column
Complex Filter / Business Logic
Describe your logic in plain English — get back clean, null-safe, readable Power Fx. Stops you second-guessing If vs Switch.
You are an expert in Power Fx. Convert this business logic into a clean, optimized Power Fx formula. Business Logic: [Describe in plain English] Requirements: - Use If / Switch appropriately - Handle nulls and blanks - Use With() where helpful - Optimize readability - Avoid redundant LookUps Return: - Final formula - Explanation of logic mapping
Variables + State Management
Design your variable strategy before you build — Set vs UpdateContext vs Collections with consistent naming conventions.
You are a Power Apps expert. Help me design variables for this app: Scenario: [Describe app behavior] Requirements: - Use Set, UpdateContext, and collections appropriately - Explain when to use each - Keep naming consistent (var*, loc*, col*) Return: - Variable definitions - Example usage
Data Transformation
Convert, reshape, and type-cast data between structures. ClearCollect, AddColumns, GroupBy with correct Value() and DateValue() casting.
You are a Power Fx data transformation expert. Convert this: Input: [Describe structure OR paste sample] Into: [Desired output structure] Requirements: - Use ClearCollect, AddColumns, GroupBy, etc. - Ensure correct typing (Value, DateValue, etc.) Return: - Full formula
Approval Workflow Logic
Multi-step approvals with dynamic approver logic and escalation — outputs both the Canvas App Power Fx AND the Automate flow structure.
You are a Power Platform architect. Design approval logic based on this process: [Describe approval process in plain English] Requirements: - Support multi-step approvals - Dynamically determine next approver - Include escalation logic if needed - Output both: 1. Power Fx logic (Canvas App) 2. Power Automate flow structure Return: - Step-by-step architecture - Power Fx formulas - Flow design (trigger, actions, conditions)
Expression Generator
Stop Googling formatDateTime and substring. Describe what you need — get the exact expression with null handling baked in.
You are a Power Automate expert. Convert this requirement into a Power Automate expression: Requirement: [Describe logic] Constraints: - Use correct expression syntax - Handle null values safely - Optimize for readability Return: - Expression only - Short explanation
Flow Design (End-to-End)
Full flow architecture from trigger to logging — including error handling. Use this before you build anything complex.
You are a Power Automate architect. Design a flow for this process: [Describe process] Requirements: - Include trigger - Actions - Conditions - Error handling - Logging strategy Return: - Step-by-step flow - Key expressions
JSON Generator
Generate API payloads and Parse JSON schemas in one shot. Stops the back-and-forth of building schemas manually in the flow designer.
You are an expert in JSON for Power Platform integrations. Generate a JSON structure for: Scenario: [Describe API or payload] Requirements: - Include realistic sample values - Ensure proper formatting - Compatible with Power Automate Parse JSON Return: - JSON - Suggested schema (optional)
Adaptive Card Builder
Full Teams-ready Adaptive Card JSON — approvals, notifications, or data display. Schema 1.4+, correct containers and FactSets, actions included.
You are an expert in Microsoft Adaptive Cards. Build an adaptive card for this scenario: Scenario: [Approval / Notification / Data display] Fields: [List fields] Requirements: - Use Adaptive Card schema version 1.4+ - Include actions (Approve / Reject if needed) - Clean layout (Containers, FactSet, etc.) Return: - Full JSON (ready for Teams)
HTML Generator (Emails / PDFs)
Mobile-friendly, inline-CSS HTML for Power Automate email actions. Invoices, approval summaries, reports — no CSS framework needed.
You are a UI developer specializing in HTML for Power Automate emails. Generate HTML for: Scenario: [Invoice / Approval summary / Report] Requirements: - Clean styling (inline CSS) - Mobile-friendly - Table-based layout where needed Return: - HTML only
Screen Documentation from Code
Paste any Power Fx screen code and get full structured documentation. Risks, dependencies, data sources, business logic — all extracted automatically.
You are a Power Platform solution architect. I will paste Power Fx code from a screen. Your job: - Analyze the code - Document what the screen does Output format: 1. Screen Purpose 2. Data Sources Used 3. Key Collections 4. Business Logic 5. User Actions 6. Dependencies (Flows, APIs) 7. Risks / Improvements Code: [Paste code]
Debugging + Error Fixer
Paste the error or describe the wrong behavior. Get root cause analysis, corrected code, and an explanation — not just a guess.
You are a senior Power Platform developer. I am getting this issue: [Paste error or behavior] Context: [What you're trying to do] Requirements: - Identify root cause - Provide corrected code - Explain why it failed Return: - Fixed version - Explanation
Natural Language → Full App Logic
Describe a business process in plain English. Get the entire solution architecture back — data model, Canvas App logic, Automate flows, approvals, edge cases. Production-ready.
You are a Power Platform expert. Turn this business process into working app logic: Process: [Plain English description] Output: 1. Data model (tables + fields) 2. Canvas app logic (Power Fx) 3. Power Automate flows 4. Approval logic 5. Edge cases Make it production-ready.
This is the prompt that collapses a week of scoping into 10 minutes. Use it at the start of every new engagement.
This is not "just prompts."
It's a Power Platform Thinking System — the way senior developers approach problems before they touch the builder.
Starter Kit
"Get results immediately"
← You are here
12-Week Program
"Understand WHY it works"
The foundation that makes these prompts actually reliable
AI Module (Week 10)
"Multiply your output 10x"
AI Builder, Copilot Studio, Azure OpenAI — for when prompts aren't enough
Ready to build the foundation?
The 12-Week Power Platform Mastery Program covers everything these prompts assume you know — Canvas Apps, Dataverse, Power Automate, Azure integrations, ALM, and a full dedicated AI module.
One-time payment. Lifetime access. Direct access to Jerome in Slack.
🔒 30-day money-back guarantee