Split Dynamic Content to string with carriage returns

Like (0) Share

Report

Posted on 3 Jun 2021 10:31:56 by EpicTriffid

364

Hi all,

I have data in a sharepoint field that looks like this:

test1; test2; test3

I want to split that out for an email so it appears as

test1

test2

test3

I've tried using string and split, but it drops it into an array so that it appears like: ["test1", "test2", "test3"] and I can't seem to make it appear without the array characters and on different lines. Can anyone help?

I have the same question (0)

All responses (2)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on 03 Jun 2021 at 12:26:02

Like (0)

Report

Re: Split Dynamic Content to string with carriage returns

replace(outputs('Compose'),';',json('{"NL":"\n"}')?['NL'])

Was this reply helpful? Yes No
abm abm 32,506 Most Valuable Professional on 03 Jun 2021 at 12:03:15

Like (0)

Report

Re: Split Dynamic Content to string with carriage returns

Hi @EpicTriffid

Try the below

Above the first compose step press an enter key then use the replace() expression

replace(outputs('Compose'),';',outputs('Compose_3'))

Finally take the output to your email.

Thanks

Was this reply helpful? Yes No