Append values from multiple choice column to string variable // troubleshooting

[gantonopoulos]

Hello community!

I have built a flow that sends an email containing the contents of a sharepoint column which is a multiple selection.

In order to get the individual values of the selections, the flow does:

-a compose of the cell dynamic value, which give out a table in table in json format 

-uses an apply to each to the outputs of the compose (which essentially runs for as many rows there are in the json formatted table)

-uses a compose to discern the value of the selection by means of the expression: item()?['COLUMNNAME'}?['Value']

-Append the outputs of the compose to a string variable with a <br> at the end so each item added is in a new row

-finally uses a compose outside of the apply to each to loop with input the string variable 

The problem is that even if the apply to each runs for the correct number of loops (depending on the number of the selections of the column), periodically the string variable (and corresponding output of the final compose action) contains more selections than the ones appended and some times with repeating items e.g. i may have selected 6 options out of 12, the apply to each runs 6 times each time appending a selection to the string variable, and my final compose gives out an output containing more than 20 selections (some duplicates).

Help would be appreciated as i do not understand the behaviour of this flow. Thank you!

[tom_riha · Accepted solution]

Hello @gantonopoulos ,

I'd try to do it in a more efficient way using the 'Select' action to build the array with the desired values, and then join(...) expression to convert the array into a string separated by the <br> string as described here.