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.

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.

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.

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.