SharePoint REST API Call with Power Automate - Get user profile

[DarenD]

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?   

[abm]

Hi @DarenD 

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

_api/SP.UserProfiles.PeopleManager/GetMyProperties

[DarenD]

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:

[DarenD]

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

[abm]

Hi @DarenD

Thanks for the reply. Is this a sync issue?

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

Thanks

[DarenD]

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

[DarenD]

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

[abm]

Hi @DarenD 

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

Thanks

[DarenD]

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

[abm · Accepted solution]

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

[Ianhall1892]

Hi were you ablee to get employeeOrgData without premium connectors?