Answered

Office365Users SearchUserV2 Filter options

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

@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
Copy link

Link copied!
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