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().

    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.

    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.

    Conclusion

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

    You may also like:

    >