Return a collection of everyone on my organization with a certain job title

(0) Share

Report

Posted on by colbyturybury

363

When I run this code it only returns a single name not all of the names.

ClearCollect(colVPElec, Filter(Office365Users.SearchUser(),JobTitle = "VP Engineering" ));

Afterwhich I want to additionally filter by department and get one name but right now I want to retrieve everyone with the VP Engineering job title

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

fnanfne 260 on at

Like (0)

Report
Hi colbyturybury

Wow that's weird! I thought of suggesting to filter outside of your collection, but I'm getting the same result. However, only with one specific job title. When I use other job titles, it works.

Could you give that a go?

So for example, in a gallery's Items property, add the filter like so...
Filter(colVPElec, JobTitle = "VP Engineering")

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report

I am generating the collection from a button press with my above code. It is communicating with Active Directory so I need to be using the Office365Users connector.

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report
I've just done some digging and it looks like the Office365Users connector only returns 100 results! Found this out by adding a label control with the following in the Text property

CountRows(colVPElec)

When I collect, it only shows 100. Hmmm

I wonder if this limit can be increased, or the filtering done on Office365, before collecting in PowerApps?

Was this reply helpful? Yes No
fnanfne 260 on at

Like (1)

Report
I managed to find a solution.

Still filtering outside your collection, you can grab all staff (up to 999) with this

ClearCollect(colVPElec, Office365Users.SearchUser({top:999}))

Now, once you have this collection, you can filter.

You may get the filter+collection in one go though I have not been successful with that

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report

How do I only look for those with the Job Title, "VP Engineering"?

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (1)

Report

Got It!

ClearCollect(colVPElec, Filter(Office365Users.SearchUser({top:999}),JobTitle = "VP Engineering" && Department = "Electrical").DisplayName)

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report
Like I always like to say; there are many ways to scratch a cat.

What I've done to test is to

1) Create the collection of all staff (assuming the total staff is less than 1000!) using a button. Add this to the button's OnSelect property.

ClearCollect(colVPElec, Office365Users.SearchUser({top:999}))

2) Add a gallery and in its Items property, add the following

Filter(colVPElec, JobTitle = "VP Engineering")

I've added a dropdown with all the job titles, then you can select whichever job title you want from the dropdown, and then the gallery will update accordingly. Like this....

Filter(colVPElec, JobTitle = Dropdown.SelectedText.Value)

You can also add additional controls/dropdowns/Text fields, to further filter your collection.

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report

Nice one, it works!

Was this reply helpful? Yes No