Unanswered

SharePoint REST API Call with Power Automate - Get user profile

(0) Share

Report

Posted on by DarenD

133

I’m very new (like this is my first time) trying to do this and could use a little help in working out the process. I’ve reviewed, literally, dozens of websites and I can’t seem to find one that has helped. Pretty sure it’s me!

I would like to use Power Automate to pull the following fields, employeeid and employeeOrgData

, from the SharePoint User Profile using the respondent’s email from a MSFT FORM. I’m currently pulling other data from AAD using the O365 Get User & Manager connector, so I can use fields from that if needed to pull the right data from the SharePoint User Profile. Once the data is received I will need to populate fields in a SPO list.

I’m positive this has been done before, can anyone help me with how to do this?

Categories:

Using connectors

I have the same question (0)

All responses (10)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @DarenD

To get all properties of the current user you could use the below REST API

_api/SP.UserProfiles.PeopleManager/GetMyProperties

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

abm,
that did seem to work in connecting me to the SPOL User Service. Does it work the same way if trying to get data from Graph? I'm trying to specifically get the employeeid and employeeOrgData. None of those are returned when I ran my HTTP Request.

Resource Link: https://docs.microsoft.com/en-us/graph/api/resources/user?view=graph-rest-1.0#properties

Connector Configuration:

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

abm,
Just to add some clarification I also did a the sample test in the link I provided and this is what I received back:

Error: But I'm actually in the tenantThis is the code I used

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @DarenD

Thanks for the reply. Is this a sync issue?

About user profile synchronization - SharePoint in Microsoft 365 | Microsoft Docs

Thanks

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

I don't think so since the tenant I'm using is cloud only no On-Premise activities.

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

I've also expanded the HTTPS so you can see the rest of the information:

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @DarenD

Whats the HTTPS JSON data looks like? Is that contains the schema names you after?

Thanks

Was this reply helpful? Yes No
DarenD 133 on at

Like (1)

Report

Here's the JSON from All Users Code & Specific User using UPN

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @DarenD

Try Get user profile (V2)

Then add a compose action step and try the below expression to get the employeeid

outputs('Get_user_profile_(V2)')?['body']?['employeeId']

Thanks

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report

Hi were you ablee to get employeeOrgData without premium connectors?

Was this reply helpful? Yes No