Notion CRM : How to extract specific keys from an array?

[Thomas_Lemarchand]

Hey,

I use Notion as my CRM, my first module is the Notion Watch database.
Then I have this Array Aggregator because i just want the surnames in an Array.

But after I can’t find a way to just extract “Jacques” and “Thom”. I tried many formulas, I talked to Claude and ChatGPT, watch many videos… but I’m still block. The number of names car change, here only two but can be 10.

Can someone help me please ?

Thank you !!!

[ladla_karan]

Replicated the scenario but it takes few more operations.

Solution:

1. Use iterator to separate out array elements into bundles
   

   

2. Fetch Text.Content for each bundle
   

   

3. Array Aggregate all the values
   

   

4. Map out the array of the Surnames as text (if needed)
   

   
   
   

Let me how it works out.

[Thomas_Lemarchand]

Works perfectly!! Thanks a lot !!!