Custom FetchXML Aggregation in Power Pages — Build a KPI Dashboard Without Power BI
Published on:
Learn more
Related posts
Copilot Studio Agent Answering FAQs from a Power Pages Knowledge Base
A hands-on walkthrough for Power Platform makers – Copilot Studio + Power Pages Why I Built This Most Power Pages sites already have a h...
Using Azure OpenAI to Auto-Summarize Dataverse Case Notes – AI Integration + Dataverse CE
Why I Built This If you work in Dynamics 365 Customer Service or any Dataverse CE environment, you already know the pain: a single case can ac...
AI-Powered Smart Form in Power Pages Part 4: Dataverse Save, Testing & Production Checklist
Inject AI metadata into hidden fields before submission, add the new_originaltext and new_aiconfidence columns to your ent...
AI-Powered Smart Form in Power PagesPart 3: Portal HTML & JavaScript Smart Fill Engine
The complete Power Pages page layout — AI input panel HTML, dark widget CSS, and the full JavaScript engine that maps extracted fields to your...
Power Automate Flow — HTTP Trigger to Azure OpenAI
Build the secure Power Automate HTTP trigger flow that receives free text from the portal, calls Azure OpenAI using your smart-form-extract de...
AI-Powered Smart Form in Power Pages — Azure OpenAI + Dataverse – Part 1
User types free-text → JavaScript calls Azure OpenAI via Power Automate → AI extracts structured fields (name, date, category, priority) → aut...
Power Pages Table Permission Inheritance Patterns – Deep Dive
A code-level walkthrough of all 5 permission scope types – Global, Contact, Account, Parent, Self – with real FetchXML showing exa...
Build a Dynamic PDF Generator in Power Pages
Trigger Power Automate from portal JavaScript → flow queries Dataverse → generates PDF using HTML-to-PDF converter → returns base64 → portal t...
Create an AI-Generated Color Theme in Power Pages Using Copilot
Gone are the days of manually picking hex codes and tweaking CSS variables for hours. Microsoft’s Copilot in Power Pages now lets you de...
Use Environment Variables with Site Settings in Power Pages
Environment Variables + Site Settings is a best practice architecture pattern in Power Pages that allows you to manage configuration values (l...