Answered

Office365Users SearchUserV2 Filter options

(0) Share

Report

Posted on by Community Power Pla...

Hello Everyone.

I recently build a People Picker for my organization since I needed to have a searchable combobox, where on select it shows the picture + telephone number + email for the selected person.

The problem however, is that I have no clue on where to find documentation for populating the combobox with only employees, and not service accounts, meeting rooms etc.

I am using the following expression for my Items in the combobox: Office365Users.SearchUserV2({top:500}).value

Is there any way to customize the expression so for example only user accounts with the "Zip or Postal code" filled out in Contact info are displayed in the search?

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (1)

All responses (7)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (2)

Report

@Anonymous

Consider the following for your app:

Filter(Office365Users.SearchUserV2({top:500}).value, !IsBlank(PostalCode))

This will filter out any account that does not have a postal code.

I hope this is helpful for you.

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

Like (1)

Report

Thank you so much for this! Exactly what I was looking for. Did not for one second think to put the Filter around the function. You sir, is a lifesaver 🙂

Was this reply helpful? Yes No
Lu_Mo 25 on at

Like (0)

Report

Problem here is that top:500 will be applied BEFORE the filter, in case there are more than 500 entries, those will not be taken in consideration.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Lu_Mo

Yes, in that particular formula, it is restricted to the top 500. If that parameter is not specified, then the top 1000 is the default.

Was this reply helpful? Yes No
Lu_Mo 25 on at

Like (0)

Report

Hi! Our company has ten thousands of entries... What I will do is to check in UserVoice if there is already an entry or I will create one: to be able to delegate a filter expression in Office365Users.SearchUser.

Was this reply helpful? Yes No
Lu_Mo 25 on at

Like (2)

Report

@RandyHayesin case you want to upvote it: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Office365Users-SearchUser-add-delegable-filter-expressions/idi-p/870321

Was this reply helpful? Yes No
mariagiugno 23 on at

Like (0)

Report
Hi @RandyHayes,

Do you know how I would filter by CompanyName or the Distribution List for that Company to display the emails in a dropdown?
This is what I have so far:

Distinct(Filter(Office365Users.SearchUserV2({searchTerm:COMP_designer.SearchText}),Mail), AccountEnabled, CompanyName = "Company Name"

Thanks for your assistance!

Was this reply helpful? Yes No