Get all phone numbers

[Ozcar]

I need to validate all users phone number and Im using an API from numverify.com. The validation part is ok but I cannot find a way to get all users phone number. The search action in the Office 365 Users connector is only returning max 999 users and we have way more users in our company. Is there any way to get all users information?

[v-xida-msft]

Hi @Ozcar,

Could you please share a screenshot of your flow's configuration?

Do you add a "Search for users" action of "Office 365 Users" connector within your flow?

If you want to use the "Search for users" action of "Office 365 Users" connector to retrieve all users information, I afraid that there is no way to achieve your needs in Microsoft Flow currently. This action only retrieve the user profiles that match the search term, in addition, the search term only applies to: display name, given name, surname, mail, mail nickname and user principal name.

More details about the "Search for users" action, please check the following article:

"Search for users" action of Office 365 connector

The users of your company may belong to different departments or Groups, if you want to retrieve all users information in your company, I afraid that there is no way to achieve you needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

[Ozcar]

Hi

Here is the screenshot showing a search that give me the phone number of the first 999 users. If I increase it to 1000 I get a message 

{
  "status": 400,
  "message": "One or more input values is invalid.\r\nclientRequestId: 727f64b1-b114-417c-a9a0-4b1af874d686",
  "source": "office365users-ne.azconn-ne.p.azurewebsites.net"
}

 

[Michal · Accepted solution]

Hi @Ozcar 

I guess in the "Search for users (V2)" there is no error. Just used 10000 as a limit without any problems. 

[Ozcar]

Thanks. Yes it works fine!

//Ozcar

[Michal]

As I checked it - it returns only up to 1000 records and no more. 

I am currently looking for a solution to that. 

[Michal]

The Search for users (V2) can return up to 5000 records

All you need to do is to change the pagination in Settings.

See this discussion