Get user profile email address from SharePoint column

[Anonymous]

Hi everyone. Complete newb at using Power Automate. The answers found here have been so helpful! I'm really stuck after spending hours on this single issue, so I'd really appreciate your help.

We're using Lists as a lead management platform, including columns for Follow-up Action, Follow-up Date, and Action Assignee. What I want to happen is when the Follow-up Date = today, email a prompt to the Action Assignee. Getting PA to take action on the Follow-Up Date is no problem, as I've got it successfully setup to send a message to a Teams channel when Follow-Up Date = today.

Where my flow is always failing is pulling the email address from the Action Assignee field (see screenshots), which is connected to their user profile. When I switch out "Get user profile" for "Get my profile", it works successfully, so the email step is not the problem. Thank you so much for your help!

[ccc333ab]

If your Action Assignee is of type Person, you can use the Action Assignee Email column in the "Get User Profile" action. 

If your Action Assignee is of type String, then you'll need to first do a search for the user using "Search for Users" action, and then using the ID returned from this in your "Get User Profile" action. 

[Anonymous]

Thanks for replying! I tried those two options and they came back with errors unfortunately.

I'm pretty certain Action Assignee is of type Person and not String. When we select an Action Assignee while creating or editing a record, it gives options of people in the company based on your first few keystrokes and when you hover over any of them it shows their department, title, email address, etc.

Attempt #1, Search for users (v2):

Attempt #2, Get User Profile (V2) via Action Assignee Email:

This forces an "Apply to each 2" and results in the error below

Attempt #3, Get User Profile (V2) via Action Assignee:

(Resulted in error that it won't display for me)

[ccc333ab · Accepted solution]

Excellent troubleshooting, thanks for the testing as that makes it a bit easier to diagnose. 

Because this is forcing you to use Apply_to_each, and the error message of "is of type object", that indicates to me that your Action Assignee is actually a multiple select field (i.e., you can select more than one Assignee). 

Therefore you will need to extract out the individual person out from this field. You can do this as follows: 

(Note, in my example below, my field is called "Stage 1 Approvers". This would be equivalent for your Action Assignment field. 

1. Inside your initial Apply to each, get rid of everything you have and instead start with a brand new Apply to each (create it yourself, don't let Power Automate create this for you). 

Where I highlighted in red, put in your "Action Assignment" field in here. This is the field with no additional clarifications on it (You should see things like Action Assignemnt, Action Assignment Item, Action Assignment DisplayName, Action Assignement Email, etc.) Just select the main one.

Note: If you get an additional Apply to Each added in, you selected the wrong one.

2.  Now you can grab the first person's email address, and feed that into the Get User Profile action. 

And now you can send your email. 

[ccc333ab]

As I posted that....since you already have the email from your Action Assignment Email field, not sure you even need to do a Get User Profile call. You can just use that email address instead.....

[Anonymous]

Thank you so much for your help! I'll try these methods.

In regard to your second reply, here's the result. I'll post the results of your first suggestion in a moment.

I think I've tried that (please let me know if there's another way of doing this) by putting "Action Assignee Email" in the To: field of the Send an Email step. This forces an Apply to Each 2 step and results in an error:

[ccc333ab]

Sorry, on my second reply. What I meant was you still need to loop on each Action Assignment (i.e., this step):

But then you can the just use the Action Assignment Email from this, you wouldn't need to then do a Get Users Profile step...

[Anonymous]

Manually creating the Apply to Each worked! Thank you so much! I've spent hours on this and you found the solution lickety-split. You really are an impactful individual. 🙂

[Christineleegt]

Hi, I am new in Power Automated. I tried follow the steps but it is not working, anyone can help me?

When I manual add step for Apply to Each, what shall the "output"? I cannot find the dynamic content "value"

[Christineleegt]

error code

[ccc333ab]

@Christineleegt In your situation, you are using the trigger "When an item is created". So that means you will have a single item being sent into the flow and you would not need to use an "Apply to Each" action (which is why you have no dynamic content). 

You can simply grab the user provfile directly from the trigger value (so basically, all the itmes you have in your apply to each loop, you can move outside the loop).