Answered

Accessing the email in Person or Group Column (Sharepoint)

(0) Share

Report

Posted on by ux0042

I have a recurring flow that gets items from a SP library, condition to check the date, if yes get link to item, then send email to item Owner. Owner is Person or Group column. There is a Owner Email item available for me, but PA keeps removing it and inserting the Email item (I have no column in my SP named either Owner Email or Email. I am assuming the Owner Email content item is providing the Email value from the Person or Group column in my SP named 'Owner'). When the flow runs, the To field in the email is blank (I receive it as I am cc'd). I have tried other options for accessing emails such as initializing a variable or parse Json with select and join but get too many errors for me to follow. The following gets me closest to a working flow except for inserting the actual email address. Any suggestions are appreciated, thanks.

Accessing email value from person or group.jpg

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @ux0042

If you looking to send an email to a person who has created the record, you should use 'Created by Email' from Dynamic content as shown below:

Or using an expression:
Expression used in above screenshot:
items('Apply_to_each')?['Author/Email']

If this helps & solve your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
ux0042 15 on at

Like (0)

Report
Copy link

Link copied!

Thanks @ManishSolanki
I created all the records in the SP, which is the reason for an Owner column using the Person or Group type. Can the expression you provided be used to get the email from the Owner column?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @ux0042

For fetching the email of Owner field, pls use the below expression:
items('Apply_to_each')?['Owner/Email']

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
ux0042 15 on at

Like (0)

Report
Copy link

Link copied!
Thank you @ManishSolanki for your suggestions. I had really hoped this would work but it didn't. The flow "succeeded" for a few of the SP records, but it only sent the emails to me as I am cc'd. The flow failed for most of the records. The Send an Email control gives error 'Bad request' for each failed run. Below is a comparison of a successful and failed input from the Send an Email control. I wonder about the 'null' parameter, but it is there for both the 'successful' and failed runs.

Succeeded
{
"host": {
"connectionReferenceName": "shared_office365",
"operationId": "SendEmailV2"
},
"parameters": {
"emailMessage/To": null,
"emailMessage/Subject": "ELSA org chart update request: Project proposals: organization, FAQs",
...
}
}

Failed
{
"host": {
"connectionReferenceName": "shared_office365",
"operationId": "SendEmailV2"
},
"parameters": {
"emailMessage/To": null,
"emailMessage/Subject": "ELSA org chart update request: Sales: US Service Sales organization",
...
}
}

Here is complete code from the Send an Email control.
{

 "inputs": {

 "host": {

 "connectionName": "shared_office365",

 "operationId": "SendEmailV2",

 "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"

 },

 "parameters": {

 "emailMessage/To": "@items('Apply_to_each')?['Owner/Email']",

 "emailMessage/Subject": "ELSA org chart update request: @{items('Apply_to_each')?['Title']}",

 "emailMessage/Body": "\nThe Organizational Chart \n \n@{items('Apply_to_each')?['Title']} \n \nwas last updated in ELSA on @{items('Apply_to_each')?['ELSAPubDate']}. Please reply to this email and attach the latest version that should be available in ELSA, or a statement that this is the current version. \n \nLink to the file @{items('Apply_to_each')?['{Name}']}: \n@{outputs('Create_sharing_link_for_a_file_or_folder')?['body/link/webUrl']} \n \nThank you \nThis email was generated by Power Automate",

 "emailMessage/Cc": "...",

 "emailMessage/ReplyTo": "...",

 "emailMessage/Importance": "Normal"

 },

 "authentication": "@parameters('$authentication')"

 },

 "metadata": {

 "operationMetadataId": "fcc62dac-339d-485a-9f5c-0d01d87a0102"

 }

}

Was this reply helpful? Yes No
Verified answer

ux0042 15 on at

Like (0)

Report
Copy link

Link copied!

I replaced my custom Person or Group column with the default SP Person or Group column 'Assigned to' and the flow ran successfully sending the email to each email address associated with the person in the 'Assigned to' column. My take away here is use only default out-of-the-box SP columns with PA.

Was this reply helpful? Yes No