Answered

Need help with compose to split csv file by lines

(0) Share

Report

Posted on by ahhollan

576

I have a flow where I am trying to parse a csv file. After I get the file content, I have a compose to split the content by lines. I keep getting the following error: InvalidTemplate. Unable to process template language expressions in action 'SplitByLines' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details.'.

My expression is:

split(outputs('Get_file_content')?['body'], decodeUriComponent('%0D%0A'))

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ahhollan ,

You need to convert the output of get file content before you can use the split function.

Could you please show me a screenshot of the contents of your csv file? Private information can be coded.

Also I think this link can help you:

Solved: Split method - parse csv - Power Platform Community (microsoft.com)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report
Copy link

Link copied!

Your post helped and I was able to convert to string. However, I'm getting the unwanted character below. What do i do?

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report
Copy link

Link copied!

With the help of a coworker, we figured it out. It's called a utf=8 bom and I added a compose to strip that out. The flow is running fine now. Your suggestion to convert the get file content was what I needed.

Was this reply helpful? Yes No