A Logic App workflow that uses Filter array, Select and Join actions

Step 1: Create a Logic App

1. Go to the Azure portal.
2. Click on Create a resource > Integration > Logic App.
3. Provide a name, subscription, resource group, and location for your Logic App.
4. Click Review + create and then Create.

Step 2: Add a Recurrence Trigger

1. Open your Logic App in the designer.
2. Search for the Recurrence trigger and add it.
3. Configure the recurrence interval (e.g., every day, every hour, etc.).
   • Interval: 1
   • Frequency: Day (or Hour, depending on your requirement)

Step 3: Initialize a Variable with JSON Data

1. Add a new action after the Recurrence trigger.
2. Search for Initialize variable and add it.
3. Configure the variable:
   • Name: jsonData
   • Type: Array
   • Value: Paste your JSON data as an array. For example:

     [
       { "id": 1, "name": "John Doe", "email": "john@example.com", "age": 30 },
       { "id": 2, "name": "Jane Smith", "email": "jane@example.com", "age": 25 },
       { "id": 3, "name": "Alice Johnson", "email": "alice@example.com", "age": 35 }
     ]

Step 4: Filter the Array

1. Add a new action after the Initialize variable action.
2. Search for Filter array and add it.
3. In the From field, select the jsonData variable.
4. Set the filter condition. For example, filter objects where age is greater than 30:
   • Condition: item()?['age'] > 30
   • This will filter the array to include only objects where the age field is greater than 30.

Step 5: Use the Select Action

1. Add a new action after the Filter array action.
2. Search for Select and add it.
3. In the From field, select the output of the Filter array action.
4. Use the Map section to transform the filtered array. For example:
   • • Key: name
     • Value: item()?['name']
     • Key: email
     • Value: item()?['email']
   • This will create an array of objects with only the name and email fields.

Step 6: Use the Join Action

1. Add a new action after the Select action.
2. Search for Join and add it.
3. In the From field, select the output of the Select action.
4. Specify the Join with delimiter. For example, use a comma (,):
   • This will concatenate the values into a single string.

Step 7: Send an Email with the Result

1. Add a new action after the Join action.
2. Search for Gmail (or your email provider) and select Send email (V2).
3. Connect to your email account.
4. Fill in the email details:
   • To: Recipient email address
   • Subject: Filtered and Transformed Data
   • Body: Insert the output of the Join action. For example:
     

     Here is the filtered and transformed data:
     @{body('Join')}