Hi @ShaharGR
I would run a get items and then an apply to each on the unique engineer names/emails (not ALL rows). In the apply to each, use the engineer name/email as a filter (filter array action) on the result of the get items. This looks like you might have something very similar. The only thing you are missing is a list of unique emails for the engineers.
You can get this list of unique emails using a union on the list of all engineer emails with itself. If you perform a union(array(1,2,3,3,2,1,3,2,1,3,1,2), array(1,2,3,3,2,1,3,2,1,3,1,2)) you will get 1,2,3 by return. In order to get the emails required for this you can use the select action on the Email Field, using the text mode for mapping. Do these two actions before your apply to each and replace the output of the apply to each with the array of emails.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
