Split Expression

Like (0) Share

Report

Posted on 24 Oct 2024 19:11:47 by Jonas_Cruzrj

Hi, I am developing a flow that obtains the content of a csv file in sharepoint to convert into excel xlsx. However, when dividing the file contents and a new line, this error appears:

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

Could You help me?

Categories:

Business Process Flows

csv format.JPG

split.jpg

All responses (2)

Answers (0)

takolota1 4,831 Super User 2025 Season 1 on 25 Oct 2024 at 16:30:16

Like (0)

Report

Split Expression

If you need to go from a CSV to a new Excel table, then this template may help, or at least show you some actions & expressions you may need

https://community.powerplatform.com/galleries/gallery-posts/?postid=d14f3b67-c4a9-4579-80f5-0e1dac0d80ee
Suggested answer

SudeepGhatakNZ 14,292 Most Valuable Professional on 24 Oct 2024 at 21:34:18

Like (0)

Report

Split Expression

Can you share the output of the SharePoint action? I can check.

The error you’re encountering occurs because the split() function in Power Automate expects a string as input, but you're passing an object (the CSV file content is likely being read as an object rather than a string).