Hi @mkohler281
Firstly it depends on if the value that you see \r is a string, or a special character. I know it looks like a string but its probably not
You have a couple of options
1. If it is a true string and you can do a replace(myvalue,'\r','') and replace it with a nothing
-Note: But this only works if you do it to the value before it goes into the ParseJSON
If you have to do it after its in the ParseJSON you have a few options, myself I would do #3, especially if there is anychance others have \r
1. use SetProperty Function to change it, which would require essentially the same code as #3, but using a different method.
2. use a Select Action to essentially select out the columns of the Parese JSON.
For each Key / Value you select out, you can do the code from #3 on the Value to remove the \r if there is one.
3) you could use a Compose and use the Compose to do the following
This however takes the body of the Parse JSON, and either (if its a string) replaces all \r with '' and then turns it back into JSON. Or, it does the same thing but treats it like a special character and does the same thing and then turns it back into JSON
if its a string
json(replace(string(body('Parse_JSON')), '\r',''))
if its not a string \r but the special character you do
json(replace(string(body('Parse_JSON')), decodeUriComponent('%OD'),''))
For All of these, your flow can no longer reference the Parse JSON body Dynamic values, because its no longer valid. The Output of the Action you use (Compose or Select) is actually now the reference point for the data going forward. You could use a Second ParseJSON to return it back to having Dynamic values though.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
