Is it possible to run a query to find which user profiles are missing a picture?

Copper Contributor

I believe the way to do this would be using CSOM, but I have not been able to figure out how. We user sharepoint online and our tenant has about 1300 user profiles. We build our organisational chart off this pool and we would like to make sure each user has a picture.


I hope someone here has some ideas.


Thank you,



3 Replies

You could use Get-PnPUserProfileProperty


Are you looking for PowerShell or code?







"Are you looking for PowerShell or code?" Which ever one would work.


The result I am looking for is a list of all users missing the profile picture property. The comand you gave me would require I look at the user profiles one at a time?