Removing characters from an array variable

John Hazelwood · November 2023

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:

e34044f17de63c2918211d402341451e-huge-im

Alex Wong · November 2023

@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 · November 2023

@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?

ae26ad24551062e9de6641798a7e9565-huge-im

John Hazelwood · November 2023

2f1fe36083057411c4f08a122e7eda37-huge-im

Austen Brown · November 2023

@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 · November 2023

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

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

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

John Hazelwood · November 2023

Thank you, both!

Removing characters from an array variable

Comments

Categories