Obtaining User Profile (UPN) information built into PowerAutomate.

[ninjaryder1st]

Situation:

I have a flow that creates a SP list item each time a Form that is submitted.   I'd like to find a connector to "get user profile (V2)"  information (User UPN required) about an employee that is mentioned via the form when its submitted on behalf of them. 
I have dynamic content for the person submitting the form, but need to obtain the person being mentioned, not the actual submitter.  

Any way to do that using dynamic content for the specific SharePoint list item generated by the form completion?  We use an email directory and can search for employees, but I cannot get the "get user profile V2" to link up to this email address on the employee, who differs from the Form Submitter.   Thanks!

[DamoBird365]

Hi @ninjaryder1st 

Have you looked at the body of the response details for the Form in the history?

Copy that into the call and I will help you write an expression for it.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[DamoBird365]

Hi @ninjaryder1st 

How are you getting on?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[ninjaryder1st]

Hello @DamoBird365,

Thank you for checking back in.     So, I discovered the Form actually doesn't contain the employee or its user UPN information.   Rather,  a different employee or manager may submit the employee name with free text, for which we have a flow to create a SP list item when the form is completed.    

Because this is an internal and external form,  submitters may not have the nominee's company email address.  So, an admin reviews the SP for new submissions, and then add the employee email to the list item in a SP column  From here, I'd we'd like to have power automate "update item" in the SP list item and populate information into a few extra columns based the "get user profile V2" or some other employee information source.   My flow doesn't appear to like the Sharepoint dynamic content placed into the mandatory field for "*User UPN" ("get user profile V2).  It throws an "openinputsparameter" and "OpenAPI conntection is not valid"

[DamoBird365]

Hi @ninjaryder1st 

You need to check your dynamic value, it says that it is null or empty.  Your expression may be invalid.  Where are you getting the data from?  What is your expression?  Have you tried the same expression in a compose action to see what is being retrieved?  Maybe you need to look at the history of the action you are calling this value from to see if you have typed it correctly - assuming you are using an expression?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[ninjaryder1st]

Thanks Damien @DamoBird365,

The dynamic value I was attempting to use was an employee email entered  into the SP List.  This email address identifies anyone within the org and many details can be pulled under the get user profile action, though I'm not sure where that info is actually stored.   I was hoping to pull their user information (was thinking user UPN contains what I need), but using the SP dynamic value for the email entered is hung.   I checked this noting the email address was missing for my test.   Upon retesting with email correction, I now have a new flow error (bad request) for the prior step of "get item" for the SP item that was updated with the email.   

I question if I need the "get item" step or some other connector to get this to pull employee info from a "get user profile" command?

I corrected the above as there was a "limit column view" dynamic value that I removed..   Now the flow is stuck on the Get User Profile V2 command and is "re-trying" because I don't think I told the flow who the user was....by the email.   

The above dynamic value for User UPN appears to create the issue and is not correct.   I may need help writing a function to pull ID the User UPN from the email entered instead of the dynamic value.   

[DamoBird365]

Hi @ninjaryder1st 

If the email is stored in the list, you will need to Get Items or Item if you know the ID.  Have you implemented limit columns by view (advanced options of get item) - looks like you are getting an error because of a view that doesn't exist.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[ninjaryder1st · Accepted solution]

@DamoBird365 

I got it!   🙂    

I removed the limit column as it was too restrictive. 

Then used the Compose Data function, and generate the email address from the SP dynamic value... 

Then used the "Output" email of that Compose Data function to place into the next step for Get User Profile V2.  

Thanks for listening and helping me work this out 🙂