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!
decodeUriComponent('%0D%0A')
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.