web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Replacing /r/n using u...

Power Automate

Answered

Replacing /r/n using uricomponent causing an error

(0) Share

Report

Report

Posted on by TomasZubov

122

Hi all,

I need to split csv that contains /r/n but I'm not able to do so

I found workaround converting csv to using uriComponent, but it fails with

The template language function 'uriComponent' was invoked with invalid parameters. The parameter at index '0' cannot be converted to URI component.'.

1) What I do is take attachment and convert it to string - OK output as expected

2) as it is semicolon separated I replace it with comma - not necessary, but it works fine and does everything as expected

3) just covert to uri - fails

Any idea why or other way how to split csv on /r/n?

Thank you!

2021-02-20 15_44_53-Clipboard.png

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

Check out the uriComponent expressions on this page I wrote. It has the code you need:

https://www.tachytelic.net/2021/02/power-automate-parse-csv-file-json/

Let me know if it works for you.

Was this reply helpful? Yes No
eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!
For anyone wishing to stay on this site, you can use the following to represent what json would show as '\r\n' in a string value:

decodeUriComponent('%0D%0A')

Was this reply helpful? Yes No

Join the conversation