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.
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', '')
Was this reply helpful?YesNo
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.
11
Share
Report
All responses (
Answers (
