Unanswered

Create a gallery of users with specific job title

(0) Share

Report

Posted on by MataiLeak

I am trying to create a gallery of employees with a specific job title.
I've tried to use the following filter for the Items, and my gallery is blank:

Filter(Office365Users.SearchUserV2().value, JobTitle = "Technician")

I've also tried this with adding "top:9999" and "isSearchTermRequired: false" to the search parameters, and it returns blank.

When I use this filter:

Filter(Office365Users.SearchUserV2({searchTerm: "f"}).value, JobTitle = "Technician")

The gallery does fill with all technicians with a name starting with "f".

Any ideas on what's going on here or how to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MataiLeak

Try this:
// create a collection ClearCollect( colUsers, Office365Users.SearchUserV2({top: 999, isSearchTermRequired:false}).value ); // filter the colllection Filter( colUsers, JobTitle = "Technician" )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
MataiLeak 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Still getting the same issue. The collection is blank unless I pass a searchTerm.

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@MataiLeak

I did a test and I get records in my collection:

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
MataiLeak 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, it looks like the problem is that searchUser only returns 999 results, and my search pool is around 5000. So the collection fills, but technicians are not in the top 1000 employees. Is there any way around that cap?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MataiLeak ,

If you want to collect all users , please try:

I did a sample for you.

1\ Add a button control and set its onselect property to:

Clear(Col);Set(varNextlink,Blank());Set(varNextlinkTemp,Blank());Set(varSkiptoken,"");With(Office365Users.SearchUserV2({searchTerm:"",isSearchTermRequired:false}),Collect(Col,ThisRecord.value);Set(varNextlink,ThisRecord.'@odata.nextLink');Set(varSkiptoken,Mid(varNextlink,Find("skipToken",varNextlink)+10)));Set(varNextlinkTemp,varNextlink)

2\ Add a toggle control and set its Default property to:

If(varNextlinkTemp=Blank(),true,varNextlinkTemp=varNextlink,false,true)

Set the toggle's OnCheck property to:

Set(varNextlinkTemp,varNextlink)

Set the toggle's OnUncheck property to:

If(varNextlink=Blank()&&varNextlinkTemp=Blank(),Blank(),With(Office365Users.SearchUserV2({searchTerm:"",skipToken:varSkiptoken,isSearchTermRequired:false}),Collect(Col,ThisRecord.value);Set(varSkiptoken,Mid(ThisRecord.'@odata.nextLink',Find("skipToken",ThisRecord.'@odata.nextLink')+10));Set(varNextlink,ThisRecord.'@odata.nextLink')))

Set the toggle's visible property to:

false

Best Regards,

Bof

Was this reply helpful? Yes No