Answered

Extract email from object and Append each email to Variable

(0) Share

Report

Posted on by HM-18111627-0

Hi all,

I would like to extract each email address from "CopyTo" and append them afterwards.
They are append so I can use them as CC email address later on.

Currently I am using apply to each and append to variables.

However this method appends email from other Sharepoint items as well.

Regards
Hidayat

[
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|m.hidayat@Random.com",
 "DisplayName": "Hidayat",
 "Email": "M.Hidayat@Random.com",
 "Picture": "https://.com",
 "Department": null,
 "JobTitle": null
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 "Claims": "i:0#.f|membership|sin.wong@Random.com",
 "DisplayName": "Derrick",
 "Email": "Sin.Wong@Random.com",
 "Picture": "https://.com",
 "Department": null,
 "JobTitle": null
 }
]

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Yatz can you please give a little background of your scenario here for me to understand the issue better. I am not sure why you have three Apply to each nested here, can you describe your SharePoint list and what you want to get from the list?

Was this reply helpful? Yes No
HM-18111627-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @annajhaveri ,

I am extracting unique records from SP using the process from below link.
Power Automate Get Unique Values from Array | Distinct Items from Excel, SharePoint & Dataverse

One of the columns I wanted to populate is the CopyTo column where multiple email addresses are stored. The email address will be used as CC when sending out Email later on.

In the step Apply to Each 2, Compose, I managed to extract the object out with the following output.

[ { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|m.hidayat@Random.com", "DisplayName": "Hidayat", "Email": "M.Hidayat@Random.com", "Picture": "https://.com", "Department": null, "JobTitle": null }, { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|sin.wong@Random.com", "DisplayName": "Derrick", "Email": "Sin.Wong@Random.com", "Picture": "https://.com", "Department": null, "JobTitle": null } ]

The end result image would be as follow:

Type String: m.hidayat@Random.com; Sin.Wong@Random.com

Regards
Hidayat

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Yatz okay, so you have a SharePoint list with People and Group column, correct? Is that single valued or multi valued column? Are you looking to combine email address from a specific list item column value or from all list items column value?

Was this reply helpful? Yes No
HM-18111627-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @annajhaveri ,

It is a multi people column, named CopyTo.
I am looking to join all email address from a specific item list with this column.

Regards
Hidayat

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Yatz you can combine the multi valued person column into string of comma separated email address using below steps:

1. Add select action as shown below, and in from select the multi valued person column value from dynamic content and in map use below expression
item()?['Email']

2. Add Compose action and use below expression
join(body('Select'),',')

The output of compose action will be comma separated values of all emails from the multi valued person field value.

Was this reply helpful? Yes No
HM-18111627-0 18 on at

Like
a
(1)

Report
Copy link

Link copied!
Thank you so much @annajhaveri !
You are right, there is no need for 3 actions of apply to each to do this.

I needed to add an additional step to extract the first record else it will give an apply to each after Select statement.

first(body('GroupUniqueKey'))?['CopyTo']

Was this reply helpful? Yes No