skills.rest
RorySullivan1
RorySullivan1COMMUNITY
Explore all skills by this author →
GitHub

sharepoint-column-formatting

Generates declarative JSON formatters that style SharePoint list columns and views.

Updated Jul 25, 2026
Search Tags:#json#sharepoint#power automate#conditional formatting#list formatting#view formatting#column formatting
One-click install
npx skills add https://github.com/RorySullivan1/powerapp_taskmaster --skill sharepoint-column-formatting-rorysullivan1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sharepoint-column-formatting
Source: https://github.com/RorySullivan1/powerapp_taskmaster/tree/main/.claude/skills/sharepoint-column-formatting
Command: npx skills add https://github.com/RorySullivan1/powerapp_taskmaster --skill sharepoint-column-formatting-rorysullivan1

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? SharePoint lists render as plain grids by default, making status, priority, and overdue items hard to spot. This Skill writes the declarative column-formatting and view-formatting JSON that color-codes cells, renders data bars, adds icons, buttons, and custom row cards — without any code deployment. ## Core Features & Use Cases - Column formatting JSON: Produces copy-paste formatters for status pills, conditional background colors, data bars, icon-by-value indicators, clickable hyperlinks/mailto links, and action buttons (including buttons that launch a Power Automate Flow via executeFlow). - View formatting JSON: Builds rowFormatter, additionalRowClass, and Gallery/Board formatter trees for whole-row tinting and custom card layouts. - Expression guidance: Handles both Excel-style expressions and the Abstract-Object (AST) syntax for SharePoint 2019, plus the internal-name gotcha ([$Due_x0020_Date] vs display names) that causes most blank-output bugs. - Use Case: A user wants overdue tasks to turn red and blocked items to show a warning pill. The Skill emits a column formatter mapping Status values to sp-field-severity classes plus an additionalRowClass view formatter comparing [$DueDate] to @now. ## Quick Start Ask the assistant to write SharePoint column formatting JSON that turns a Status choice column into a colored pill with an icon for each value.

Frequently Asked Questions about sharepoint-column-formatting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I color-code a SharePoint list column with JSON formatting?▼

Use column formatting JSON with an elmType of div and a style or class driven by an expression like =if(@currentField == 'Done', 'sp-field-severity--good', ...). Paste it into the column's Format this column pane, starting with the $schema line for validation.

What is the difference between SharePoint column formatting and view formatting?▼

Column formatting styles a single field's cell and uses @currentField; view formatting styles the whole row or card via rowFormatter, additionalRowClass, or formatter. They use different $schema URLs, and additionalRowClass composes with column formatting while rowFormatter overrides it.

Why does my SharePoint column formatter show blank output?▼

Blank output almost always means a wrong internal field name or a field missing from the current view. References use internal names like [$Due_x0020_Date], not display names, and spaces are encoded as _x0020_. Check the Field= value in the column settings URL.

Can SharePoint column formatting launch a Power Automate Flow?▼

Yes, a button element with customRowAction set to executeFlow launches a Flow by ID. The actionParams value must be an escaped JSON string containing the flow id, not a nested object, or the action fails silently.

Does column formatting work on SharePoint 2019 on-premises?▼

SharePoint 2019 supports column formatting but not Excel-style expressions; you must use the Abstract-Object (AST) operator/operands syntax and the v1 column-formatting schema. Excel-style expressions require SharePoint Online or SE 22H2+.

What are the limitations of SharePoint JSON column formatting?▼

The formatter is sandboxed: only whitelisted elmType values and attributes are allowed, with no script, input, or arbitrary HTML. It cannot mutate data except via setValue/executeFlow actions, and external images are blocked unless the domain is allow-listed.

Related Skills

Explore More Software Engineering Skills→
microsoftmicrosoft
483

add-sharepoint

Integrate SharePoint Online lists into Power Apps using Graph API and pac code CLI.

Official
Advanced
tottenjordantottenjordan
1

bigquery-graph

Generates GQL queries and property graph DDL for BigQuery graph analytics.

Community
Advanced
microsoftmicrosoft
808

configure-canvas-mcp

Connects the Canvas Authoring MCP server to a Power Apps coauthoring session.

Official
Intermediate
Fuuz-PlatformFuuz-Platform

fuuz-html-dashboards

Build custom HTML dashboards for Fuuz screens with embedded visualization libraries.

Official
Advanced