Answered

Get comma seperated values one below the other when using in Send an email

(0) Share

Report

Posted on by SunnyRKFOODLAND

101

I have a SharePoint list where we have data of MS Form responses stored. One column has data with multiple comma-separated values. I want to use these values in mail-in Power Automate but all these values are coming in line I want these values to be one below the other so that when I use this in the table then in the single cell they can be seen like one below the other.

This is how I see the Table

Total Maintenance Cost	$$$$
Mechanical Repair Work	Engine oil changes., Engine overhaul.

This is how I want it to look

Total Maintenance Cost

43000

Mechanical Repair Work

Engine oil changes.

Engine overhaul.

I have the same question (0)

All responses (2)

Answers (1)

v-jefferni on at

Like (0)

Report
Re: Get comma seperated values one below the other when using in Send an email

Hi @SunnyRKFOODLAND ,

You can use replace function and replace comas with a change line symbol using decodeUriComponent('%0A')

replace(outputs('Compose'),',',decodeUriComponent('%0A'))

Best regards,

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,059 Moderator on at

Like (1)

Report
Re: Get comma seperated values one below the other when using in Send an email

In your Create HTML table I'd use the following expression to split the values by comma, then join with a <br> tag so they appear on a new line in your email.

//Replace Field_Name with the name of your field join(split(item()?['Field_Name'], ','), '<br>')

Was this reply helpful? Yes No