cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philipremanuel
Frequent Visitor

Extract email from array of people picker field objects

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.

 

philipremanuel_0-1628186106144.png

 

Here are the inputs

 

philipremanuel_1-1628186295731.png

Thanks in advance for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
philipremanuel
Frequent Visitor

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.

philipremanuel_0-1628191630231.png

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.

 

View solution in original post

2 REPLIES 2
philipremanuel
Frequent Visitor

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_0-1628188826191.png

 

philipremanuel
Frequent Visitor

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.

philipremanuel_0-1628191630231.png

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.

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,627)