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?
Solved! Go to 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
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
This worked perfectly! Thank you!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
29 | |
20 | |
11 |