Unanswered

Power Automate SharePoint List split multi-line text column

(0) Share

Report

Posted on by guff416

I am working on a Flow that takes values from a SharePoint List multiple lines of text column type and puts into another SharePoint List single line of text column type. This part I have working. The part that is failing for me is I would like to split the multiple lines of text on a carriage return and I cannot figure out to do this. When I attempt to do the following split

split(outputs('Get_items')?['body/value'], '\n')

I get the following error:

"Unable to process template language expressions for action 'Apply_to_each' 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 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'.

I have inserted a screenshot of my flow. I am fairly new to Power Automate so I am probably missing something very obvious. Any help you can provide is very much appreciated.

I have the same question (0)

All responses (3)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Power Automate SharePoint List split multi-line text column

Hey @guff416
You are currently splitting entire thing or something.
Try using this:
split(outputs('Get_items')?['body/value/ColumnName'], '\n')
where ColumnName=MultiLineTextColum
or
split(outputs('Get_items')?['ColumnName'], '\n')

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Power Automate SharePoint List split multi-line text column

@guff416
And if the above does not work too, just go into settings of sharepoint list and make the column not required.

Was this reply helpful? Yes No
guff416 2 on at

Like (0)

Report

Re: Power Automate SharePoint List split multi-line text column

@Sundeep_Malik when I try using
split(outputs('Get_items')?['body/value/ColumnName'], '\n') or split(outputs('Get_items')?['ColumnName'], '\n')
I get the error: "The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')?['WorkspaceName_x0028_s_x0029_']' is of type 'String'. The result must be a valid array."

I made the column not required. It seems like there is an object type mismatch.

Was this reply helpful? Yes No