Flow to get all ad users in a SharePoint list

[eddy85]

Hi all,

I am trying to populate a sharepoint list with all my O365 users that have a mobile phone filled in. The list would function as our phonelist.

I did get it to work sort of except that all users get created a lot of times. I should have about 150 records but I have over 4000 🙂

First I perform a 'search for users v2' to get all my ad users. I then perform a filter for 'telephone number is not equal to null'. So by doing that I have all my users that have a phone number.

Finally I populate my list like this:

The final step keeps running for a long time creating loads of copies for all users. This is the first flow I ever made and I have no idea what I am doing wrong here.

[Mira_Ghaly · Accepted solution]

@eddy85 

I believe the problem is that these 2 nested apply to each loops