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.

Convert an array to a string using Power Automate

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

Convert an array to a string using Power Automate

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

convert array to string power automate

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"
]
How to convert array to string in Microsoft power automate

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

  • Inputs: Provide the below expression
join (variables ('emails'), ',')
How to convert array to string in Microsoft power automate flow

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.
How to convert array to string in power automate

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.

Power automate convert array to string

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

See also  How to export SharePoint List items to excel using Power Automate and send email [Step-by-step tutorial]

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.

Convert an array to a string using Power Automate

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

Using Microsoft  Power automate convert array to string

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

convert array to string power automate

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"
]
How to convert array to string in Microsoft power automate

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 ‘,’.
convert array to string in Microsoft power automate flow

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.
How to convert array to string in power automate

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.

Power automate convert array to string

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

See also  How to Update SharePoint List Field with today's date in Power Automate?

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.

Using Power automate convert array to string

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

Using Microsoft  Power automate convert array to string

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

convert array to string power automate

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"
  }
]
convert array to string Microsoft power automate

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']
convert array to string in Microsoft power automate

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 ‘,’.
convert array to string in power automate

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.
How to convert array to string in power automate

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.

Microsoft Power automate convert array to string

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

See also  How to Copy New Files from Your PC to SharePoint using Power Automate?

Conclusion

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

You may also like:

>