Array Aggregator to toCollection()

How To
, ,
1

Hello. I am spinning my wheels on this and I am hopeful someone can help on the toCollection() scenario.

Here is my workflow that I want:

  1. Search Records in airtable
  2. Aggregate those records into a single output
  3. Use that output as a daily digest email

Here is the general email format that I would like:

Hello,

Below is a summary of the daily updates:

Record 1
date
title
description

Record 2
date
title
description

Record 3
date
title
description

Thank you!

I got the records to aggregate using the Array aggregator

image
image1017×825 89.5 KB

but now I need to change the bundles into a Collection so I can then add that collection to a list in an email.

image
image971×478 59.6 KB

I can’t seem to figure out the right key/value need as it is returning an empty collection:
image

Here is the output of the array aggregator:

[
    {
        "array": [
            {
                "date": "2024-08-10",
                "Title": "test1",
                "Description": "testing the summary 1"
            },
            {
                "date": "2024-08-10",
                "Title": "test2",
                "Description": "testing the summary 3"
            },
            {
                "date": "2024-08-10",
                "Title": "test3",
                "Description": "testing the summary 3"
            }
        ],
        "__IMTAGGLENGTH__": 3
    }
]

I feel like I am missing something very obvious and simple here. Can anyone help point me in the right direction?

2

Hi @JG24
You can make use of text aggregator to achieve this.
Sample structure created from the output bundle provided:

image
image555×680 36.7 KB

Iterate through the array:
image

Use text aggregator to combine all the text:

image
image772×837 74.9 KB

Output:

image
image535×748 28.1 KB

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

3

This is perfect! Thank you! I never used the text aggregator before.

4

Hey @JG24

we would really appreciate if you mark the answer as solution if it helped you. This will keep the community healthy and organized.

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation