Search O365 Users in a Combobox in Power Apps
We can search all users in the tenant by adding the Office365Users connector to our Microsoft Power Apps.
❗
The Office365Users.The SearchUserV2 data source is intended for searching for users, not for displaying all users in the organization. There may be cases where the users are not shown in the dropdown until you search for them.
- Add Office365Users data connector.
- Add a ComboBox control.
- Enable searching in the ComboBox control.
- In the Items property of the ComboBox control, add the following formula.
Office365Users.SearchUserV2({searchTerm:Self.SearchText, top: 20})
When the user searches in the Combobox, it searches all users in Office 365 (using their Display Name by default).
We can also display additional fields in the ComboBox control to help find the correct user.
- Select the Fields property, and click Edit.
- Change the Layout to Double.
- Select the Primary Text and Secondary Text fields that you want to show. You can also change the SearchField here.
Subscribe to receive every post in your email inbox.
No spam, no sharing to third party. Only you and me.
