Unanswered

Office365 seach help needed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey, So for my office.searchusers it searches properly from the start of the name but I would like it if I could search midname -

E.g. instead of typing 'John' to find my colleague "John Doe" I'd like to be able to type "ohn"

I know it sounds like a weird request but it would help me sort out a bigger function that powerapps apparently doesn't handle properly 🙃

EVEN BETTER

If possible I'd like a way to search based on two fields -

Field 1 = "Jo"

Field 2 = "Do"

And it should display "John Doe"

Thanks in advance for attempting to help ^^

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Try this:
Filter(Office365Users.SearchUser(),"Jo" in DisplayName)
For example, this formula returns my profile!
Filter(Office365Users.SearchUser(),"ott" in DisplayName)
or
Filter(Office365Users.SearchUser(),"er" in DisplayName)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for getting back to me @Anonymous
The filter doesn't work unfortunately because of the quantity of users in my office365 user directory (20k+)
The Office365Users.SearchUser({searchTerm:Text}) is able to grab the results that start with Text on the first and last name -
If Text = Hi, the Office365Users.SearchUser({searchTerm:Text}) will return names such as Hillary Jacobs, Hink May, Bobby Histon and Mark Hithe but it won't return Thillary Jacobs, Shinka Par etc which is what I'm aiming for.
Know any way to solve this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, no. The only solution I could come up with was the one I posted.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you try to use the below expression:

Search(Office365Users.SearchUserV2().value,TextInput1.Text,"DisplayName", "Mail")

You need to add the columns manually where you want to search the results.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No