Unanswered

Get User Profile (V2) to get email address and send email not working

(0) Share

Report

Posted on by staceylaney

I am using an InfoPath form with People/Group Picker fields for approvers, published to a SharePoint form library. When publishing the form, people/group picker fields must be configured to SP site columns as either "DisplayName", "AccountID" or "AccountType".

The Flow should simply pull the email address of the user in the people picker field to send an email. Here is how the Flow is configured (simple test flow):

Annotation 2019-10-11 161130a.png

This is the error I get if people picker configured as "DisplayName":

Annotation 2019-10-11 161130.png

This is the error I get if people picker configured as "AccountID":

Annotation 2019-10-11 161130b.png

This is the error I get if people picker configured as "AccountType":

Annotation 2019-10-11 161130c.png

Typically people picker fields are published as "DisplayName" and they are recognized as people picker fields in SharePoint and seemingly even in Flow, but as you can see, Flow is having a hard time pulling AD/Azure user info correctly and I'm not sure if it's because of InfoPath or the way we have users setup in AD/Azure, or maybe I'm just not configuring the Flow correctly.

Any help or guidance would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @staceylaney

For Get user profile(v2) you need to pass the User principal name or email id. I can see your trigger is 'When a new item is created' Try to use the 'Created by Email' mapping under Get user profile.

Let me know whether it works or not.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
Verified answer

Gristy 2,429 on at

Like (2)

Report

Hello

Use account id but you need to remove the claims portion first. use the following in a compose action:

replace(YOURACCOUNTIDVARHERE,'i:0#.f|membership|','')

Replace YOURACCOUNTIDVARHERE with your Account ID variable and use the output in the office 365 profile lookup action

Was this reply helpful? Yes No
staceylaney 63 on at

Like (0)

Report

@Gristy- this worked BEAUTIFULLY! THANKS!!!

Was this reply helpful? Yes No
ranjo364 2 on at

Like (0)

Report

We're using a PowerAutomate workflow approval process for merging software updates. I have a working flow for a three-step approval process. However, the v2 email approval messages for each of the 3 phases all show the emails as "FROM" the initial approver (who is also the author of the automated flow ). The message contents show with the correct approver name for each step.
Is there a way to have the actual approvers name as sender of the corresponding V2 mail at each phase instead of the first approver / originator (who is the also the flow owner) ?
thanks
JR

Was this reply helpful? Yes No