Filter Office 365 by Location

[Samo2005]

Hi guys, 

I wonder if someone can help. I am new to PowerApps so be gentle :).

I can connect PowerApp to Office 365 users and I can retrieve user details. However, is there a way of filtering by Office (which we user for branch location) I have 12 branches and people don't know each other let alone name so I was hoping as well as finding by name is to filter by location and from there browse to the branch manager, assistant or sales etc...

Thank you

Wessam

[gabibalaban · Accepted solution]

Hi @Samo2005 ,

Is your organization a large one (more ther 1000 people - from what I know that's limit retreived by Office365Users.SearchUserV2() ?

If no, here is my thoughts:

- use a dropdown control (LocationDropDown) and a gallery control (ShowPeopleFromLocationGallery) and set this properties:

LocationDropDown: Items ->

Distinct(Office365Users.SearchUserV2({top:999}).value,OfficeLocation)

ShowPeopleFromLocationGallery -> 

Filter(Office365Users.SearchUserV2({top:999}).value,OfficeLocation=LocationDropDown.Selected.Result)

You must have completed data in your AzureAD about all users.

Hope it helps !

[Samo2005 · Accepted solution]

Thank you very much. You are a star.

Regards

Wessam