cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jkmc
Level: Powered On

Filter Office 365 users by CompanyName and OfficeLocation

Hi,

 

how can I filter office 365 users by OfficeLocation?, just show this value.

 

 

 show only users with values of "OfficeLocation" and add filters by name and Company Name

This is for all users: 

SortByColumns(UsuariosdeOffice365.SearchUser({searchTerm:TextSearch.Text});"DisplayName"; Ascending)  

 

Try with

SortByColumns(UsuariosdeOffice365.SearchUser({searchTerm:TextSearch.Text});"DisplayName"; Ascending)  && Filter(UsuariosdeOffice365.UserProfile().OfficeLocation; True)  &&  Filter(UsuariosdeOffice365.SearchUser({searchTerm: Dropdown.Selected});"CompanyName")


with errors.

 

Thanks.

 

COMPANY2.png

 

 

 

 

 

 

1 REPLY 1
v-zhta-msft
Level 8

Re: Filter Office 365 users by CompanyName and OfficeLocation

Hi @jkmc,

 

Would you please share me the formula in the drop down controller?

 

Because I can’t find the “companyName” field in my AAD and the value of the “companyName” in PowerApps is blank.

 

The “companyName” is a read-only property within user’s profile, please check the following article for more details:

 

https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user

 

Regards,

Zheng

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 192 members 5,451 guests
Please welcome our newest community members: