cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Migrated_User Solution Sage
Solution Sage

Office 365 Profile Information - getting user manager

Content migrated from TechNet.  Post attribution to:  Hilary Stoupa

 

Hi - I am trying to follow this tutorial on connecting PowerApps to the Office 365 user profile data. I can get my own data or that of another user.

I can't get my Manager information. I've got the manager field filled out in my user profile in the SharePoint Admin Center in Office 365.

The error text is:

The service returned an error: office365users!Manager: {"status":404, "message": "No user found with the specified id.", "source": "127.0.0.1"}

I'm not sure how to debug this - anyone have any ideas?

Thanks

 

Error message

1 ACCEPTED SOLUTION

Accepted Solutions
Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

So - upon review with an MS Support Engineer, it appears the issue is that to use .Manager or .DirectReports, I need to have Azure Active Directory set up. This makes sense - I had assumed these functions would be using my SharePoint user profile information, but they are not.

View solution in original post

16 REPLIES 16
Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Does TextBox2 contain the email address (e.g., someone@example.com) of the user you want?

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Thanks for the response. Yes, it does. I used the same email address with office365users.UserProfile to return the user's display name and to verify I had a correct email address.

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Does it work if you add a text-input box (e.g., TextInput1), type the full email address (without quotation marks) in TextInput1, and update the formula in the text box to this?

office365users.Manager(TextInput1.Text).DisplayName

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

So - I may be misunderstanding you - but to set the default text for TextInput1, I have to have quotes around the text or I get an error there. Here are some screenshots.

First - the new TextInput1 field with a default to my manager's email:

Next, using the formula you provided - I get the same error here.

The service returned an error: office365users!Manager: {"status":404, "message": "No user found with the specified id.", "source": "127.0.0.1"}

Finally, here is a screenshot with UserProfile - you can see I get back his display name here, so it is just the .Manager method I'm having an issue with.

Highlighted
Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Don't set the Default property to the user's address; just type the address (no quotes) directly in TextInput1.

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Thank you for the clarification. I've done that and still have the same error of "no user found".

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Hi Hilary,

If you use the full email address then it will work.

We just tested and If you set the Text property of a text box to office365users.Manager("reliu@microsoft.com").DisplayName it should return Joe Wu. Which was a successful test on our end.

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Thank you. I did misunderstand one thing - I need to pass in the email address of the report whose manager I want, not the email of the manager.

So, I tried using my email address instead and typing it directly instead of using the value from another control. I'm still getting the 404 error.

Error

Here are my profile settings in the SharePoint Admin Center.

Settings

 

Migrated_User Solution Sage
Solution Sage

Re: Office 365 Profile Information - getting user manager

Hilary,

Whats a good email to contact you directly to work through this?

Thanks!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,289)