web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Org Browser - Grouping...
Power Apps
Answered

Org Browser - Grouping Job Titles

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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! 

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    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

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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. 

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    *Double Post*

     

     

  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    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

  • DTTN Profile Picture
    77 on at

    Hello,

    I am trying to add the Search by Department to my Org Browser. Are you able to shed some light on how you've done this?

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard