cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
philipremanuel
New Member

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
New Member

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
New Member

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
New Member

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,104)