Extract email from array of people picker field objects

[philipremanuel]

Hi-

I have filtered a sharepoint list and my results contain an array of people picker objects from a field called 'Assigned to.' This would be simple if it were just one person assigned to each item, however there can be multiple people assigned, so there is an array of objects. Each object stores multiple pieces of information. I need just the email address. I have tried multiple ways of trying to extract, I am stuck trying to reference just the email for each object in the array of objects. After I extract the email for each assigned to, I have a join using seperator ';'. This is currently returning blanks or errors.

Remove Past Due results in a filtered array.

this filtered array contains a nested array of people picker objects.

Here are the inputs

Thanks in advance for your help!

[philipremanuel]

Update* This article helped me correct my reference. However I now have a new error.

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-from-an-object/m-p/652476

[philipremanuel · Accepted solution]

Solved using this setup. First I extracted the array of people picker objects from the larger array. Theni extracted the emails from that array. Then I joined the resulting array of emails into a single string using join.

Now I can reference the string of emails in my To bar for my send email.

Hope this helps someone else out there as working with emails has been tedious.