Standards

SharePoint List Design Standards

Standards for SharePoint lists used as Power Apps and Power Automate data sources.

SharePoint list designPower Apps SharePoint standardsSharePoint list governance

Who this helps

Teams using SharePoint as a lightweight app backend.

What to standardize

Choose column types intentionally.
Create support views before go-live.
Index high-use filter columns.
Document list ownership and retention.

Examples

Minimum list design notes

Capture design decisions that affect future maintenance.

Formula / code

List owner: Operations Applications
Primary app: Request Intake
Primary flows: Request approval, overdue reminder
Indexed columns: RequestStatus, AssignedTo, DueDate
Retention: Archive closed requests after 24 months

Expected result: The list has enough context for future support and migration decisions.

Common mistakes

Treating SharePoint like Excel
Skipping ownership
Using views as permission controls