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?
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]
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