Filter a combo box to only show certain email domain

(1) Share

Report

Posted on by colbyturybury

363

I have a combo box, Currently when searching for a user to assign a task it shows every single email address that my company has ever sent. I only want users from my company to be options. Right in the items section of the combo box I have this script.

Office365Users.SearchUserV2({searchTerm:Trim(Self.SearchText), top:10}).value
 
How would I filter out the results to only show lets say "autodesk.com"?
 
Below are the fields I have displayed in the combo box.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (6)

Answers (0)

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you explain what you mean by I only want users from my company to be options.

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report
Copy link

Link copied!

Options meaning those people I work with are the only selectable option in the drop down list that can be selected.

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

https://learn.microsoft.com/en-us/connectors/office365users/#get-user-profile-(v2)

You can only pass the user that you are searching for and select these values

user resource type - Microsoft Graph v1.0 | Microsoft Learn

I assume that you want to find the users for a particular department or some other user property

You would apply a filter to the results returned from the search

In theory something like

Filter(
Office365Users.SearchUserV2({searchTerm: "", top: 100}).value,
Department = Dropdown_Departments.SelectedText.Value
)

You refer to autodesk.com, not sure what that means but you need to identify the property that you want to search for ensure that it is populated in Actvie directory

If this answered your question please mark it as such

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report
Copy link

Link copied!

Sorry but I am looking for anyone in my organization. I figure I would filter by our company's email which is "pec1.com".

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you tested it with something like and it isn't working?

Filter(
Office365Users.SearchUserV2({searchTerm: "", top: 100}).value,
EndsWith(Mail, "@pec1.com")
)

I used mail here because I don't know the name of the field containing the email being returned in your environment

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Something like this should work assuming that the email column is called Mail

Filter(
Office365Users.SearchUserV2({searchTerm: "", top: 100}).value,
EndsWith(Mail, "pec1.com")
)

Was this reply helpful? Yes No