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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,246)