Removing characters from an array variable

John Hazelwood

Hi There,

I am wondering if anyone knows of a way to remove the [" and "] from entries in an array.

I have a flow that pulls in all the actions that are coming up in the week ahead and emails them in a table. Two of the columns I use are Action Assigned To and Assigned Solicitor (Relationship Manager). I am able to pull in the names, however, because they are string values, they output like: ["Name1","Name2"]. I'd like it to just be the name with out the [" and "].

Here is an example of the output:

Alex Wong

@John Hazelwood
you can use a join expression to join an array of string with a separator.

join(dynamic_content_of_array, '; ')

this will join the array of names (i.e. ["John Smith","Jerry Steinfeld"]) with a semi-colon and space characters into John Smith; Jerry Steinfeld

John Hazelwood

@Alex Wong
Thank you Alex!

I tried the join, but feel like I don't have the correct name for the Array, as it throws an error. Here is what I put, did I do it wrong?

John Hazelwood

Austen Brown

@John Hazelwood - When creating the expression…

• start with typing in "join()" into the expression window,
• put your cursor between the parenthesis,
• then click on the “Dynamic Content” tab,
• under the variables section click on the array you want to use,
• then click on the “Expression” tab,
• go to then end of your expression and add the additional detail for the separator symbol,
• then click “OK” to paste the expression in the action.

Alex Wong

@John Hazelwood
expression to access the variable is not correct. Use:

join(variables('RelationshipManager'), '; ')

join(variables('Action Assigned To'), '; ')

John Hazelwood

Thank you, both!