Azure AD B2C User export missing mail

Oliver Herklotz 6

Hello,
we need to gather the mail address from our Azure AD B2C users.

If I export the users the generated *.csv file is missing the mail address?!

Is it a known bug and is there any other way to get them?

James Hamil 21,621 Reputation points Microsoft Employee

2021-05-03T23:20:27.98+00:00

Hi @Oliver Herklotz , please make sure you have the email claim selected: https://stackoverflow.com/questions/45808409/how-to-get-email-address-from-azure-ad-b2c-authentication . The emails are probably not exporting because you don't have them selected. Please let me know if this works.

Best,
James
Jason Pettys 16 Reputation points

2021-11-05T17:58:37.357+00:00

I realize this looks like an older, abandoned question, but I'm having the same issue. I'm pretty sure my email claim is selected, as the email addresses are being collected and delivered as a claim to my app.

I'm in the Azure AD B2C Portal > All Users. All the records there are showing "Name" and "User name," and the "User name" is the user's real email address. When I click Bulk operations > Export CSV, the email address is not present in the CSV.

Super irritating that the export doesn't export the basic information on the screen. I'm just trying to tell a partner whether an email address exists in our system, and the portal really doesn't want to be helpful answering this question.