Answered

ComboBox Filter in Office365Users

(0) Share

Report

Posted on by indras111

Hi All,

I am new to PowerApps. I have built a simple data collection app and I would like to rollout a survey through this app. I have a combo box which is linked to office365Users data source. Is there any way i could restrict the combo box to be able to select employees who belong to one particular Country?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

shoog 2,164 on at

Like (1)

Report
You can set the Items property of your combo box to

Filter(Office365Users.SearchUserV2().value,Country="YourCountry")

Was this reply helpful? Yes No
indras111 22 on at

Like (0)

Report

Similar to Country, Is there a way to filter employee data for Regular Employees?

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report

If there is a property in your AD that designates "regular employees", you can use that property to filter similar to country.

Was this reply helpful? Yes No
indras111 22 on at

Like (0)

Report

Hi shoog, I really appreciate your prompt response. how do i check all available properties associated with my AD?

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on at

Like (0)

Report

The easiest way would be to create a datatable with Items Office365Users.SearchUserV2().value

You can then add all fields that could be interesting for you to find out what fields are populated in your AD.

Was this reply helpful? Yes No
indras111 22 on at

Like (0)

Report

Thank you shoog. I was able to do that. Unfortunately, the filed i was looking for not added in that dataset. But now i am able to understand how to find any such data fields. Thank you so much. I have already accepted your primary solution.

Was this reply helpful? Yes No
ziplock77 6 on at

Like (0)

Report

Did anyone else read this in Nancy Gribble's voice?

Was this reply helpful? Yes No
ziplock77 6 on at

Like (1)

Report

Greetings, shoog. Are there field property requirements? Primary Text or SearchField? Does it matter? I've got them set to DisplayName and JobTitle, respectively, but nothing returns.

I know the connector works and data populates, because I've tried the SearchUser and it will return lists. However, when I use the syntax required for SearchUserV2, I have no such luck. E.g.,

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

TIA for any thoughts on this.

Was this reply helpful? Yes No
subsguts 1,259 Moderator on at

Like (1)

Report

This doesn't work if you are using a combobox that allows the user to type in and have name come up. Today, I use the following:

Office365Users.SearchUser({searchTerm:cmbRequestor.SearchText})

However, changing this to V2, doesn't work at all, it gives garbage entries in the combo box and in addition it doesn't let the user type in the box to find the person they are looking for. Appreciate help on this as if this the original SearchUser goes away, I will need to completely re-program this to use a text box with some type of lookup, which would be a LOT more effort for something that shouldn't be needed. Why would they get rid of the ability to use a combobox with SearchUser?

Was this reply helpful? Yes No