Display Only Office 365 Active Users In Power Apps Combo Box

People use the Power Apps Combo box for different applications, such as the Customer Feedback application, where we can use a Combo box to let users select the type of service they are providing feedback on (e.g., product quality, customer service, delivery experience).

Recently, while making a Power Apps application, a client asked me to show all the Office 365 users in a Power Apps Combo box control. When I displayed it, it gave me all the Office 365 User names, including all the inactive/blocked user accounts.

However, I did not want to retrieve users who were already inactive in the organization. Then, I researched and found that in the Power Apps Office 365 connector, a parameter called AccountEnabled helps get only active users.

For example, in the image below, you can see a blocked user in my organization (Lynne Robins). While retrieving all the users from Office 365, it gave me her account in the Power Apps Combo box, where I wanted to get only the active users.

In this article, I will tell you how to display only Office 365 active users in a Power Apps Combo box control and discuss how to show all the Office 365 active users in a Power Apps form Combo box Data card with a few examples.

Display Only Office 365 Active Users In Power Apps Combo Box

Usually, to get all the Office 365 users in a Power Apps Combo box, we write the code below that gives us all the user names or emails, including inactive user accounts.

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

Where,

cmb_EmpName = Combo box control name

However, to get all the Office 365 active users from the organization, we need to use the Power Apps Filter function and one Office 365 User connector parameter called AccountEnabled, which always gives a Boolean value (true/false).

1. To workaround with it, select the Combo box control and set its Items property as:

Filter(Office365Users.SearchUser({searchTerm: "", top: 999}), AccountEnabled = true)

OR

Filter(Office365Users.SearchUser({searchTerm: cmb_EmpName.SearchText, top: 999}), AccountEnabled = true)

NOTE:

Before implementing the above code, ensure to connect Power Apps Office365Users connector in your canvas app to avoid any kind of error.

2. Next, go to the Display tab (from the Properties pane) -> Edit -> Select DisplayName in both the Primary text and SearchField properties dropdown, as shown below.

3. Save, publish, and preview the app. If you expand the Combo box control, it will show you all the active users from the Office 365 Users connector. Also, if you search for a particular blocked username, it won’t be visible.

This way, we can get all the Office 365 active users in a Power Apps Combo box control.

Show Only Office 365 Active Users in a Power Apps Form Combo Box Data Card

Let’s say there is a Power Apps form, and inside it is a Person field with a Combo box control (Employee Name). Now, I want to display all the Office 365 users who are active inside the organization, as shown in the image below.

1. To achieve this, select the Employee Name Combo box control and set its Items property to the code below:

Filter(Office365Users.SearchUser({searchTerm: DataCardValue2.SearchText, top: 999}), AccountEnabled = true)

Where,

DataCardValue2 = Combo box control name

NOTE:

However, if you are using the Power Apps form, you must enter the Combo box Datacard value name in place of the Combo box control name.

2. Go to the Display tab (from the Properties pane) -> Edit -> Select DisplayName in both the Primary text and SearchField properties dropdown, as shown below.

3. Once you preview the app and expand the Employee Name combo box, you can see all the Office 365 active users.

In this tutorial, I have covered how to display Office 365 active users in the Power Apps Combo box control. We also saw how to get all the active users from the Office 365 users connector in a Power Apps form combo box data card, along with a few examples.

I hope you found this article helpful.

You may also like some more Power Apps articles:

• Create a Horizontal Scrollable Gallery in Power Apps
• Sort Power Apps Data Table Based On SharePoint Choice Column
• Concatenate Power Apps Combo Box Value With a Custom Value
• Sort Power Apps Combo Box Items
• Get Modern Combo Box Selected Values in Power Apps
• Set Combo Box Value On Button Click in Power Apps