How to create a space between text rows in flow email

(0) Share

Report

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:

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

Condition: Has Column Changed: Work Log Details

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?

Thank you

All responses (13)

Answers (1)

Alison1 119 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

Thank you @Expiscornovus, perfect 🙂
AbdulWahab 517 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

Hi @Expiscornovus ,

Got it.

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/
Expiscornovus 31,643 Most Valuable Professional on at

Like (0)

Report

Re: How to create a space between text rows in flow email

Hi @AbdulWahab,

Like mentioned in my previous reply, when splitting on 0A the details of the user and the actual comment text itself would be in separate items of the array.

When you use the first you would only get the first item which would be the text

Edit Comment [Date: October 27, 2022 3:57 PM; User: ######] without the comment text Testing which is located in the 2nd item.

That's why I was suggesting to use a take and collect the first two items instead of a first one 😉
AbdulWahab 517 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

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/
Verified answer

Expiscornovus 31,643 Most Valuable Professional on at

Like (1)

Report
Re: How to create a space between text rows in flow email

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>')
Alison1 119 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

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
Expiscornovus 31,643 Most Valuable Professional on at

Like (1)

Report
Re: How to create a space between text rows in flow email

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>')
RobElliott 10,118 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

@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.
AbdulWahab 517 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

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/
Alison1 119 on at

Like (0)

Report

Re: How to create a space between text rows in flow email

Hi @AbdulWahab

Yes that would work.

Thanks
Alison