Employee Contact List - Show all Users

[Sirah1983]

Hi all

I have started building a Employee Contacts list using the Office 365 Connector within a data table.

Everything is working fine it shows all enabled accounts and works like a dream but I need it to show all users as soon as you launch the app and give the user the option to search if needed - the search is working fine also. 

Currently the DataTable's items table shows

If(!IsBlank(Trim(TextSearchBoxA.Text)), Filter(Office365Users.SearchUser({searchTerm: Trim(TextSearchBoxA.Text), top: 15}),AccountEnabled))

Is there anything I can do to show all users listed?

Thanks all!

[v-siky-msft]

@Sirah1983 

If you want to show all Users, What you can do is to increase the number of users that is returned by SearchUser, for example, using the expression below:

Office365Users.SearchUser({top: 500})

that will return the 500 Users in your directory

Sik

[Sirah1983]

Unfortunately this is kinda what I have already I just want all users shown in a list, then give the user an option to search for a particular user within that list.

[rebeccas]

I have input box for my Search - box_Search

The on the gallery the Items is:

Sort(Office365Users.SearchUser({searchTerm:box_Sear, top:100}),DisplayName,Descending)

When it says "top:100" that just means that is all it shows at a time but the search will search all. Just the screen is slow if you try to show to many at once.

[Sirah1983]

Thanks for this, this makes sense but still having problems.

I have just created a Input button and set the OnSelect to be 

OnSelect'Sort(Office365Users.SearchUser({searchTerm:TextSearchBoxA,top:100}),DisplayName,Descending)'

But nothing happens?

[rebeccas]

Why did you put that on the OnSelect instead? You want the list to show blank until they start typing or something?

[Sirah1983]

No, I wanted to see if a button could set the search to do the below... 'Sort(Office365Users.SearchUser({searchTerm:TextSearchBoxA,top:20}),DisplayName,Descending)'

I'm using a datatable to display users contact details and not gallery is there another way I just want users to launch the powerapp and all users are shown without doing anything then if they want to use the search option they can.

[v-siky-msft]

@Sirah1983 

Do you mean you want to use a search button to control the filter?

If so, please refer this:

1. add a search box. and a search button.

2. set OnSelect of search button:

Set(VarSearchText, Searchbox.Text)

3. set Items property of data table: 

Sort(Office365Users.SearchUser({searchTerm:VarSearchText,top:100}),DisplayName,Descending)

Sik

[Sirah1983]

Great this kinda worked but its showing all AD accounts and even disabled ones I did try

Sort(Office365Users.SearchUser({searchTerm:VarSearchText,top:150}),AccountEnabled,DisplayName, Ascending)

But this didn't work...

[v-siky-msft · Accepted solution]

@Sirah1983 

 If you want to show enabled accounts, please modify your formula as below:

Sort(Filter(Office365Users.SearchUser({searchTerm: VarSearchText, top: 100}),AccountEnabled),DisplayName,Descending) 

Sik