simple sharepoint column formatting for multi-select fields

snippet
power platform & sharepoint

added 15th Mar 2025

Use this SharePoint column formatting JSON to display multi-select fields as a vertical list rather than the default comma-separated.

Before

1

After

2

Column Format JSON

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "style": {
        "flex-wrap": "wrap",
        "display": "flex",
        "flex-direction": "column",
        "align-items": "start",
        "padding-bottom": "11px",
        "padding-left": "8px",
        "padding-right": "8px",
        "padding-top": "12px"
    },
    "children": [
        {
            "forEach": "__INTERNAL__ in @currentField",
            "elmType": "div",
            "style": {
                "padding-bottom": "2px"
            },
            "txtContent": "[$__INTERNAL__]"
        }
    ]
}

retrieve sharepoint search results with pagination in power bi

14th Mar 2025