Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 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.

JSJS_0-1668406190944.png

Below is the expected result:

JSJS_1-1668406297388.png

How the flow need to be created in Power Automate?

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

    Hi @JS-JS ,

     

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

     

    Best Regards,
    Bof

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Power Automate: Combine columns whereby Column type = Multiple lines of text in SharePoint

    Hi @v-bofeng-msft 

     

    Thanks for the answer. 

     

    Btw, Im hitting this error

    JSJS_0-1668410602511.png

     

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

    Hi @JS-JS ,

     

    Yes.

     

    Best Regards,

    Bof

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Power Automate: Combine columns whereby Column type = Multiple lines of text in SharePoint

    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]

    JSJS_0-1668410031084.png

     

     

  • Verified answer
    Re: Power Automate: Combine columns whereby Column type = Multiple lines of text in SharePoint

    Hi @JS-JS ,

     

    I've made a test for your reference:

    vbofengmsft_1-1668408662618.png

    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:

    vbofengmsft_0-1668408609368.png

     

    Best Regards,

    Bof

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard