Unanswered

Employee Directory O365 - Drop down filter by JobTitle and CompanyName

(0) Share

Report

Posted on by CVannest

150

I am in the process of building a company employee directory. I have the basics in it where I can search for someone an return the result but it's only by Displayname. I'd like to have drop down filters that are populated by "CompanyName" and another populated by "JobTitle" from the Office365Users data source.

If a user selects a CompanyName from the drop down the only results returned would be employees that match that company name. Same goes for JobTitle but I would also like them to be used on conjunction with each other. I select a CompanyName and then narrow it down further by selecting a JobTitle.

I'd also like to just be able to search by JobTitle in my main Search bar where I can search by DisplayName. I've looked through at least 50 posts on here about Employee Directories but saw nothing that really fit. My frame up is below in the image.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

CVannest 150 on at

Like (0)

Report
Copy link

Link copied!

I've got the ComboBox's set to display the items from Office365Users for JobTitle and CompanyName using
Distinct(Office365Users.SearchUser(),JobTitle) and Distinct(Office365Users.Searchuser(),CompanyName)

Just looking for the filter options to put on the gallery to let you filter down the results based on the combobox.

Combobox for JobTitle is JobTitle1
Combobox for CompanyName is CompanyName1
Search box is TextSearchBox1

Gallery is UserBrowseGallery1

Was this reply helpful? Yes No
CVannest 150 on at

Like (0)

Report
Copy link

Link copied!

I should add that I have about 15,000 employees in the company so I think the basic search result only returns the first 500? Read something about a collection, but not very familiar with that piece.

Was this reply helpful? Yes No
CVannest 150 on at

Like (1)

Report
Copy link

Link copied!
Okay so I'm onto something here.
Instead of ComboBox's I did DropDowns with the below code and set their "Items" to lookup CompanyName and JobTitle (We have several hundred job titles and some are still missing when I set it to top 500)

Sort(Distinct(Office365Users.SearchUser(),CompanyName),Result,Ascending)
Sort(Distinct(ShowColumns(Filter(Office365Users.SearchUser({top:500}),!IsBlank(JobTitle)),"JobTitle"),JobTitle),Result,Ascending)
On my gallery Items I now have the below code.
I can search from the Search bar by user name and I can filter out the results by using the CompanyName_1 drop down, however the "JobTitle_1" dropdown does not produce any results. I also think I'm very limited due to how many employees we have so I could use some help in overcoming that issue.

If(IsBlank(CompanyName_1.Selected.Result) And IsBlank(CompanyName_1.Selected.Result), Filter(Office365Users.SearchUser( {searchTerm:TextSearchBox1.Text,top:999}), AccountEnabled=true And IsBlank(JobTitle)=false), !IsBlank(JobTitle_1.Selected.Result) And IsBlank(JobTitle_1.Selected.Result), Filter(Office365Users.SearchUser( {searchTerm:TextSearchBox1.Text,top:999}), AccountEnabled=true And IsBlank(JobTitle)=false), !IsBlank(CompanyName_1.Selected.Result),Filter(Office365Users.SearchUser( {searchTerm:TextSearchBox1.Text,top:999}), AccountEnabled=true And IsBlank(JobTitle)=false And CompanyName = CompanyName_1.Selected.Result))

Was this reply helpful? Yes No
CVannest 150 on at

Like (1)

Report
Copy link

Link copied!
Due to the limitations of results returned, I'm taking a different approach.
I want to be able to have 3 search boxes at the top of my Employee Directory.
Search 1 = DisplayName search (EmpNameSearch) where users would search by name
Search 2 = CompanyName search (EmpDealerSearch) where users would search by Dealership name "CompanyName"
Search 3 = JobTitle search (EmpTitleSearch_1) where users would search by a Job Title "JobTitle"

All of these are fields available in Office365Users so I'm hoping I can get a filter on the Gallery that would allow users to search in any of these boxes.

Right now I have it so searching by Employee Name returns results with this coding since if a JobTitle is blank it means they are a service/generic account.

Filter(Office365Users.SearchUser({searchTerm:EmpNameSearch.Text,top:999}),AccountEnabled=true, IsBlank(JobTitle)=false)

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

Did you ever find a solution? I am having the same issue.

Was this reply helpful? Yes No