SharePoint Online User Information list Email column returns blank value

Copper Contributor

Hello Everyone,

I have created an unlicensed user in Microsoft 365.
I have shared the SharePoint site with that user.

When I tried to get data from the User Information List I did not find the Email of that unlicensed user.
Also, I have checked "Work email" under SharePoint User Profiles but it is blank.
Why does the user "Work email" field return a blank value? 


2 Replies
The user profiles are managed by Azure AD, please check whether the specified user has the work email in Azure A-D>User info
Thanks for the response.
I am confused about why some of the users contain email and some of the users do not contain email even creating the user using the same method.