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.

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,679)