web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Remove newline chars "...
Power Automate
Answered

Remove newline chars "\n" from JSON resulting from "Send an HTTP Request to SharePoint" action.

(0) ShareShare
ReportReport
Posted on by 11
I have a PowerApps-based flow that exports SharePoint list items containing an appended comments field in JSON when a button in a gallery is pressed. I used the ParseJSON function to receive the appended comments in a gallery on another screen. All is well, except that the comments in the JSON had "\n" (carriage returns) all over the place and I need to remove them. I tried using "Replace" in the flow after the "Send an HTTP Request to SharePoint" but an error says that it won't work on an object. It needs a string. Any assistance would be appreciated. Thank you.

Btw, I can also create my own "Append Comment" feature, but my customer wants to keep the SharePoint append comments column for now.
Categories:
I have the same question (0)
  • Verified answer
    DB-09092211-0 Profile Picture
    11 on at
    I was just able to use the "string" function against the JSON to convert it to a string and the "replace" function worked.
    replace(string(outputs('Send_an_HTTP_request_to_SharePoint")?['body'], '\n', '')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard