Concatenate aggregated array

Hi
I have a scenario where it reads record from a data.
The records all have a value that some of them can share (ie id) which is NOT the key.
Let’s say the records also have a date.

I want to aggregate the records using this id, which I managed to do.
Now, I want to be able to use the array in the next module, in a way that creates a long string with all the records found.
For example:
Record1 id1 date1
Record2 id1 date2
Record3 id2 date3

I want to be able to create this string after grouping by id, let’s say for id1 it’ll look like:
This: Record1 is: id1 at:date1
This: Record12 is: id1 at:date2

So this is a string I want to use and run it on the next scenario.
How do I do that?

You can use a Text Aggregator.

2 Likes

@samliew Thank you, it does solve it, but introduces a new problem.
I see that when using the text aggregator, I lose the capability of accessing prior variables.
Here’s my scenario:

I want the bottom action (51 - Delete record) to only happen after the entire upper path has completed.
However, looking at the flow it shows me that it will run the bottom path after aggrating the text and before continuining to use OpenAI.

How do I make sure to only delete the record (that was read at the first module) after EVERYTHING is done?
If I put it at the end of the upper path I do not have access to the key of the record found on the first module (50).

I also just noticed that even on module 35 I can’t access to record found on module 39, it’s simply not there.

Thanks