web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Replacing /r/n using u...
Power Automate
Unanswered

Replacing /r/n using uricomponent causing an error

(0) ShareShare
ReportReport
Posted on by 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)
  • Verified answer
    Paulie78 Profile Picture
    8,422 Moderator on at

    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.

     

  • eliotcole Profile Picture
    4,363 Moderator on at
    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')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard