Formatting Multiline Text from SharePoint Lists for Email in Power Automate
When referencing dynamic content in Power Automate, multiline text may not display correctly, leading to formatting issues in the output.
The following expression updates multiline text to break lines when referencing dynamic content (replace triggerOutputs()?['body/SharepointListColumnName'] with your dynamic content):
replace(triggerOutputs()?['body/SharepointListColumnName'], decodeUriComponent('%0A'), ' ')}
This expression replaces newline characters with HTML line breaks (<br>
), ensuring proper formatting in your output. %0A
is the URL-encoded representation of line breaks used in SharePoint list data, and here we replace it with <br>
for HTML formatting in emails. Cheers!