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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,839)