Unanswered

Search By JobTitle

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Does anyone have a solution for searching by JobTitle using either Sharepoint Person-type column or Office365Users connector?

Goal:

- Enter JobTitle keyword

- Return list of employees with keyword in JobTitle

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (22)

Answers (0)

Sort by

BenFetters on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

I've never had to do that yet but I would maybe try something like this:

Have an text input control on the screen and where you can type the Keyword. Then try setting the "Items" property in the gallery to something like this: If(IsBlank(TextInput1.Text),Office365Users.SearchUser(),Filter(Office365Users.SearchUser(),TextInput1.Text = JobTitle))

I actually just tried it and it works! You could also use a similar formula with the same idea if you just wanted a simple combo box. I assumed you wanted a gallery.

Also, instead of putting in the "=" you could have "Contains" which would make the search a little better. Or you could try having a combobox with all the job titles available.

Let me know if you have any questions,
Ben

Was this reply helpful? Yes No
BenFetters on at

Like
a
(1)

Report
Copy link

Link copied!

Actually, instead of "Contains" it would be "in".

Kind regards,
Ben

Was this reply helpful? Yes No
seadude 1,855 on at

Like
a
(1)

Report
Copy link

Link copied!

Can't wait to try this out tomorrow! Thanks @BenFetters, will report back.

Was this reply helpful? Yes No
Dawidvh 1,346 on at

Like
a
(3)

Report
Copy link

Link copied!
Hi Eric,

How many users and groups in your tenant? If you don't pass any paremeters to the SearchUser api it will only return 100 users.
Filter(Office365Users.SearchUser(),JobTitle="Boss")
If you need more, you can pass the following to get 500 as a maximum.
Filter(Office365Users.SearchUser({searchTerm:"",top:500}),JobTitle="Boss")
If you have more than 500 user\groups, you would have to create multiple calls and write the answers to a collection.

Also consider writing the result into a collection and then display the collection in a gallery, instead of using the Office365Users connector directly in the gallery items.

Let me know if you don't come right.

twitter: @DavesTechTips
youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw
>>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DavesTechTips,
Is there a simple way to collect groups of 500 and append them to the same collection?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BenFetters,
I have > 500 AD entries so this method is not working as its written. I'm not exactly clear on how to collect > 500 AD records at a time.
Thoughts?

Was this reply helpful? Yes No
BenFetters on at

Like
a
(0)

Report
Copy link

Link copied!

I would maybe try going to File, App Settings, Advanced Settings, and then changing the row limit to 2000 I believe is the max. But if that doesn't work, I would try doing a ClearCollect on the OnVisible or OnStart on your home screen or another screen to collect all the users, then you could just filterthe collection of people based on what you typed in.

Does that make sense?

Also, the Org Browser app template could maybe give some other ideas.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BenFetters and @DavesTechTips,
No go. Looks like the limit is 999 even with AppSettings/Max set to 2000
If you try "" or 0, it pulls a default of 100 records. I need more than 999.
Ideas?

Was this reply helpful? Yes No
BenFetters on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe try taking a look at this video by Shane Young, if I remember right he solves this problem.
Hopefully this helps!

Shane Young Search User

Was this reply helpful? Yes No
BenFetters on at

Like
a
(1)

Report
Copy link

Link copied!

Basically what he seems to be doing in the video though is he adds an input text control, and then sets the items property to Office365User.SearchUser({searchTerm: TextInput1.Text, top: 999})

Then he turns the IsSearchable property on the combo box to false. He'll walk you through it better than I can explain it but essentially that's what he does to solve the problem. You would just need to filter that formula down a little as you've done before and I think it should work!

Let me know if you have any questions!

Was this reply helpful? Yes No