Unable to process template language expressions in action 'Compose'

[Holywill]

I have a flow to extract data from a txt file and add rows to Excel file. however, the flow was working just fine until last week. it started showing the error below.

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2819': 'The template language function 'encodeUriComponent' was invoked with invalid parameters. The parameter at index '0' cannot be converted to URI component.'.

 

I tried to use a different expression

split(decodeUriComponent(replace(encodeUriComponent(variables('CSV')),'%0D','*')),'*')

split(uriComponentToString(replace(uriComponent(variables('CSV')),'%0A','*')),'*')

They both result in the bellow

data example:

2020-03-03,12:35:01.394,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,53,48,0,0,-10141,570,-9451,-434,-9951,-261,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,35,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:36:01.706,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,48,48,35,54,47,0,0,-10141,650,-9451,-436,-9951,-218,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,36,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:37:01.069,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,55,50,0,0,-10141,547,-9451,-436,-9951,-201,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,37,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:38:01.103,<40001>,50,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,48,48,35,53,47,0,0,-10141,487,-9451,-441,-9951,-168,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,38,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:39:01.415,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,54,47,0,0,-10141,671,-9451,-447,-9951,-192,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,39,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:40:01.672,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,54,46,0,0,-10141,632,-9451,-361,-9951,-212,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,40,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:41:01.155,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,54,47,0,0,-10141,601,-9451,-406,-9951,-207,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,41,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:42:01.473,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,54,46,0,0,-10141,600,-9451,-406,-9951,-161,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,42,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:43:01.484,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,48,49,48,35,53,49,0,0,-10141,578,-9451,-443,-9951,-198,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,43,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:44:01.736,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,55,49,0,0,-10141,603,-9451,-433,-9951,-220,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,44,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:45:01.226,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,54,47,0,0,-10141,586,-9451,-436,-9951,-187,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,45,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:46:01.531,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,49,35,54,48,0,0,-10141,601,-9451,-468,-9951,-191,0,0,0,63,0,0,0,0,0,0,0,0,0,0,2,46,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:47:01.782,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,49,48,35,53,48,0,0,-10141,555,-9451,-411,-9951,-257,0,0,0,63,0,0,0,0,0,0,0,0,0,0,3,47,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30
2020-03-03,12:48:02.137,<40001>,51,15,1,15,15,14,15,14,14,0,0,0,0,0,0,0,49,48,48,35,54,46,0,0,-10141,631,-9451,-472,-9951,-219,0,0,0,63,0,0,0,0,0,0,0,0,0,0,3,48,12,3,3,20,172,16,210,0,0,0,10,100,10,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,105,30

any help as much appreciated

Thanks

[abm]

Hi @Holywill 

I did tried your test data and here are my test results:

split(uriComponentToString(replace(uriComponent(variables('CSV')),'%0A','*')),'*')

Flow Result:

 

split(decodeUriComponent(replace(encodeUriComponent(variables('CSV')),'%0D','*')),'*')

 

I am not seeing any failures.

Try the following:

Open the text file in notepad.

Then save as UTF-8 format and try

It could be the file which is saved in other encoding format and adding some invalid characters.

Let me know the results.

Thanks

[Jcook]

Hi @Holywill

I had something similar happen a couple months ago randomly.

Please try what @abm has suggested. Also try removing the expression in flow and re adding.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Holywill]

Hi @Jcook and @abm 

I tried what you mentioned, it works when I enter the text into the value field of the variable, but when it's a file no matter what is the encoding, it doesn't really work.

Here's a link to a text file example

[Jcook]

Hi @Holywill

Can you try with the variable set to type Array instead of String.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Holywill]

Hi @Jcook 

I tried before and it fails at initiating variable step

[abm]

Hi @Holywill 

Did you tried saving the file in UTF-8 format?

[Holywill]

hi @abm 

Yes I tried every format but still not going

[abm]

Hi @Holywill 

Do you have a copy of the old working file? Compare the file vs latest file using windiff or some utility tools for compare and find any special characters being added in new file or not. Where you getting the new file from? Check whether that file creation process is changed or not?

Thanks

[Holywill]

Hi @abm 

I provided a link for the file

https://www.dropbox.com/sh/ydykz4djksufxos/AAC4JYoYmFALYOy9bLqZoDW4a?dl=0

here you go

cheers mate

[Holywill · Accepted solution]

Sorted !!!

I dropped the idea if URI and created a variable with "Enter" while Microsoft didn't do anything about it I had to improvise!

Now with two variables, I don't have to convert to URI and deal with all that, a variable for file content and another for 'Enter'

replaced all the previous nonsense with this 

split(variables('CSV'),variables('Enter'))

then in a loop split items

[Anonymous]

Can you share how you created the inputs for second variable (enter)? thanks 

[Alan_Sanchez]

Hi @Anonymous ,

I was able to reproduce Holywill's result using the 2 variable approach. Here is what I did to get it to work...

[kky1]

I was getting the same error after converting Html to Text to get URLs out of automated emails and Alan_Sanchez's solution above worked for me. Thank you Alan_Sanchez!