Does anyone have a solution for searching by JobTitle using either Sharepoint Person-type column or Office365Users connector?
- Enter JobTitle keyword
- Return list of employees with keyword in JobTitle
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,
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.
If you need more, you can pass the following to get 500 as a maximum.
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.
>>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.<<
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.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand