web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Power Automate: Combin...

Power Automate

Answered

Power Automate: Combine columns whereby Column type = Multiple lines of text in SharePoint

(0) Share

Report

Report

Posted on by JS-JS

32

Hi, would like to know is it possible to grab the record line by line where by the Column type = Multiple lines of text in SharePoint.

Below is the expected result:

How the flow need to be created in Power Automate?

Categories:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JS-JS ,

I've made a test for your reference:

1)

add(items('Apply_to_each'),1)

2)

length(split(outputs('Get_item')?['body/column1'],decodeUriComponent('%0A')))

3)

concat( items('Apply_to_each'), ') ', split(outputs('Get_item')?['body/column1'],decodeUriComponent('%0A'))[items('Apply_to_each')], '-', split(outputs('Get_item')?['body/column2'],decodeUriComponent('%0A'))[items('Apply_to_each')], '-', split(outputs('Get_item')?['body/column3'],decodeUriComponent('%0A'))[items('Apply_to_each')], decodeUriComponent('%0A') )

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thanks for your prompt reply.

Would like to ask, if I have 5 columns, is it I have to write like this
[0,1,2,3,4,5]

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JS-JS ,

Yes.

Best Regards,

Bof

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

Thanks for the answer.

Btw, Im hitting this error

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JS-JS ,

Please show me the entire flow and the expressions you used.

Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation