Unanswered

Getting email from multiperson SharePoint fields

(0) Share

Report

Posted on by iskguy

402

I have a flow that will run on the first of each month, get the month and then filter a sharepoint list based on that month. This part works with no issue. Next, I need to get both the Lead and CoLead email(s) from each record that is extracted. I am trying to append the email to the array but find it difficult to get the proper syntax to get that email. I am trying item()?['Lead]]?['Email'] but I get an error. I also need to not only get the Lead email, but the CoLead email, and then do a DISTINCT, so they are not duplicated.

I get this - 'item()?['Lead']?['Email']' cannot be evaluated because property 'Email' cannot be selected. Array elements can only be selected using an integer index.

I appreciate any help and direction for this.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @iskguy
Use 2 selects (switch mapping to text mode) then use a compose with the union function to get distinct emails from both selects and finally a compose with the join function to join the distinct emails with semi-colons ;

e.g.

Map selects to item()?['Email']

Distinct email array
union(body('Select_Lead_Emails'),body('Select_CoLead_Emails'))

String of distinct emails
join(outputs('Distinct_Email_array'),';')

Was this reply helpful? Yes No
iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this reply. I think my main issue is mapping to the actual email. This is coming from a list of records that are filtered by month. So when I do the first Select, it wants to wrap around an Apply To Each. Would that work the same? Would it be item()?['Lead']?['Email']? Or items()??['Lead']?['Email']?

Was this reply helpful? Yes No
iskguy 402 on at

Like
a
(0)

Report
Copy link

Link copied!

For instance, this works, but comes up with NULL values and there are not null values

Was this reply helpful? Yes No