Answered

Employee Directory Filtering

(0) Share

Report

Posted on by mariesk

Hello

I'm looking to build a staff directory using Powerapps. I have got as far as creating a working directory by following this guide https://blog.pragmaticworks.com/create-an-employee-directory-in-powerapps The trouble is that it is including all of the shared mailboxes when I only want it to display the current employees. I thought I could get around this by adding a filter to only display results where a line manager has been assigned. I'm not quite sure how to edit my formula to exclude results where the line manager for a record is blank. This is what I have so far:

Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),CompanyName="mycompany1",AccountEnabled=true)

I also want to include multiple company names but if I change the formula to look for CompanyName="mycompany1" or CompanyName="mycompany2" it doesn't like it. I have tried using OR and IF statements but I'm not quite sure how to do it so any suggestions would be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

BCBuizer 22,539 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),CompanyName=

OR("mycompany1","mycompany2","mycompany3") //allows to add multiple company names

,AccountEnabled=true,

,Manager != "" //not sure if this works, but would add an extra criterium to make sure the this account has a manager
)

Was this reply helpful? Yes No
mariesk 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I tried just adding the extra company names first with your code and I got the error 'Incompatible types for comparison. These types can't be compared:Text, Error'. I'm not sure why it thinks this as it works with the company names separately, just not together.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,539 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Perhaps:

CompanyName= "MyCompany1" || CompanyName= "MyCompany2" || ....

Was this reply helpful? Yes No
mariesk 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you, that worked perfectly. I wasn't able to get it to filter out the records with no manager assigned so I filtered out the records without a job title instead which I managed to do with this code

Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),CompanyName="mycompany1" || CompanyName="mycompany2" || CompanyName="mycompany3",AccountEnabled=true,!IsBlank(jobtitle))

Was this reply helpful? Yes No