Overview This post shows how to build a SharePoint column formatter that switches between a folder creation button and an open-folder link based on whether URL_Folder already contains a value. If URL_Folder is empty, users see a Create Folder button. Once the folder exists, the formatter replaces the button with an Open Folder link. Why this helps Offers a clear action for new items Prevents the same action from appearing when the folder already exists Improves user experience with a single column-driven state Makes the row easier to scan by showing a transparent status-based UI How it works The formatter uses a parent div with two child elements:

Using column formatting in SharePoint, you can update the values of other fields using the setValue function. This approach allows you to create dynamic functionality in your lists and libraries without extensive development, helping to avoid accumulating technical debt. Updating a Managed Metadata field, however, is not as straightforward as simply specifying the display value. The field expects a specific format that includes the term’s ID (termId). Understanding Column Formatting Column formatting in SharePoint involves using a combination of inline CSS, HTML, and JSON to control how fields in lists and libraries are displayed.