Answered

Extract email addresses from sharepont column

(0) Share

Report

Posted on by ajsanchez

I have a power app that I use to intake requests and the user receives an email with the details of their request. I am trying to add the ability to include additional people on the email notification. I've added a sharepoint person column so the name and email address can be looked up.

I'm having trouble extracting the email address from the sharepoint item. I'm using the flow pictured below and I keep getting blank (null results). Any help would be appreciated. Thanks.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

leo85 609 on at

Like (1)

Report

Hi,

there is very little information here, so it's very hard to trouble shoot. Please provide more information:

- How do you trigger the flow? What is the command in the Power App? (Please provide a screenshot)

- What are the results of the actions "Get items 1", "Select", "Join"?

- What are the input parameters you specified for these actions?

Regards

Was this reply helpful? Yes No
Verified answer

Wee Teck 45 on at

Like (0)

Report
To extract the email address from a SharePoint person column, you need to make sure you're selecting the email property of the person field in your Power Automate flow. The SharePoint person field stores several properties, including the email, name, and user ID

In the 'Get Items' Action:

Ensure you are including the person column in the list of columns to retrieve.

The person column in SharePoint provides complex data (like name, email, etc.), so you'll need to extract the email specifically.

In the 'Select' Action:

Use the correct expression to pull out the email address from the person column. The person column stores multiple properties as a JSON object, and the email is typically accessed through .Email.

For the Select Action:

From Field: Select the person column from the dynamic content.

Map Field (Expression): You will use an expression like this to extract the email: E.g. Item()?['PersonColumnName']?['Email']

Join the Results in the 'Join' Action:

After the Select action, you are using the Join action to concatenate email addresses. Ensure that you join the results using a delimiter like a semicolon (;) if you're sending emails to multiple recipients.

Was this reply helpful? Yes No
ajsanchez 4 on at

Like (0)

Report

@Wee Tack

Thank you. I was able to get it to work by following your instructions. It automatically added a for each which corrected the issue once I put the following steps inside.

Was this reply helpful? Yes No