Automatically ceate emails for users with the same name

[dreavisPH]

Hi,

When we hire someone there information automatically populates in an excel sheet. I designed a flow that automatically creates the users email account in Azure AD. The problem comes when two users have similar names. Example Jason Smith and John Smith would both end up being jsmith@ and cause an error. How do I fix that?

[fchopo · Accepted solution]

Hello @dreavisPH 

In your excel file you could have 3 columns: Name, Primary Email, Secondary Email and do the following:

1) Get User in Azure AD with Primary ID

2) If the user is not found, it will throw an error, so you capture it and create the user with its Primary Email address.

3) If a user is found with the same Primary Email address, create the user with its secondary email address:

To capture the error in the "Create User - Primary email" you should do the following:

 

Hope it helps!

Ferran

[dreavisPH]

This worked perfectly! Thank you!