News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Display list of email ...

Power Apps - Building Power Apps

Unanswered

Display list of email addresses, in a combo box, using Office365Users

(1) Share

Report

Report

Posted on by CU10030646-0

28

Hi,

I'm trying to list the email id's of all the users in the organization, based on particular office locations.

I tried the following code in the Items property of the combo box

Office365Users.SearchUserV2({searchTerm:ComboBox1_1.SearchText}).value

It was working earlier, but gave irrelevant results. 

I want to add a filter condition to this code, which filters the email addresses, based on particular office locations.

The condition that I want to add is as follows,

OfficeLocation Not (["OfficeA", "OfficeB"]).

I'm unable to use the Not keyword as well, neither ! operator. It is throwing errors for both of them

Kindly help me with this, been stuck for long

Thanks,

Sneha

Categories:

Using Apps Using Formulas

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 40,661 Super User 2025 Season 1 on at

Like (0)

Report
Display list of email addresses, in a combo box, using Office365Users

Hi,

First, why are you having them type in something IN the combobox that you are loading. You should have a Search TextInput

What are the people typing in the ComboBox to search on??? I would recommend that you add a Search Text Box. Then you would do this

1. I added a TextInput called Search

2. i added a ComboBox calledEmailAdresses

In my ComboBox Items I put this

Filter(Office365Users.SearchUserV2({searchTerm: Search.Text}).value, OfficeLocation <> "OfficeA" And OfficeLocation <> "OfficeB")

And there you have it.