Accessing the email in Person or Group Column (Sharepoint)

[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.

[ManishSolanki]

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

[ux0042]

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?

[ManishSolanki]

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

[ux0042]

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": "<p><span style=\"font-size: 16px\">\nThe Organizational Chart<br>\n<br>\n</span><span style=\"font-size: 16px\"><strong>@{items('Apply_to_each')?['Title']}</span><span style=\"font-size: 16px\"></strong><br>\n<br>\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.<br>\n<br>\nLink to the file </span><span style=\"font-size: 16px\"><strong>@{items('Apply_to_each')?['{Name}']}</span><span style=\"font-size: 16px\"></strong>:<br>\n</span><span style=\"font-size: 16px\">@{outputs('Create_sharing_link_for_a_file_or_folder')?['body/link/webUrl']}</span><span style=\"font-size: 16px\"><br>\n<br>\nThank you</span></p><br><br>\nThis email was generated by Power Automate",

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

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

            "emailMessage/Importance": "Normal"

        },

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

    },

    "metadata": {

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

    }

}

[ux0042 · Accepted solution]

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.