web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiple line text fie...
Power Automate
Answered

Multiple line text field losing formatting in email notification

(0) ShareShare
ReportReport
Posted on by 24

Hello, 

 

I am building a flow but having issues with a multiple line text field. The flow is set up to send an email notification and include the information that is input into a SharePoint document library.  I am using the dynamic content to generate the text in the email however, when the email is actually sent the formatting (bullets and line spaces) from the multiple line text field is lost and everything just comes across as one paragraph. Is there a way for the power automate flow to keep the formatting that is input into SharePoint?

 

steve1955_1-1704240997082.png

 

Categories:
I have the same question (0)
  • eliotcole Profile Picture
    4,363 Moderator on at

    This is strange behaviour, @steve1955, but it might be because of how you are making the email body.

     

    I can't be sure, though ... so you may wish to edit your original question above (tap the dots to edit) and embed an image so that it is visible in the browser and not attached as a file.

     

    This will help folks get a bit more context as to how your flow works in order to assist you and will help others in need identify this as their problem. 👍

     

    ---

     

    You may just need to tap the 'Code view' button in the Outlook Send an email V2 action to insert the column data. It looks something like this:

    </>

    Then it will insert the HTML from the formatted column correctly.

     

    I can't remember if there are differences, though between the 'Rich text' multiple line column type and the 'Enhanced rich text (Rich text with pictures, tables, and hyperlinks)' multiple line column type.

     

    ---

     

    You can also use the Send an HTTP request to SharePoint to get the item and when you make the call to the list item make sure that you:

    • Use the Select query to include FieldValuesAsHtml
    • Use the Expand query to include FieldValuesAsHtml

    This will then allow you to select the HTML of the field in full if it is available.

     

    This will require a bit more knowledge, though to nail perfectly.

     

    ---

     

    Again, though, it all depends on what your actual setup is ... so we might know more if you edit your original question with imagery.

     

    I say to edit the original question specifically and not to reply with it because often folks won't even scroll down here without it.

  • Verified answer
    steve1955 Profile Picture
    24 on at

    Thank you @eliotcole . I was actually able to solve the issue using the post below: 

    Solved: Re: SharePoint Multiple lines of text column and S... - Power Platform Community (microsoft.com)

  • JH-20081250-0 Profile Picture
    2 on at
    The link above seems to be broken. I am having this same issue.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard