cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Org Browser - Grouping Job Titles

Hi All, I'm working off the Org Browser PowerApp template and am just about completed. Just need this one last "issue" sorted. 

 

I've been able to successfully add a Search by Department and Search by Job Titles to the template. What we've found however is that we just have way too many Job Titles in the organisation and would like to better group these Job Titles into a parent group/title so we can go from 50 Job Titles listed to 9. For example instead of having "Acting Technician", "Supporting Technician", "Leading Technician", it can be grouped as simply "Technician" and then lead to a new screen where it shows all users with the already mentioned Technician Job Titles. 

 

Because I had some issues pulling the Job Titles using the Office365.SearchUser formula due to getting a whole bunch of duplicates and empty slots, I instead hard coded in the job titles using the following (Not ideal but it works):

 

["JobTitle1", "JobTitle2", "JobTitle3", "JobTitle4"]

I then have that go to another screen where it shows the users that match the selected Job Title using the following:

 

Filter(Office365Users.SearchUser({searchTerm:"",top:500}),JobTitle=GallerySearchUser_5.Selected.Value
)

Is there a way I can alter this code so it shows all user based on the selection made? Remembering that "Technician" isn't a group, attribute or anything in O365 or AD.

 

Hoping what I've said actually makes any sense! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Org Browser - Grouping Job Titles

Hi @Raysie ,

 

Do you mean you select "Technician" in first gallery, then turn to next screen to show all  "Acting Technician", "Supporting Technician", "Leading Technician" users?

If my understanding is right, please modify your second formulas as below:

Filter(Office365Users.SearchUser({searchTerm:"",top:500}), GallerySearchUser_5.Selected.Value in JobTitle)

Note: The hard coded job titles should be some part of string of JobTitle.

Annotation 2019-10-21 141803.png

Best regards,

Sik

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Org Browser - Grouping Job Titles

Hi @Raysie ,

 

Do you mean you select "Technician" in first gallery, then turn to next screen to show all  "Acting Technician", "Supporting Technician", "Leading Technician" users?

If my understanding is right, please modify your second formulas as below:

Filter(Office365Users.SearchUser({searchTerm:"",top:500}), GallerySearchUser_5.Selected.Value in JobTitle)

Note: The hard coded job titles should be some part of string of JobTitle.

Annotation 2019-10-21 141803.png

Best regards,

Sik

 

View solution in original post

Highlighted
Frequent Visitor

Re: Org Browser - Grouping Job Titles

Thanks so much for responding!

 

Yes, your understanding is right and this is an interesting way of working around this. The only issue I should also add to that is there are multiple crossover keyword Job Titles. For example Managing Principal Solicitor and Principal Solicitor will technicially be seen as seperate Job Title groups and as such I wouldn't want them both showing combined results when selecting Principal Solicitor. 

 

 

 

Thank you though, I'll still test this out and see how it works practicially. 

 

 

Highlighted
Frequent Visitor

Re: Org Browser - Grouping Job Titles

*Double Post*

 

 

Highlighted
Community Support
Community Support

Re: Org Browser - Grouping Job Titles

Hi @Raysie ,

 

How are you getting on with it?  it seems to require a much clearer Job Title classification mechanism. 

Please let me know if any issues.

Best regards,

Sik

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,012)