Filter array of collections

Hello,
I have a simple use case but couldn’t find the answer.
I have a simple array of collections. Each collection has and “id” and an “email”.

I’d like to create a filter that checks if there is a collection where email = “myemail” and id = “not empty”, both from the same collection.
my current filter doesn’t work because it looks for all collection to find “myemail” then all collections to find a “not empty” id. The id might not be from the same collection.

thanks for the help!


1 Like

Do you have any updates about this issue?

1 Like

Hi @Steph
Sample structure created:


Then iterate:

Filter:

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like

Thanks, but doesn’t iteration consume multiple credits?(my array has 2k+ items)

1 Like

Hi @Steph

Add an array aggregator After the iterator module. This will take only one operation to aggregate all items.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation