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.

DateTime Handling in Power Automate Manipulating dates and times in Power Automate is a requirement at times. This post covers a few useful scenerios. Add To Time For instance, adding a specific number of months to a date retrieved from an action using AddToTime function: addToTime(body(‘Wait_for_an_approval_2’)?[‘completionDate’], int(body(‘Get_file_properties’)?[‘ReviewFrequency’]?[‘Value’]), ‘Month’, ‘dd/MM/yyyy HH:mm’) Substract Time Specific number of months can be substracted from the date retrieved from an action string(subtractFromTime(items(‘Apply_to_each’)?[‘DueDate’],1,‘Month’,‘dd/MM/yyyy HH:mm’)) Format Date Time Formatting date to a specific string format is essential otherwise update of data fields might fail because of culture differences.

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.