Convert Array to String using Power Automate [3 Methods]

In this Power Automate tutorial, we will see how to convert an array to a string using Power Automate.

Here we will see 3 different ways to convert an array to a string using Power Automate.

• Using Join()
• Using Join action
• Using Select action

Convert array to string in Power Automate using Join()

Here we will see how to convert an array to a string using Power Automate join().

For example, we have this array ‘[“dravid@tsinfo.com”,”grady@tsinfo.com”]’ and we will convert it into ‘dravid@tsinfo.com,grady@tsinfo.com’ using Join().

Join () in Power Automate is used to concatenate items of an array into a single string with the specified delimiter.

Now let’s implement using Power Automate flow for this, follow the below steps:

Step 1: Log in to Power Automate, then click on +Create -> select Instant cloud flow.

Then, provide the flow name and select Manually trigger a flow. Then click on the Create button.

Now you can see Manually trigger a flow action is added to the flow.

Step 2: Next, click the +New step -> select Initialize variable action. Then, provide the information below.

• Name: Provide the variable name
• Type: provide the type as an array
• Value: Provide the value like below:

[
"dravid@tsinfo.com",
"grady@tsinfo.com"
]

Step 3: Next, click the +New step -> select Compose action. Then provide the below information:

• Inputs: Provide the below expression

join (variables ('emails'), ',')

Step 4: Now we will send the output in the mail, so click on the +New step -> select Send an email (V2) action. Then, provide the below information.

• To: Provide the recipient with an email
• Subject: provide the subject of an email
• Body: Select the output of the previous action from dynamic content.

Step 5: Now run the flow manually; for this, save the flow, click on the Test icon ->select the Manually option -> click on the Test button. You can see your flow run successfully. Also, you can see the output in the Outlook email.

This is how to convert Array to String using Power Automate using join().

Convert array to string Power Automate using Join action

Here, we will see how to convert an array to a string using the Power Automate Join action.

For example, we have this array ‘[“dravid@tsinfo.com”, “grady@tsinfo.com”]’ and we will convert it into ‘dravid@tsinfo.com,grady@tsinfo.com’ using Join action.

Now let’s implement using Power Automate flow, for this, follow the below steps:

Step 1: Log in to Power Automate, then click on +Create -> select Instant cloud flow.

Then, provide the flow name and select Manually trigger a flow. Then click on the Create button.

Now you can see Manually trigger a flow action is added to the flow.

Step 2: Next, click the +New step -> select Initialize variable action. Then, provide the information below.

• Name: Provide the variable name
• Type: provide the type as an array
• Value: Provide the value like below:

[
"dravid@tsinfo.com",
"grady@tsinfo.com"
]

Step 3: Next, click the +New step -> select Join action. Then provide the below information:

• From: Provide the output from dynamic content.
• Join with: Provide the delimiter as ‘,’.

Step 4: Now we will send the output in the mail, so click on the +New step -> select Send an email (V2) action. Then, provide the below information.

• To: Provide the recipient with an email
• Subject: Provide the subject of an email
• Body: Select the output of the previous action from dynamic content.

Step 5: Now run the flow manually, for this, save the flow, click on the Test icon ->select the Manually option, -> click on the Test button. You can see your flow run successfully. Also, you can see the output in the Outlook email.

This is how to convert an array to a string using Power Automate using the Join action.

Convert array to string in Power Automate using Select action

Here, we will see how to convert an array to a string using Power Automate select action.

For example, we have this array ‘

[{“Name”: “Grady”,”Email”: “Grady@email.com”},{“Name”: “Petti”,”Email”: “Petti@email.com”}]’ and we will convert it into ‘Grady@email.com, Petti@email.com’ using select action.

Now let’s implement using Power Automate flow for this, follow the below steps:

Step 1: Log in to Power Automate, then click on +Create -> select Instant Cloud Flow.

Then, provide the flow name and select Manually trigger a flow. Then click on the Create button

You can see “Manually trigger” a flow action is added to the flow page.

Step 2: Next, click the +New step -> select Initialize variable action. Then, provide the information below.

• Name: Provide the variable name
• Type: provide the type as an array
• Value: Provide the value like below:

[
  {
    "Name": "Grady",
    "Email": "Grady@email.com"
  },
  {
    "Name": "Petti",
    "Email": "Petti@email.com"
  }
]

Step 3: Next, click the +New step -> select Select action. Then provide the below information:

• From: Select the Person details variable from the dynamic content.
• Map: Provide the below expression

item() ? ['Email']

Step 4: Next, click the +New step -> select Join the action. Then provide the below information:

• From: Provide the output from dynamic content.
• Join with: Provide the delimiter as ‘,’.

Step 5: Now we will send the output in the mail, so click on the +New step -> select Send an email (V2) action. Then, provide the information below.

• To: Provide the recipient email
• Subject: provide the subject of an email
• Body: Select the output of the previous action from dynamic content.

Step 5: Now run the flow manually; for this, save the flow, click on the Test icon ->select the Manually option -> click on the Test button. You can see your flow run successfully. Also, you can see the output in the Outlook email.

This is how to convert an array to a string using the Select action in Power Automate.

Conclusion

In this Power Automate tutorial, we saw three examples of converting arrays to strings using Power Automate.

You may also like:

• Convert XML to Array in Power Automate
• Convert XML to JSON using Power Automate
• How to loop through XML data and insert into Excel using Power Automate?