cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Officer365 User Search Result

HI,

 

I am facing problem with Office365User.SearchResult() method.

This method is giving 100 rows only.

Is there any setting for fetching all result data, or to increase result count upto 200.

Also can I put searchTerm : partial string on email id or on department.

 

My Problem is I am not able to fetch all user list.

 

Thanks.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Officer365 User Search Result

Hi Levina,

 

I am posting again as I didn't see the earlier post of mine. Just checking in.

The contents of my earlier posts is the following:

 

If you are using office365User.SearchUser() method, and using Controls to hold the search result, then please take a try to switch to a text Gallery, this would allow the item more than 200.

For searchterm, the description from the official article is the following:

Search string. Applies to: display name, given name, surname, mail, mail nickname, and user principal name.

We could use a TextInput value as the Search string, and it will work with partial string, based on the listed items in description.

5.PNG

Post back if you need any further assistance.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Officer365 User Search Result

Hi Levina,

 

I think here you are using Office365User.SearchUser() function, and take Controls to show the search results (I suspect it should be dropdown), right?

Please take a try to switch to Text Gallery, this should have the results more than 200 items.

For the partial string, we may take use of the Textinput as the searchitem, then input the search value in the Textinput box.

This should make the search work with partial string.

Adding some reference:

Office 365 users

Document Description of searchterm: 

Search string. Applies to: display name, given name, surname, mail, mail nickname, and user principal name

 

See my testing results:

5.PNG

If you need any further assistance, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Officer365 User Search Result

Hi

thank you for replying

 

Concatenate("Row Count : ", Text(CountRows(Office365Users.SearchUser())))

this function only give 100 rows

 

My Problem is i have users like

abc1@mnp.com

abc1@xyz.com

abc2@mnp.com

abc3@mnp.com

abc4@xyz.com

abc5@mnp.com

.

.

.

.

.

.

abc102@mnp.com

abc102@xyz.com

abc103@mnp.com

abc104@mnp.com

abc105@xyz.com

abc106@mnp.com

 

having mix domain name

i want user have email id like "xyz.com"

 

i want to list down all the user having this type of email id.

 

Users after rowid 100 are not faceing in text gallery.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,100)