Unanswered

Replace function adds a backslash to the values

(0) Share

Report

Posted on by cbernier12

248

Hi, I'm using Power Apps to paste a column of values from Excel into a text box then I send that text to a variable in Power Automate which returns this to the variable in Power Automate: "ABC\nDEF\nGHI"

I then remove the "\n" and replace with a comma in a compose action which gives me this: "ABC,DEF,GHI"

Formula used: replace(variables('ALPHABET'),decodeUriComponent('%0A'),',')

However I need to have quotes around each value so I add another compose action and use replace and it turns out like this:

"ABC\",\"DEF\",\"GHI" why does it add slashes??

Formula used: replace(outputs('Compose_ALPHABET'),',','","')

I need the values to look like this: "ABC","DEF","GHI"

Anyone have any guidance on how to solve this?

Categories:

General topics

All responses (3)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@cbernier12 ,

What is the result if you try to do all in a single operation ? Is there a specific need for 2 separate action ?

replace(variables('ALPHABET'),decodeUriComponent('%0A'),'","')

Can you show the results of the set variable (ALPHABET) action from an already run instance ?
cbernier12 248 on at

Like
a
(0)

Report
Copy link

Link copied!

Same results:
"ABC\",\"DEF\",\"GHI"

This is what the variable starts with, also had that in the first post too:
"value": "ABC\nDEF\nGHI"
cbernier12 248 on at

Like
a
(0)

Report
Copy link

Link copied!

I appears Power Apps messes with the character encoding when as CSV list is pasted into a textbox and sent over to Power Automate. Any have a solution for that? If I convert the list to a string in Power Automate it adda a bunch of "\" so the items. Super frustrating.