cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomasZubov
Resolver I
Resolver I

Replacing /r/n using uricomponent causing an error

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

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

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.

 

View solution in original post

1 REPLY 1
Paulie78
Super User
Super User

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.

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,243)