Below you will find pages that utilize the taxonomy term “JSON”
posts
SharePoint Column Formatting: Show a Create Button or Open Folder Link
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:
posts
SharePoint View Formatting: Clean Folder Tiles with Native Links
Overview This SharePoint view formatting template turns a list or library into clean folder tiles with a native link. It is designed for a simplified tile experience where the entire card is clickable and the raw URL is hidden.
Why use this layout? Entire tile is clickable, not just the text Uses a native anchor so the browser shows the target URL on hover Removes SharePoint’s default click overlay and selection UI Centers the folder icon and title with consistent spacing Keeps the tile clean when folder names vary in length What the formatting does hideSelection: true disables SharePoint selection visuals fillHorizontally: true makes the tile span the available width href maps to [$URL_Folder] and opens in a new tab title shows the URL tooltip on hover FolderName renders with a fallback – when empty How it behaves 🖱 Click anywhere on the tile
posts
SharePoint: Hide or Show Form Columns Using Content Types and JSON
Overview When you need to conditionally hide or show fields in a SharePoint list or library form, there are two common approaches: enable content types or use JSON form customization. This post explains both and shows the visibility expression used in SharePoint.
Option 1: Enable content types Enabling content types on a list or library gives you built-in controls for:
showing or hiding fields reordering columns managing form layout per content type This is a good fit when your list or library uses multiple content types and you want form behavior to vary by type.
posts
List formatting conditionally display different actions to call a power automate flow
Introduction In SharePoint, you can enhance user interactions by conditionally triggering different Power Automate flows based on specific conditions in a list or library. This is achieved using JSON column formatting and the executeFlow action. By dynamically linking flows to specific conditions, you can streamline processes and improve automation.
List formatting provides a powerful feature to control the flow of a process from filling mandatory fields, create approval tasks. Depending on the status of the list item, different power automate flows can be called.
posts
JSON Data Handling in Power Automate: Double Quotes
When using Power Automate action Send an Http request to SharePoint specially to send data in the body to a REST API call, for instance to create a news link from a SharePoint List Item, you might encounter issues if the body contains double quotes in the title or description. This blog post will walk you through the problem and provide solutions to handle double quotes in JSON strings.
Problem Overview Using the Send an Http request to SharePoint action to create a news link can fail if the JSON body contains double quotes.
posts
JSON Data Handling in Power Automate: outputs versus body
JSON Data Handling in Power Automate : outputs versus body In Power Automate, JSON data output from various actions is key to connect each other.
Accessing Action Outputs Accessing the outputs of a specific action, such as the action ‘Get file properties’, the spcific property can be accessed via the outputs, for instance file name with extension.:
outputs(‘Get_file_properties’)?[‘body/{FilenameWithExtension}’]
Referencing Action Body A streamlined way is to reference the body directly making it simpler.
posts
Enhance List Formatting for Multi-Line Text fields challenges
Enhance List Formatting for Multi-Line Text fields challenges Summary The following sample shows how you can view more of a truncated multi line text column on click. Column formatting in SharePoint is a powerful tool to customize how data is displayed. Multi-line text fields, however, present unique challenges when applying these formats. This guide explores a method to expand truncated multi-line text on click and discusses its limitations.
Understanding the Concept The objective is to provide users with a preview of truncated text and enable expansion on hover.
posts
Executing a Flow from Column Formatting from a page using the Embed Webpart
Executing a Flow from Column Formatting from a page using the Embed Webpart I encountered an intriguing challenge: triggering a flow from column formatting within a List View Webpart. Initially, I successfully created a button within a list to execute a flow on a specific item, following the steps outlined in Microsoft’s documentation here. It worked seamlessly within the list interface directly.
However, when attempting to add the list with the formatting column using the list view webpart on a page to allow end-users to trigger the flow the results were different.