Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

(0) ShareShare
ReportReport
Posted on by 1,085

I have  "Start and Wait for an Approval" action in my flow where am mentioning my Multiple lines of text SharePoint column in details section. I have used below expression and it doesnt work. The output is \n is replaced with <br> tags everywhere.

 

replace(items('Apply_to_each')?['Procurement_x0020_Comments'],variables('EnterVariable'),'<br>')

 

Now when I used the same expression under Send an Email (V2) action it does work pretty well. How can I make it to work in Approval action.

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    @abm Even hardcoding doesnt helping it :-(. Do we have an alternative?

    RameshMukka_0-1602158016508.png

     

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    Hi @RameshMukka 

     

    Documentation says put brackets and space so replace with that and see whether that works or not? Initially hardcode a value directly in flow approval message and see if that works or not? Then think about the expression you need to use.

     

    Thanks

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    @abm I am only using multiple lines text field from SharePoint list column. Do you think replacing variables('Enter Variable') with (space) within replace function help here? Also does (space) has '' (single quotes) around it?

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    Hi @RameshMukka 

     

    I haven't tested this but try this

     

    This is line 1.(space)
    Now text will appear on the next line.

     

    Result: 

    This is line 1.
    Now text will appear on the next line.

     

    See the reference:

    https://docs.microsoft.com/en-us/business-applications-release-notes/april18/microsoft-flow/rich-text-approvals

    https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support

     

     

     

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    @abm I actually did it. Its working in send an email action but not in Approval action.

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    Hi @RameshMukka 

     

    Thanks for the screen shot. Please do the following:

     

    1. Under the enter key variable value press the Enter Key

    2. Replace the tag with enter key value.

     

    Thanks

  • rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    RameshMukka_0-1602074176965.png

     

    Here is the screenshot. I have used a variable called "Enter Variable" to store Enter key value and replacing it with <br> using the expression i mentioned. Just that it is not being converted to html in Approval action. Doesnt it understand HTML?

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: Line Break in Multiple line of Text SharePoint Column in "Start and Wait for an Approval" Action

    Hi @RameshMukka 

     

    So these line breaks are not appearing under approval action? Could you post a screenshot?

     

    Thanks

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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard