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

Announcements

Welcome to the Power Platform Communities
You're Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to create a space ...
Power Automate
Answered

How to create a space between text rows in flow email

(0) ShareShare
ReportReport
Posted on by Alison1 119

Hi all

 

In my sharepoint list I have a column called Work Log Details, the Work Log Details is updated from a Power App.  A user submits a comment in the PowerApp and it is added to the top of the Work Log Details in Sharepoint, it appears like this in Sharepoint with the most recent comment at the top.

 

Edit Comment [Date: October 27, 2022 3:57 PM; User: ######]
Testing

 

Edit Comment [Date: October 27, 2022 3:56 PM; User: ######]
Testing

 

Edit Comment [Date: 10/26/2022 4:53 PM; User: ######]
edit 50000

 

My flow is setup thike this:

 

Alison1_0-1666929126729.png

Get changes for an item Expression: add(int(triggerOutputs()?['body/{VersionNumber}']),-1)

Condition: Has Column Changed: Work Log Details

Alison1_1-1666929289630.png

 

The problem is, the Work Log Details appear like this in the email without spaces as per the Sharepoint list and PowerApp. Does anyone know how I can fix please please?

 

Alison1_2-1666929584343.png

 

Thank you

 

 

 

 

 

Categories:
Using flows
I have the same question (0)
  • AbdulWahab Profile Picture
    AbdulWahab 517 on at

    Hi @Alison1 ,

     

    Sorry, I am still confused about where the pace is required. Can you please elaborate on it more?

     

    If I have answered your question, please mark your post as Solved.

     

    If you like my response, please give it a Thumbs Up.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

  • Alison1 Profile Picture
    Alison1 119 on at

    Hi @AbdulWahab 

    Thank you for your reply.

     

    So the text appears as a singular paragraph in the email like this:

     

    Administrator Comment [Date: October 28, 2022 2:58 PM; User: ######] Testing Administrator Comment [Date: October 28, 2022 2:26 PM; User: ######] Testing Administrator Comment [Date: October 28, 2022 2:09 PM; User: ######] Testing 2:08 Administrator Comment [Date: October 28, 2022 2:07 PM; User: ######] Testing Requester Cancel Comment [Date: October 28, 2022 1:54 PM; User: ######] Testing Requester Edit Comment [Date: October 28, 2022 1:53 PM; User: ######] Testing

     

    Whereas in Sharepoint and the PowerApp it appears like this:

    Administrator Comment [Date: October 28, 2022 2:58 PM; User: ######]

    Testing

     

    Administrator Comment [Date: October 28, 2022 2:26 PM; User: ######]

    Testing

     

    Administrator Comment [Date: October 28, 2022 2:09 PM; User: ######]

    Testing 2:08

     

    Administrator Comment [Date: October 28, 2022 2:07 PM; User: ######]

    Testing

     

    Requester Cancel Comment [Date: October 28, 2022 1:54 PM; User: ######]

    Testing

     

    Requester Edit Comment [Date: October 28, 2022 1:53 PM; User: ######]

    Testing

     

    I would like the text in the email to appear the same as it is in Sharepoint.

     

    Thanks

     

  • AbdulWahab Profile Picture
    AbdulWahab 517 on at

    Hi @Alison1 ,

     

    The requirement is the new line. Am I right?

     

    If I have answered your question, please mark your post as Solved.

     

    If you like my response, please give it a Thumbs Up.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

  • Alison1 Profile Picture
    Alison1 119 on at

    Hi @AbdulWahab 

     

    Yes that would work.

     

    Thanks

    Alison

  • AbdulWahab Profile Picture
    AbdulWahab 517 on at

    Hi @Alison1 ,

     

    What about <br> tag. Did you try to add it?

     

    If I have answered your question, please mark your post as Solved.

     

    If you like my response, please give it a Thumbs Up.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

     

  • RobElliott Profile Picture
    RobElliott 10,460 Super User 2026 Season 1 on at

    @Alison1 click the code view button </> then add <br> tags. You can also add other tags like bold, underline, tables etc etc

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • Expiscornovus Profile Picture
    Expiscornovus 33,851 Most Valuable Professional on at

    Hi All,

     

    I think the challenge with this is that mark-up is not carried over from the field value and not in the body of the Send email itself.

     

    I would suggest to use an expression for this. Split the Work Log Details field value on the new line character (0A) and join it back together with a br HTML tag.

     

    Below is an example of that approach, can you try that?

    join(split(triggerOutputs()?['body/WorkLogDetails'], decodeUriComponent('%0A')), '<br>')

     

    join_brtag.png

     

     

  • Alison1 Profile Picture
    Alison1 119 on at

    Hi @Expiscornovus 

    That works perfectly thank you so much! Do you know if there is a way to just include the newly added comment?

    Thanks

    Alison

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 33,851 Most Valuable Professional on at

    Hi @Alison1,

     

    If you only want the newly added comment you will need the first two lines (the details of the user and the comment itself). You can use a take function for that.

     

    join(array(take(split(triggerOutputs()?['body/WorkLogDetails'], decodeUriComponent('%0A')), 2)), '<br>')

     

  • AbdulWahab Profile Picture
    AbdulWahab 517 on at

    Hi @Expiscornovus & @Alison1 

     

    What about the first function? For more details: Power Automate Fundamentals # 48: Usage of First &... - Power Platform Community (microsoft.com)

     

     

    If I have answered your question, please mark your post as Solved.

     

    If you like my response, please give it a Thumbs Up.

     

    Let me know if I can provide you with more details.

     

    Thanks
    Regards,

     

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

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

News and Announcements

Welcome to the Power Platform Communities
You're Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans