Perform data operations in Azure Logic Apps

Applies to: Azure Logic Apps (Consumption + Standard)

This how-to guide shows how you can work with data in your logic app workflow in the following ways:

• Create a string or JavaScript Object Notation (JSON) object from multiple inputs that have different data types. You can then use this string as a single input, rather than repeatedly entering the same inputs.
• Create user-friendly tokens from JavaScript Object Notation (JSON) object properties so that you can easily use those properties in your workflow.
• Create an HTML or CSV table from an array.
• Create an array from another array based on a specified filter or condition.
• Create an array based on the specified properties for all the items in another array.
• Create a string from all the items in an array and separate those items using a specified character.

Prerequisites

• An Azure account and subscription. If you don't have a subscription, sign up for a Azure account.

• The logic app workflow where you want to perform the data operation. Both Consumption and Standard logic app workflows support the data operations described in this guide.

  All data operations are available only as actions. So, before you can use these actions, your workflow must already start with a trigger as the first step and include any other actions required to create the outputs that you want to use in the data operation.

Data operation actions

The following sections summarize the data operations you can use and are organized based on the source data types that the operations work on, but each description appears alphabetically.

JSON actions

The following actions help you work with data in JavaScript Object Notation (JSON) format.

Action	Description
Compose	Create a message, or string, from multiple inputs that can have various data types. You can then use this string as a single input, rather than repeatedly entering the same inputs. For example, you can create a single JSON message from various inputs.
Parse JSON	Create user-friendly data tokens for properties in JSON content so that you can more easily use the properties in your logic apps.

To create more complex JSON transformations, see Perform advanced JSON transformations with Liquid templates.

Array actions

The following actions help you work with data in arrays.

Action	Description
Create CSV table	Create a comma-separated value (CSV) table from an array.
Create HTML table	Create an HTML table from an array.
Filter array	Create an array subset from an array based on the specified filter or condition.
Join	Create a string from all the items in an array and separate each item with the specified character.
Select	Create an array from the specified properties for all the items in a different array.

Compose action

To construct a single output such as a JSON object from multiple inputs, use the action named Compose. Your inputs can have various types such as integers, Booleans, arrays, JSON objects, and any other native type that Azure Logic Apps supports, for example, binary and XML. You can then use the output in actions that follow after the Compose action. The Compose action also helps you avoid repeatedly entering the same inputs while you build your logic app's workflow.

For example, you can construct a JSON message from multiple variables, such as string variables that store people's first names and last names, and an integer variable that stores people's ages. In this example, the Compose action accepts the following inputs:

{ "age": <ageVar>, "fullName": "<lastNameVar>, <firstNameVar>" }

And creates the following output:

{"age":35,"fullName":"Owens,Sophia"}

To try the Compose action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Compose and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Compose. For more information about the Compose action in the underlying JSON workflow definition, see the Compose action.

Test your workflow

To confirm whether the Compose action creates the expected results, send yourself a notification that includes output from the Compose action.

1. In your workflow, add an action that can send you the results from the Compose action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, for each box where you want the results to appear, select inside each box, and then select the dynamic content list. From that list, under the Compose action, select Outputs.

   For this example, the result appears in the email's body, so add the Outputs field to the Body box.

   

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Create CSV table action

To create a comma-separated value (CSV) table that has the properties and values from JavaScript Object Notation (JSON) objects in an array, use the action named Create CSV table. You can then use the resulting table in actions that follow the Create CSV table action.

To try the Create CSV table action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Create CSV table and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Create CSV table. For more information about the Create CSV table action in the underlying JSON workflow definition, see the Table action.

Customize table format

By default, the Columns property is set to automatically create the table columns based on the array items. To specify custom headers and values, follow these steps:

1. If the Columns property doesn't appear in the action information box, from the Advanced parameters list, select Columns.

2. Open the Columns list, and select Custom.

3. In the Header property, specify the custom header text to use instead.

4. In the Value property, specify the custom value to use instead.

To return values from the array, you can use the item() function with the Create CSV table action. In a For_each loop, you can use the items() function.

For example, suppose you want table columns that have only the property values and not the property names from an array. To return only these values, follow these steps for working in designer view or in code view.

This example returns the following result:

Apples,1
Oranges,2

Work in designer view

In the Create CSV table action, keep the Header column empty. On each row in the Value column, dereference each array property that you want. Each row under Value returns all the values for the specified array property and becomes a column in your table.

1. For each array property that you want, in the Value column, select inside the edit box, and then select the function icon, which opens the expression editor. Make sure that the Function list appears selected.

2. In the expression editor, enter the following expression, but replace <array-property-name> with the array property name for the value that you want. When you're done with each expression, select Add.

   Syntax: item()?['<array-property-name>']

   Examples:

   • item()?['Description']
   • item()?['Product_ID']

   

   For more information, see item() function.

3. Repeat the preceding steps for each array property. When you're done, your action looks similar to the following example:

   

Work in code view

In the action's JSON definition, within the columns array, set the header property to an empty string. For each value property, dereference each array property that you want.

1. From the designer, switch to code view.

   • Consumption: On the designer toolbar, select Code view.
   • Standard: On the workflow navigation menu, under Developer, select Code.

2. In the code editor, find the action's columns array. For each column of array values that you want, add an empty header property and the following expression for the value property:

   Syntax:

   {
      "header": "",
      "value": "@item()?['<array-property-name>']"
   }
   

   Example:

   "Create_CSV_table": {
      "inputs": {
         "columns": [
            { 
               "header": "",
               "value": "@item()?['Description']"
            },
            { 
               "header": "",
               "value": "@item()?['Product_ID']"
            }
         ],
         "format": "CSV",
         "from": "@variables('myJSONArray')"
      }
   }
   

3. Switch back to designer view to review the results.

Test your workflow

To confirm whether the Create CSV table action creates the expected results, send yourself a notification that includes output from the Create CSV table action.

1. In your workflow, add an action that can send you the results from the Create CSV table action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, for each box where you want the results to appear, select inside each box, which opens the dynamic content list. From that list, under the Create CSV table action, select Output.

   

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Create HTML table action

To create an HTML table that has the properties and values from JavaScript Object Notation (JSON) objects in an array, use the Create HTML table action. You can then use the resulting table in actions that follow the Create HTML table action.

To try the Create HTML table action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Create HTML table and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Create HTML table. For more information about the Create HTML table action in the underlying JSON workflow definition, see the Table action.

Customize table format

By default, the Columns property is set to automatically create the table columns based on the array items. To specify custom headers and values, follow these steps:

1. If the Columns property doesn't appear in the action information box, from the Advanced parameters list, select Columns.

2. Open the Columns list, and select Custom.

3. In the Header property, specify the custom header text to use instead.

4. In the Value property, specify the custom value to use instead.

To return values from the array, you can use the item() function with the Create HTML table action. In a For_each loop, you can use the items() function.

For example, suppose you want table columns that have only the property values and not the property names from an array. To return only these values, follow these steps for working in designer view or in code view.

This example returns the following result:

Apples,1
Oranges,2

Work in designer view

In the Create HTML table action, keep the Header column empty. On each row in the Value column, dereference each array property that you want. Each row under Value returns all the values for the specified array property and becomes a column in your table.

1. For each array property that you want, in the Value column, select inside the edit box, and then select the function icon, which opens the expression editor. Make sure that the Function list appears selected.

2. In the expression editor, enter the following expression, but replace <array-property-name> with the array property name for the value that you want. When you're done with each expression, select Add.

   Syntax: item()?['<array-property-name>']

   Examples:

   • item()?['Description']
   • item()?['Product_ID']

   

   For more information, see item() function.

3. Repeat the preceding steps for each array property. When you're done, your action looks similar to the following example:

   

Work in code view

In the action's JSON definition, within the columns array, set the header property to an empty string. For each value property, dereference each array property that you want.

1. From the designer, switch to code view.

   • Consumption: On the designer toolbar, select Code view.
   • Standard: On the workflow navigation menu, under Developer, select Code.

2. In the code editor, find the action's columns array. For each column of array values that you want, add an empty header property and the following expression for the value property:

   Syntax:

   {
      "header": "",
      "value": "@item()?['<array-property-name>']"
   }
   

   Example:

   "Create_HTML_table": {
      "inputs": {
         "columns": [
            { 
               "header": "",
               "value": "@item()?['Description']"
            },
            { 
               "header": "",
               "value": "@item()?['Product_ID']"
            }
         ],
         "format": "HTML",
         "from": "@variables('myJSONArray')"
      }
   }
   

3. Switch back to designer view to review the results.

Test your workflow

To confirm whether the Create HTML table action creates the expected results, send yourself a notification that includes output from the Create HTML table action.

1. In your workflow, add an action that can send you the results from the Create HTML table action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, for each box where you want the results to appear, select inside each box, and then select the lightning icon, which opens the dynamic content list. From that list, under the Create HTML table action, select Output.

   

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Filter array action

To create a subset array from an existing array where the subset items meet specific criteria, use the Filter array action. You can then use resulting filtered array in actions that follow the Filter array action.

To try the Filter array action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Filter array and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Filter array. For more information about the Filter array action in the underlying JSON workflow definition, see the Query action.

