cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Holywill
Frequent Visitor

Unable to process template language expressions in action 'Compose'

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.'.

 

 

 CSVtoArray.png

 

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

Capture.JPG

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

Capture.JPG

View solution in original post

13 REPLIES 13
abm
Super User
Super User

Hi @Holywill 

 

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

 

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

 

Flow Result:

 

image.png 

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

 

image.png 

 

I am not seeing any failures.

 

Try the following:

 

Open the text file in notepad.

Then save as UTF-8 format and try

 

image.png

 

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

 

Let me know the results.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Jcook
MVP

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Holywill
Frequent Visitor

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.

Capture.JPG

 

 

Here's a link to a text file example

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Holywill
Frequent Visitor

Hi @Jcook 

 

I tried before and it fails at initiating variable step

Capture.JPG

 

Capture.JPG

Hi @Holywill 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Holywill
Frequent Visitor

hi @abm 

 

Yes I tried every format but still not going

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Holywill
Frequent Visitor

Hi @abm 

 

I provided a link for the file

 

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

 

here you go

 

cheers mate

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

 

Capture.JPG

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

Hi @MM_dus3r ,

 

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

 

2020-11-04 01_52_05-Edit your flow _ Power Automate.png

kky1
Helper I
Helper I

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!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,874)