cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MelindaK
Level 8

Office 365 Profile Information - get user department

Hi all,

 

I am building a Power App on which I would need the user department to filter the views accordingly. 

I am using the Office 365 Users connection and I can successfully get the Display Name, Given Name, Telephone Number, etc. of the current user. But I can't get the user Department... 

 

For testing I am using a text box with the following Text formula:

 

DisplayName.png

 

Department.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have seen a previous post which was suggesting that an Azure AD needs set up. I have check with our systems team and we do have that set up. The Department column is populated in both Office 365 Admin Centre as well as on Azure side. 

 

Admin.png

 

 

 

 

 

 

 

 

 

 

 

 

On the app side though I do not get any erros, it just doesn't show anything when I'm asking for the department. 

 

 

Can anyone help me with this?

 

Thanks,

MelindaK

MelindaK
4 REPLIES 4
Community Support Team
Community Support Team

Re: Office 365 Profile Information - get user department

Hi MelindaK,

 

In my App, I had a connection to Office 365 Users, and I inserted a Text box and set its Text property to show information about current user, for example: Office365Users.MyProfile().DisplayName, it worked well and user DisplayName was shown. When I set its Text property to show user Department, I got the same issue with you, no error message and no user Department information was shown. And I also tried to show information about another user, I can also get information about DisplayName, ID, etc. but I can’t get Department information.

 

As for your Department column was populated in both Office 365 Admin Center as well as on Azure AD, there was nothing wrong with your settings, please send a feedback to Microsoft. The feedback icon was shown as a smile face in your App.

simle.PNG
                         


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MelindaK
Level 8

Re: Office 365 Profile Information - get user department

Thanks for that Mabel Mao, I have sent them a feedback Smiley Happy

 

Regards,

MelindaK

MelindaK
MelindaK
Level 8

Re: Office 365 Profile Information - get user department

I have just heard back from Mirosoft saying that is an outstanding bug with the Office365 user connector where it doesn't display a documented property. 

 

If anyone has the same issue, I guess we just need to wait until they fix it.

I'll update the post if I have any further info :). 

MelindaK
IMDEcolab
Level: Powered On

Re: Office 365 Profile Information - get user department

Just asked the Flow people about this. It is a limitation of the connector. The Microsoft Graph API supports filtering on department, but it is not exposed by the connector. They are currently working on a fix.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,174)