Test your workflow

To confirm whether Filter array action creates the expected results, send yourself a notification that includes output from the Filter array action.

1. In your workflow, add an action that can send you the results from the Filter array action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, complete the following steps:

   1. For each box where you want the results to appear, select inside each box, and then select the function icon, which opens the expression editor. Make sure that the Function list appears selected.

   2. To get the array output from the Filter array action, enter the following expression, which uses the body() function with the Filter array action name, and then select Add.

      body('Filter_array')

      

      The resolved expression specifies to show the outputs from the Filter_array action in the email body when sent:

      

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Join action

To create a string that has all the items from an array and separate those items with a specific delimiter character, use the Join action. You can then use the string in actions that follow the Join action.

To try the Join action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Join and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Join. For more information about the Join action in your underlying workflow definition, see the Join action.

Test your workflow

To confirm whether the Join action creates the expected results, send yourself a notification that includes output from the Join action.

1. In your workflow, add an action that can send you the results from the Join action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, for each box where you want the results to appear, select inside each box, and then select the lightning icon, which opens the dynamic content list. From that list, under the Join action, select Output.

   

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Parse JSON action

To reference or access properties in JavaScript Object Notation (JSON) content, you can create user-friendly fields or tokens for those properties by using the Parse JSON action. That way, you can select those properties from the dynamic content list when you specify inputs for subsequent actions in your workflow. For this action, you can either provide a JSON schema or generate a JSON schema from your sample JSON content or payload.

To try the Parse JSON action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Parse JSON and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Parse JSON. For more information about this action in your underlying workflow definition, see Parse JSON action.

Test your workflow

To confirm whether the Parse JSON action creates the expected results, send yourself a notification that includes output from the Parse JSON action.

1. In your workflow, add an action that can send you the results from the Parse JSON action.

   This example continues by using the Office 365 Outlook action named Send an email.

2. In this action, for each box where you want the results to appear, select inside each edit box, and then select the lightning icon, which opens the dynamic content list. From that list, under the Parse JSON action, select the properties from the parsed JSON object.

   This example selects the following properties: Body FirstName, Body LastName, and Body Email

   

   When you're done, the Send an email action looks similar to the following example:

   

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Select action

By default, the Select action creates an array that contains JSON objects built from the values in an existing array. For example, you can create a JSON object for each value in an integer array by specifying the properties that each JSON object must have and mapping the values from the source array to those properties. Although you can change the component JSON objects, the output array always has the same number of items as the source array. To use the output array from the Select action, subsequent actions must either accept arrays as input, or you might have to transform the output array into another compatible format.

To try the Select action, follow these steps by using the workflow designer. Or, if you prefer working in the code view editor, you can copy the example Select and Initialize variable action definitions from this guide into your own logic app's underlying workflow definition: Data operation code examples - Select. For more information about this action in your underlying workflow definition, see Select action.

Test your workflow

To confirm whether the Select action creates the expected results, send yourself a notification that includes output from the Select action.

1. In your workflow, add an action that can send you the results from the Select action.

2. In this action, complete the following steps:

   1. For each box where you want the results to appear, select inside each box, and then select the function icon, which opens the expression editor. Make sure that the Function list appears selected.

   2. To get the array output from the Select action, enter the following expression, which uses the body() function with the Select action name, and select Add:

      body('Select')

      

      The resolved expression specifies to show the outputs from the Select action in the email body when sent:

      

3. Save your workflow, and then manually run your workflow.

   • Consumption workflow: On the designer toolbar, select Run > Run.
   • Standard workflow: On the workflow navigation menu, select Overview. On the Overview page toolbar, select Run > Run.

If you used the Office 365 Outlook action, the following example shows the result:

Troubleshooting

Format table data

If your CSV table or HTML table is returned with incorrect formatting, make sure your input data has line breaks between rows.

Incorrect formatting:

Fruit,Number Apples,1 Oranges,2

Correct formatting:

Fruit,Number
Apples,1
Oranges,2

To add line breaks between rows, add one of the following expressions to your table:

replace(body('Create_CSV_table'),'','<br/>')

replace(body('Create_HTML_table'),'','<br/>')

For example:

{
	"Send_an_email_": {
		"inputs": {
			"body": {
				"Body": "<p>Results from Create CSV table action:<br/>\n<br/>\n<br/>\n@{replace(body('Create_CSV_table'),'\r\n','<br/>')}</p>",
				"Subject": "Create CSV table results",
				"To": "sophia.owen@fabrikam.com"
			}
		}
	}
}

Related content

• Managed connectors for Azure Logic Apps
• Built-in connectors for Azure Logic Apps