Split comma delimited (array) string variable to list separated by newline

(0) Share

Report

Posted on by madshaun1984

I have a flow that's collecting a list into a string variable, output similar to,

["one","two","three"]

But I need to convert this to a list separated by a newline, ie,

One

Two

Three

I'm currently using a split(variables('string'), ',') compose action, but the input / outputs are identical,

["one","two","three"]

I had planned to then strip additional quotes / square brackets in following actions.

Is what I'm trying to achieve possible, if so are there any examples of how?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report
Your string is actually an array. So you could do something like this:

The expression used is:
join(variables('array'), decodeUriComponent('%0A'))

Was this reply helpful? Yes No
madshaun1984 4 on at

Like (0)

Report

Thanks!

I'm testing this now (the flow takes ~7h to complete currently... due to huge slowness of an apply to each loop (1538 entries iterated to build out the comma separated list)).

Was this reply helpful? Yes No
madshaun1984 4 on at

Like (0)

Report

Update: Running test using partial results from my flow, reveals this is not working.

Using your example, if you initialize "array" as a string variable (I'm appending each item of the list to the string var in a prior apply to each), then use a compose step "split(variables('array'), ',')" before finally joining the split composes output, the result is not as expected (the split doesn't seem to actually output an array).

Thanks

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

It's already in the format of an array. You don't need to split or do any of that stuff. Just create an array variable (as an array variable) and put in your string, which is constructed as an array as the input.

Make it even easier on yourself and instead of appending to a string variable in your prior steps, simply append the value to an array variable.
You've made it much more complicated than it needs to be.

Was this reply helpful? Yes No
Jake_PA_BS 4 on at

Like (0)

Report
Hello,

I used
join(variables('array'), decodeUriComponent('%0A'))
for my array to make it appear on new lines, but it does not when Outputs is clicked in the emai.

The email still comes through as the same line, the text in value 1 comma text in value 2

Was this reply helpful? Yes No
tjlyons65 14 on at

Like (0)

Report

A year later, I have the same issue - output of the join expression above still outputs the data on one line with commas.

Was this reply helpful? Yes No