web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Power Apps

Suggested Answer

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation