Unanswered

how to extract email address from a sharepoint person or group column that allows multiple selection

(2) Share

Report

Posted on by Community Power Pla...

Hi, I have a SharePoint list named 'Systems' it has a Titlle field and a field called 'SustemMaintainer'. 'SystemMaintaiiner is a 'Person Or Group' columns that allows multiple selections and people only.

In my flow I got the correct row by calling getItems and filtering based on the title column. so I have an array with one row, and that row has an a column that contains an array of people columns:

[
 {
 "Claims": "i:0#.f|membership|russell.gove@xx.com",
 "DisplayName": "Gove, Russell",
 "Email": "Russell.xx@xx.com",
 "Picture": "https://xx.sharepoint.com/sites/GLMasterData/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Russell.Gove@tronox.com",
 "Department": "Infrastructure Services",
 "JobTitle": "Sr SharePoint Architect"
 },
 {
 "Claims": "i:0#.f|membership|xx.xx@xx.com",
 "DisplayName": "xx, xx",
 "Email": "John.xx@xx.com",
 "Picture": "https://xx.sharepoint.com/sites/GLMasterData/_layouts/15/UserPhoto.aspx?Size=L&AccountName=John.Njoroge@tronox.com",
 "Department": "CFO Staff",
 "JobTitle": "Manager Accounting Analysis"
 }
]

How do I go about sending an email to the Email addresses in that array.

The expression

body('getItems')?['Value']?[0]?['SystemMaintainer']]

gets me the list of objects, But how do i extract the email addresses from thos objects in a format thats sutable for sending an email?

Categories:

General topics

I have the same question (0)

All responses (40)

Answers (3)

Verified answer

faustocapellanj 1,662 on at

Like (17)

Report
Hi @Anonymous

This is the approach I took to get the Email property from the SharePoint People field:

For the trigger, I'm using the Manually trigger a flow

In the next step, I'm using the SharePoint - Get items action and I set the Filter Query to retrieve the specific item I need

In the next step, I'm using the Data Operations - Select action. In the From field, add the expression below.
first(body('Get_items')?['Value'])?['SystemMaintainer']

The expression above is similar to the expression you're using to retrieve the SystemMaintainer. The difference is your expression has the first item from the array hard coded ([0]). The expression above uses the first() function to do the same thing. I find this approach a little cleaner.
For the Map field, switch to text mode by clicking on the T located on the lower-right corner, and then add the expression

item()?['Email']

This will retrieve the email address for each System Maintainer.

In the next step, I'm using the Data Operations - Join action. In the From field, select the Output from the Select step and for the Join with field, enter a semicolon (;). This will build a string of all the email addresses, each one separated by the semicolon.

And for the last step, add a Send an email action. In the To field, select the Output from the Join step. And for the Subject and Body fields, enter the information you need.

Try and let me know. Also, I added a screenshot of my Flow below so you can see all the steps.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (4)

Report
Hi @Anonymous,

Have your problem be solved?

I have made a test on my side, @faustocapellanj's solution is works on my side.

You could refer to screenshot below to create the flow:

Note:

1.Please notice that the Get items action name on your side,

if the Get items action name is getItems,

You could enter expression in the From field as below:

body('getItems')?['Value']?[0]?['SustemMaintainer']

Also you could enter expression as below:

first(body('getItems')?['Value'])?['SystemMaintainer']

if the Get items action name is Get items,

You could enter expression in the From field as below:

body('Get_items')?['Value']?[0]?['SustemMaintainer']

Also you could enter expression as below:

first(body('Get_items')?['Value'])?['SystemMaintainer']

2.Please make sure you have switch the Map in select action to text mode by click the symbol below：

The expression in the Map field in the select action as below:

item()['Email']

The flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Works like a champ! Thanks!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @faustocapellanj
I tried to do as in your instructions, but I can’t add the expression in Map in Text-Mode because of "add valid json".
Could you help me with it?

Thanks

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (1)

Report

Hi @Talis

For this to work, you need to do it in the Expression tab, you can't paste it directly in the box.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (0)

Report

@faustocapellanj could you explain what you mean by this? I have tried entering it as an expression in the "From" field and copying and pasting it into the Map field but it ends up as just the expression as text. If I enter it as an expression in map and then convert it over to text, it looks like the below which allows me to save but errors when I run the flow.

Enter and then converting to text looks like this.
Copying and pasting expression from "From" field looks like this

Any help would be greatly appreciated!

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report

Hi @CarlHRVA

The From field in the Select actions requires the output or body of a previous Get action or trigger. Then in the Map fields, you can wrap the respective field similar to first(item()?['Email])

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (0)

Report

@faustocapellanj Thanks for responding! I'm confused how to get the expressio, like shown in the screenshots above, into the map field. All of the instructions say to switch the Map field to text. In doing so, I don't have the option to add dynamic content so I can't enter the expression that way. If I paste it directly into the text box it tells me that I need to enter valid json. If I enter it as an expression in the "From" field and try to copy and paste it, it converts it to text and gives me the same json error. Thank you!

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report

Can you please post screenshots of the entire flow so I can understand better?

Thanks!

Was this reply helpful? Yes No
Verified answer

CarlHRVA 601 on at

Like (2)

Report

Of course!

Was this reply helpful? Yes No