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
Highlighted
Community Support
Community Support

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.
Highlighted
Community Support
Community Support

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.
Highlighted
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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,338)