Is there a way to export or backup the column formatting JSON that has been applied to SharePoint list columns?
Obviously, column formatting is so useful that it is often applied to lots of lists, and in dynamic environments the values change often.
Apart from manually copying and pasting the JSON values for each column in each list into a JSON file, is there a way to export or backup column formatting JSON values?
You can get the JSON code applied to column formatting using PnP PowerShell like:
$field = Get-PnPField -List "JSONFormatting" -Identity "Status" -Includes Title,CustomFormatter
$field.CustomFormatter
Output:
You can also get the JSON using SharePoint REST API like:
<siteUrl>/_api/Web/Lists/getByTitle('JSONFormatting')/fields?$select=Title,CustomFormatter
Output:
For list views: Use below endpoint:
<siteUrl>/_api/Web/Lists/getByTitle('JSONFormatting')/views/getbytitle('All Items')?$select=Title,CustomFormatter
You can change the view name as per your requirements.
Connect-PnPOnline -Url "https://my-tenant.sharepoint.com", I got Connect-PnPOnline : ********: The user or administrator has not consented to use the application with ID '****-****-****-****-****' named 'PnP Management Shell'. Send an interactive authorization request for this user and resource.
Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Scope CurrentUser and it seemed to install but I cannot connect with anything like Connect-SPOService -Url https://contoso-admin.sharepoint.com -Credential [email protected]
/fields is for the columns in SharePoint list & not for list views. Check updated answer for list views endpoint
you can try this tool that allows you to export SharePoint lists to JSON, XML, Collections Power Apps and more.
Layoutview is a JSON object). So if I have a SharePoint list, and 5 columns have column formatting, there would be 5 JSON objects. (If I also modifiedGalleryview, there would be another JSON object). So any method that simplifies retrieving all JSON objects associated with a list (eg as an 'export' or 'backup') would be great. As long as it is clear which JSON is associated with which List, Column, View etc, I think any method is fine.