Search by Phone Number

(1) Share

Report

Posted on by SC-08020752-0

Hi, Is there any ways to search a user by his/her phone number?

I tried this

Office365Users.SearchUserV2({searchTerm: "123"}).value
but it turned out for me that it searches only among text fields (names and emails)
 
 
I tried the graph http get request
Set(gResponse2,Office365Groups.HttpRequestV2("https://graph.microsoft.com/v1.0/users?$filter=businessPhones/any(c:c eq '377')","GET",""))
but it retrieves with URI path is not a valid graph endpoint
 
I tried a much simplier:
Set(gResponse2,Office365Groups.HttpRequestV2("https://graph.microsoft.com/v1.0/me","GET",""))
but it gives the same.
 
I also tried this graph request from powerautomate flow, (different HTTP request steps) but the same as from APP.
(even if i copy the request directly from graph explorer (where I can see the retrieved JSON at least for the /me.
 
I think I tried everything what is in my mind, but nothing worked for me.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

scalca 243 Moderator on at

Like (0)

Report

What you can do is to use Search() function from PowerApps.
For example

Search(Office365Users.SearchUserV2({isSearchTermRequired:false}).value, TextInputField.Value, TelephoneNumber)

SearchTerm:
Search string (applies to: display name, given name, surname, mail, mail nickname and user principal name)

Was this reply helpful? Yes No
mrcwojcik 53 on at

Like (0)

Report

In Graph API documentation you can check, that User query for mobilePhone allows only for looking by "eq", "startsWith" or checking if field is null.

Advanced query capabilities on Microsoft Entra ID objects - Microsoft Graph | Microsoft Learn

Best way to handle this, would be fetch all Users and filter list in flow/app.

Was this reply helpful? Yes No
SC-08020752-0 2 on at

Like (0)

Report

I've already considered to fetch all the users:
- but as I know the searchuser fetches only the first 1000. we have 30-40 thousand of user.... It seems to be not really feasible in terms of time, data amount etc.
I can't believe that there is no way on server side to perform this operation. (In an relational DB to search over 40T record - even substring search is ridiculously low effort - in MS word it is impossible operation ). :-( :-( :-( :-( :-( :-( :-( :-( :-(

Was this reply helpful? Yes No