Unanswered

Automatically ceate emails for users with the same name

(0) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
dreavisPH 15 on at

Like (0)

Report

This worked perfectly! Thank you!

Was this reply helpful? Yes No