Power Automate Join Function And Action Explained

Power Automate Join Function And Action

The Power Automate Join function and action are the counterpart to the Power Automate split function. The Join function converts a text array to one string and separates the elements of the array by a delimiter. It is undoing the split function like split is undoing a join function.

A very common use case is to use a comma or semicolon as the delimiter to generate a CSV file like separation of the elements.

In this artile you will get to know the Power Automate join function and action in detail and by examples. Furthermore you will learn how to handle common advanced scenarios with the join function.

Power Automate Join Function

Power Automate Join Function
Join function Power Automate

The Power Automate join function returns a string that is created by the given string array by concatenating all array elements by the given delimiter.


join([<collection>], '<delimiter>')

Input parameters

  • collection (mandatory): The collection/array which elements should be joined to a string.
  • delimiter (mandatory): The delimiter to separate array items of each other.

Return value

  • A string containing all given collection elements separated by the given delimiter.

Power Automate Join Expression Examples


// returns "a,b,c"


// reference variable within in join function

Power Automate Join Action

The join action in Power Automate is identical to the join function. The action is more convenient to use, since Power Automate expressions are sometimes a little fiddly to create.

Nevertheless, expression do not bloat a flow as much as actions. So in most cases, I would use the function for this reason. In small simple flows I would not care and probably use the action. In the end, it doesn’t really matter.

Let’s take a look how to use the Power Automate Join action by doing a very simple example.

How To Use Power Automate Join Action

Within this step by step guide you will learn how to use the Join action. We will join an array to a string in this simple example.

  1. Create a new flow with name ‘Join Flow’ of type ‘Manually trigger a flow’

    Power Automate Join Action new flow

    Create new instant flow

  2. Add a new step by clicking on ‘+ New step’

    Power Automate Join Action new step

    Add a new step

  3. Search for ‘initialize’ and click on ‘Initialize variable’

    Power Automate Join Action initialize variable

    Add Initialize variable

  4. Set Name to ‘myArray’, Type to Array and value to ‘[“apple”,”orange”,”banana”],

    Power Automate Join Action initialize variable settings

    Setup Initialize variable action

  5. Add a join action by searching for ‘join’ and click on the Join Data operation

    Power Automate Join Action add join action

    Add Join action

  6. Click in the ‘From’ text field and click on ‘myArray’ int he popup

    Power Automate Join Action from

    Join action from

  7. Set the Join with value to ‘,’

    Power Automate Join Action Join with

    Join action Join with

  8. Do a test run and check the result string

    Power Automate Join Action test run

    Result test run – Power Automate join array of strings

More Power Automate Join Examples

See more examples on how to use join in Power Automate here.

Join with newline

When you want to join a Power Automate join array with line break, you need to decode the new line with the decodeUriComponent function. See how the delimiter is set to new line in the following example.

Power Automate Join with newline
Power Automate Join with newline – Expression

Leave a Comment

Your email address will not be published. Required fields are marked *