Microsoft Power Platform · Low-Code Revolution

Build apps that transform your industry.

From hospital floors to legal chambers to warehouse shelves — Power Apps + Power Fx delivers enterprise-grade solutions without enterprise-grade complexity.

🏥

Healthcare

Patient management, triage tracking, appointment scheduling and clinical analytics.

→

⚖️

Legal

Case management, contract tracking, billing automation and hearing calendars.

→

📦

Inventory

Stock levels, reorder automation, purchase orders and warehouse forecasting.

→

97%

Faster Dev

5M+

Apps Built

500+

Connectors

$0

Code Required

Patient Records

Northside General Hospital · Cardiology & Oncology Units

Filter(Patients, Department = varSelectedDept && Status = "Active" && DateDiff(LastVisit, Today(), Days) < 30 )

Active Patients

1,284

↑ 12% this month

Avg Wait Time

8 min

↓ 23% vs last week

Critical Alerts

3

Requires attention

Beds Available

47

of 210 total

Recent Patients

Active Critical Medium Risk

Patient	Department	Status	Last Visit	Risk
MR Maria Rodriguez	Cardiology	Active	Mar 05, 2026	Medium
JK James Kim	Oncology	Critical	Mar 08, 2026	High
SP Sarah Patel	Pediatrics	Active	Feb 28, 2026	Low
DL David Lee	Neurology	Observation	Mar 07, 2026	Medium

New Patient Registration

INTAKE

First Name

Last Name

Department

Priority

Chief Complaint

// Save new patient record Patch(Patients, Defaults(Patients), { Name: txtFirst.Text & " " & txtLast.Text, Dept: drpDept.Selected.Value, AdmitDate: Now(), TriagedBy: User().FullName } )

// Toggle critical-only filter Set(varCriticalOnly, !varCriticalOnly); UpdateContext({locAlertBanner: true})

💡 Power Fx tip: Use Set() for global app state and UpdateContext() for screen-local variables like modal toggles.

Case Dashboard

Morrison & Hayes LLP · Active Matter Management

// Update case status with variable + patch Set(varCaseStatus, "Under Review"); Patch(CaseRecords, LookUp(CaseRecords, CaseID = varSelectedCase), { Status: varCaseStatus, LastUpdated: Now(), AssignedTo: User().FullName } )

Active Cases

42

Across 6 practice areas

Billable Hours

318h

This month

Deadlines

7

Within 14 days

Win Rate

78%

YTD closed cases

Matter List

Under Review⚠️ 2 Expiring

Case	Type	Attorney	Status	Deadline
Apex Corp v. Vertex LLC	Corporate	AH A. Hayes	Under Review	Mar 15 ⚠️
Estate of J. Williams	Probate	LM L. Morrison	Discovery	Apr 02
Chen Patent Filing	IP / Patent	RP R. Park	Filed	May 20
Rivera Employment Dispute	Litigation	ST S. Torres	Trial Prep	Mar 22 ⚠️

New Case Intake

LEGAL

Client Name

Matter Type

Lead Attorney

Filing Deadline

Case Description

// Deadlines within 14 days Filter(CaseRecords, AssignedTo = varCurrentAtty && Status <> "Closed" && DateDiff(Today(), Deadline, Days) < 14 )

// Resolve attorney name from BarID LookUp(Attorneys, BarID = varCaseAtty ).FullName & " · " & Text(Now(), "mmm dd")

💡 Deadline automation: Use DateDiff(Today(), Deadline, Days) to auto-highlight cases within 14 days — no triggers needed.

Inventory Overview

Atlanta Distribution Center · WH-ATL-04

⚠️ 4 Low Stock

// Build reorder collection for low-stock items ClearCollect(colReorderList, Filter(Inventory, Quantity < ReorderThreshold && If(varShowCriticalOnly, Priority = "Critical", true ) ) )

Total SKUs

2,847

Across 3 warehouses

Turnover Rate

4.2x

↑ vs 3.1x target

Low Stock

4

Action required

Open POs

12

Pending receipt

Stock Levels

4 Critical

SKU	Item	Qty	Min	Status
SKU-4821	N95 Respirator Masks	12	100	Critical
SKU-2290	Latex Gloves — Med	48	200	Low
SKU-9043	Hand Sanitizer 1L	340	250	In Stock
SKU-1155	Surgical Masks Bx/50	22	150	Critical

Quick Reorder

INVENTORY

SKU

Quantity

Supplier

N95 Masks12%

Latex Gloves24%

Hand Sanitizer100%+

Collect(colPOLines, { SKU: txtSKU.Text, Qty: Value(txtQty.Text), Supplier: drpSupplier.Selected.Value, RequestedBy: User().Email } ); Notify("Added to PO queue", NotificationType.Success)

// Power Fx Formula Language

Five formulas.
Infinite possibilities.

Power Fx is the open-source low-code language powering every app — familiar Excel-like syntax with enterprise capabilities.

🔍

Filter()

Dynamic data filtering

Filter(Patients, Ward = "ICU" && RiskScore > 80 )

Returns only ICU patients with high risk scores — rows update instantly as conditions change, no server roundtrip needed.

✏️

Patch()

Write records to data source

Patch(CaseFiles, ThisItem, { Status: "Closed", ClosedBy: User().Email, ClosedDate: Today() } )

Updates or creates a record in SharePoint, Dataverse, or SQL — with automatic user attribution and timestamps.

📋

Collect()

Build in-memory collections

Collect(colCart, { SKU: varScannedSKU, Qty: numQty, Location: "Aisle-B4" } )

Accumulates items in a local collection — perfect for building pick lists or batch operations before a final submit.

⚡

Set() / UpdateContext()

Global & local variables

// Global variable Set(gblUserRole, "Physician") // Screen-scoped variable UpdateContext( {locShowModal: true} )

Set() for app-wide state, UpdateContext() for screen-local — driving conditional UI and role-based access.

🔗

LookUp() + &

Relational queries & strings

LookUp(Attorneys, BarID = varCaseAtty ).FullName & " · " & Text(Now(),"mmm dd")

Resolve related records by ID and compose dynamic labels — all in one expression without additional API calls.

🚀

Notify() + Navigate()

UX & flow control

If(IsBlank(varSKU), Notify("Scan barcode first", NotificationType.Warning), Navigate(ConfirmScreen, ScreenTransition.Fade) )

Guard logic + screen navigation — built-in toast notifications and smooth transitions with zero JavaScript.