Power Platform Community Forum Thread Details

Hey there,

I am trying to create a filterable phone book for our company using Power Apps. For this, I am using the AAD Users Virtual Table that is provided as connector in Power Apps. I created a table showing the name, email, location and phone of all AAD users. Also, one column is showing the department a user is working at.

Since the AAD Users Virtual Table is not giving me the department value, I tried to get the Department Value of a user via the "Office 365 Users"-connector which is available in power apps. This is working so far.
Unfortunately, I am not able to filter this column by a search string input - I already tried the following formula to achieve this:

Filter('AAD Users'; AbteilungInput.Text in 'Office365Users'.UserProfileV2(Mail).department)

where AbteilungInput is the input text field where users can provide the name of the department they want to filter for.

Unfortunately, this is loading veeery slow since this solution first retrieves all users (we currently have >1000 users in our AD) and then looks up the department for each user using the Office365 Users connector. The problem is that even the Azure AD connector does not seem to provide the department of a user.

Is there any way to list all users and their departments and filter for the user department efficiently?

Categories:

Microsoft Dataverse with Power Apps