SharePoint Modern List - How to Tell Which Columns have JSON Formatting

Question

Hau,

I am working in SharePoint Online Modern, and I have inherited a list with lots of columns and lots of JSON Column formatting (or so I am told).

My question is this, is there an easy way to tell which columns in a 50+ column list have JSON formatting?

Thanks!

Wachi

Answer 1

Hi @Crazy Dance,

When a column uses JSONformatting, its SchemaXml will contain an attribute called CustomFormatter.

Here you can use Power shell to determine whether the SchemaXml of the column contains the CustomFormatter attribute to determine whether the column uses JSON formatting

Here is a test for your reference:

Here is test list：

Here is test columns:

Here is aa column：

Here is test:

Here is code:

# Connect to SharePoint Online
Connect-PnPOnline -Url "yoursiteURL"


$list = Get-PnPList -Identity "testforjson"
$fields = Get-PnPProperty -ClientObject $list -Property Fields
foreach ($field in $fields) {
    if ($field.SchemaXml.Contains("CustomFormatter")) {
        Write-Host "Column Name: $($field.Title)"
        Write-Host "Column Internal Name: $($field.InternalName)"
        Write-Host "CustomFormatter: Yes"
        Write-Host "---------------------------"
    }
}



# Disconnect from SharePoint Online
Disconnect-PnPOnline

Here is result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best Regards

Cheng Feng