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.

This post covers how to leverage SharePoint REST API to create and publish a news link from Power Automate using the Send an Http request to SharePoint action. Within a Power Automate flow follow the steps below to create and publish a news link details. Send an Http request to SharePoint action renamed to Get Page Details. Site Address : site url Method : GET Uri : /_api/web/lists/GetByTitle(‘Site%20Pages’)/items(10) Parse JSON renamed to Parse Page Details JSON Add the action Parse JSON and refer to the content from previous steps

This post covers how to leverage SharePoint REST API to get user details from Power Automate using the Send an Http request to SharePoint action. Within a Power Automate flow follow the steps below to retrieve a user details. Send an Http request to SharePoint action renamed to Get Page Author Details Site Address: https://test.sharepoint.com Method: GET URI: _api/Web/GetUserById(14) Here’s the output from the API: Here’s the output from the API: